displaying an array and updating its values

lerro

I retrieved an array from the database. I can display that array on screen, but I need to update the information in that array and then save it back to the database.

How do i get an array to be displayed within a form as field values that can be edited/updated by the user and then read back for update ?

halojoy

Post the code you have.
Where you select that row and display it.
Will give us something to start with.

halojoy

This is a form I have tested and it works.
You should be able to rewrite it for your need.
It is not too difficult to see how it works.

Will update one row with posted data.

<?php

include('includes/dbclass1.php');
$db = new LiteDB();

// if post submit update row
if(isset($_POST['submit']) && $_POST['submit'] == 'Update'){
	$sql = "UPDATE users 
	SET name = '".$_POST['name']."', email = '".$_POST['email'].
	"' WHERE id = 2";
	$db->Query($sql);
}

// get the current values
$sql = "SELECT name, email FROM users WHERE id = 2";
$row = $db->GetRow($sql);
// display values in form
echo '<form method="post">';
echo "TABLE users WHERE id = 2";
echo '<table border="1">';
echo '<tr>';
echo '<th>name</th>';
echo '<th>email</th>';
echo '</tr>';

echo '<tr>';
echo '<td><input type="text" name="name" value="'.$row->name.'"></td>';
echo '<td><input type="text" name="email" value="'.$row->email.'"></td>';
echo '</tr>';
echo '</table>';
echo '<input type="submit" name="submit" value="Update">';
echo '</form>';

?>

igorek

PHP_SELF?

lerro

Thanks for the code example by the way.

I get this error when trying to use the code example you provided;

Fatal error: Call to undefined method LiteDB::GetRow()

That's because i don't have the class that you used to connect to the database as an include and therefore do not have the "GetRow()" function.

halojoy

lerro;10939659 wrote:
Thanks for the code example by the way.

I get this error when trying to use the code example you provided;

That's because i don't have the class that you used to connect to the database as an include and therefore do not have the "GetRow()" function.

Yes, Class LiteDB is my own written db wrapper class. (Uses SQLite2 database)
You have to replace those database operations with mysql_functions in my script
or whatever database you use.

AS I said above

Post the code you have.
Where you select that row and display it.
Will give us something to start with.

lerro

Thanks, i was able to use

mysql_query

in places to get it working

<?php
include_once('db_connection.class.php');

$db = new DbConnection();

if(isset($POST['submit']) && $POST['submit'] == 'Update'){
$sql = "UPDATE table
SET firstname = '".$POST['firstname']."', surname = '".$POST['surname'].
"' WHERE id = 025095";
mysql_query($sql);
}

$sql = "SELECT firstname, surname FROM table WHERE id = 025095";

$row = mysql_query($sql)

echo '<form method="post">';
echo "TABLE users WHERE id = 025095";
echo '<table border="1">';
echo '<tr>';
echo '<th>Firstname</th>';
echo '<th>Surname</th>';
echo '</tr>';

echo '<tr>';

echo '<td><input type="text" name="firstname" value="'.$row['firstname'] .'"></td>';
echo '<td><input type="text" name="surname" value="'.$row['surname'] .'"></td>';

echo '</tr>';
echo '</table>';
echo '<input type="submit" name="submit" value="Update">';
echo '</form>';

?>

halojoy

Did you really get it working 🙂
Very well done.

I suppose you actually need this line to.
[man]mysql_fetch_array[/man]

$sql = "SELECT firstname, surname FROM table WHERE id = 025095";

$result = mysql_query($sql)
$row = mysql_fetch_array($result);

echo '<form method="post">';
echo "TABLE users WHERE id = 025095";

lerro

halojoy;10939747 wrote:
Did you really get it working 🙂
Very well done.

I suppose you actually need this line to.
[man]mysql_fetch_array[/man]
$sql = "SELECT firstname, surname FROM table WHERE id = 025095";

$result = mysql_query($sql)
$row = mysql_fetch_array($result);

echo '<form method="post">';
echo "TABLE users WHERE id = 025095"; 

mysql_fetch_array($result);

what enables looping through an array?

From what i would understand;

$sql - is the declaration of the query to be performed

$mysql_query - is the php function that querys Mysql database

$mysql_fetch_array - is the function that can be used to loop through the results produced by mysql_query

Is that correct?

halojoy

$result = mysql_query($sql)
$row = mysql_fetch_array($result);

mysql_query will only return a result handle
result is not useful, unless you fetch

$row = mysql_fetch_array($result);
will fetch one row, which is an array of values
$row['name'], $row['email'] or whatever was selected

next time we run
$row = mysql_fetch_array($result);
it will take next row from $result
... and so on

in this case there is only 1 row in $result, so we need NOT loop with while()

if we loop
while( $row = mysqlfetcharray($result) ){
do something with this row
}
it will fetch all rows, one by one, until end of $result

lerro

If i wanted to fetch then update multiple fields and not just one id from the form, how would i do this using mysql_fetch array?

if(isset($POST['submit']) && $POST['submit'] == 'Update'){
$sql = "UPDATE table
SET firstname = '".$POST['firstname']."', surname = '".$POST['surname'].
"' WHERE id = 025095";
mysql_query($sql);
}

Instead of the id of one item being used, the ability to have a variable that holds the id as data is fetched from the database, and also as it's written to the database from the form update

halojoy

To update several rows, IDs in same form will make it complicated.

But you could put a new input field in your post form:
input name="id"

Then you use $id = $_POST['id']
and put this $id into your update/select query

I have not figured out how to do this exactly.
It is not that easy.