Simple Query viewer

Hi Guys,

Does anybody know where I can get a very basic view/add/edit script for
a single table/query? I need to view all the rows at the same time and
be able to edit from that point.

I have 4 fields called id, lowerval, upperval, result. Table is called
fig_lookup. I am very new indeed to mysql, so if you know of any basic
code which would suffice, or could post some that would be brill.

I am not after an advanced browser, as I want to be able to give users
the options to edit specific fields which I decide rather than complete
database control.

Thanks

Re: Simple Query viewer

Have you looked into phpMyAdmin? It's a very popular script for
maintaining databases through a web interface.

Re: Simple Query viewer

Yes thanks. Its good for Administrators, but I want to give users
access to just one table in a nice easy to edit format. For example
they can tick a box to edit a specific row, but with very basic
scripting which I can actually edit. I'm talking the grass roots of
MySQL so I can learn from it. I have played with PHPmyadmin but I need
something more customisable and less code.

Thanks

Re: Simple Query viewer

For a further example, I have some example code in a book (part of the
full code):

if (isset($left))
{
query = "SELECT id, name, email FROM addressbook WHERE id < $id " .
"ORDER BY id DESC";
$result = mysql_query($query);
check_mysql();
$row = mysql_fetch_row($result);
check_mysql();
if ($row[0] > 0)
{
$id = $row[0];
$name = $row[1];
$email = $row[2];
}
}

Problem is, this code means you have to scroll through each record.
What I would like is for all the results to be displayed and editable.
Therefore you rather than just having value="\php bits $name"> it would display lots of rows depending on the
query results.

Thanks

Re: Simple Query viewer

Hi,

There are 2 ways 2 do this.

First of all make listing scrren which display all records in page than
do 1 of the following

1. If you need all the records editable at same time.
Make edit button or link when you click on that it should display all
there records with text boxes and bottom of the page save button
displayed when you click all the records will be updated.

2. If you need only 1 records editable.
Make edit link in each row when you click on single records edit link
it should reload and only clicked recod should hold textboxes in only
single row not for all records.
When click on link after updating than it should updated in db.

As per my understanding about you requirement above are good solutions.

Regards,
Jatin

Re: Simple Query viewer

In article <1139253396.597888.183740@g14g2000cwa.googlegroups.com>,
UKuser wrote:
> Does anybody know where I can get a very basic view/add/edit script for
> a single table/query? I need to view all the rows at the same time and
> be able to edit from that point.
>
I'm new in PHP but perhaps that can help you.
Have a look at http://www.haldi.ch/her/ at the third icon!

You have to clean those scripts!

If it's OK here the script:
SCRIPT LIST
***********
require_once('config.php');
require_once('fonctions.php');

// Appelle l'affichage de la toolbar
require("toolbar.php");

// Affiche un message en dessous du toolbar
Mes('Famille','','400');

// Configure le script en suisse
setlocale (LC_ALL, 'nl_CH');

// Connection à la base de données
$db_link = openDatabase($db_hostname, $db_username, $db_password,
$db_name);

// Tri seleon la colonne
if ($sf == 2) {
$requete = "select ID, Date_Format(DATE_ENR,'%d.%m.%Y') AS DATE_ENR,
FAMILLE from famille order by date_enr";
} elseif ($sf == 3) {
$requete = "select ID, Date_Format(DATE_ENR,'%d.%m.%Y') AS DATE_ENR,
FAMILLE from famille order by famille";
} else {
// On lance la requête SQL standard
$requete = "select ID, Date_Format(DATE_ENR,'%d.%m.%Y') AS DATE_ENR,
FAMILLE from famille";
}

$resulta = mysql_query($requete) or die (mysql_error());

// Définition de la page pour l'affichage
echo '

Re: Simple Query viewer

That is superb. Its just what I'm looking for.

Are you the author? I have sent the author an email asking about
Copyrights, as I'd like to use the code in a commercial environment
(not selling the script, just to access one of our databases).

I was also thinking that with some adapting, the code could be
converted into a spreadsheet, which creates code automatically
dependent on what fields you want. It would make MySQL alot easier to
use, and quite a handy little tool.

Re: Simple Query viewer

> That is superb. Its just what I'm looking for.
>
Thanks

> Are you the author?
>
Yes

> I have sent the author an email asking about
> Copyrights, as I'd like to use the code in a commercial environment
> (not selling the script, just to access one of our databases).
>
You can have the source, but I'm a beginner in programming, I did this
program only for myself and to learn PHP / HTML.

Re: Simple Query viewer

"pjSoni" wrote in message
news:1139303648.965260.196100@o13g2000cwo.googlegroups.com.. .
> Hi,
>
> There are 2 ways 2 do this.
>
> First of all make listing scrren which display all records in page than
> do 1 of the following
>
> 1. If you need all the records editable at same time.
> Make edit button or link when you click on that it should display all
> there records with text boxes and bottom of the page save button
> displayed when you click all the records will be updated.
>

I implemented mine so each row has its own form with its own delete/change
button. There was also an Add form at the top. I did this because with so
many users, you can't guarantee that all those records you displayed will
stay the same or still be there - can you? are you going to do a mass
insert/update? I wouldn't. And at least this way your fields will be a
little more up-to-date on the next page refresh.



> 2. If you need only 1 records editable.
> Make edit link in each row when you click on single records edit link
> it should reload and only clicked recod should hold textboxes in only
> single row not for all records.
> When click on link after updating than it should updated in db.
>
> As per my understanding about you requirement above are good solutions.
>
> Regards,
> Jatin
>