Programming Forums > Web Development and Design > PHP

vidar · Mar 15th, 2005, 10:48 AM

New to PHP and just learning. Old hack at programming, but this is new.

I'm trying to return an array of data from an SQL database. Here, I'll just post the code snippets, might be easier to read than for me to explain it...

(Toggle Plain Text)

<?php
$conn = mysql_connect("localhost", "admin", "******");
mysql_select_db("users",$conn);
$sqlcheck = "SELECT * FROM user_db";
$result = mysql_query($sqlcheck, $conn) or die(mysql_error());

// create edituser function
// arguments are $userid
function edituser($userid,$newarray) {
    showuserform();
    echo '<BR><BR>';
    echo '<b>'.$newarray[address].'</b><br><br>'  ;
    echo '<FORM method="POST">';
    echo 'Name : <input type="text" name="name" value="'.$newarray[name].'">';
    echo '<BR>';
    echo 'Address : <input type="text" name="address">';
    echo '<BR>';
    echo 'City : <input type="text" name="city">';
    echo '<BR>';
    echo 'Province/State : <input type="text" name="province" size=2>';
    echo '<BR>';
    echo 'PostalCode/Zip : <input type="text" name="postalcode">';
    echo '<BR>';
    echo 'Country : <input type="text" name="country">';
    echo '<BR>';
    echo 'Password : <input type="password" name="password">';
    echo '<BR>';

}
// create the form that shows the users to edit
function showuserform() {
          echo '<FORM method="POST">';
          echo '<select name="userid">';
          while ($newarray = mysql_fetch_array($GLOBALS["result"])) {
              echo '<option value="'.$newarray[name].'">'.$newarray[name].'</option>';
          }
          echo '</select><BR>';
          echo '<input type=submit value="Edit User" name="submit">';
          return $newarray;
}

if ($_POST['submit']) {
    edituser($userid,$newarray);
    return;
    }
else {
    showuserform();
    }
?>

Does that make sense in my showuserform() function to return the $newarray so that it can be used in the edituser function? Should I set that as a global?

vidar · Mar 15th, 2005, 11:05 AM

As a note, the two lines in the code :

(Toggle Plain Text)

echo '<b>'.$newarray[address].'</b><br><br>'  ;
    echo '<FORM method="POST">';
    echo 'Name : <input type="text" name="name" value="'.$newarray[name].'">';

are just for testing purposes to see if it worked. :-)

Berto · Mar 15th, 2005, 11:36 AM

your show user form is returning a value but as with programming you need a variable in the main function to store that variable as....

so declare an array in edit user function then

(Toggle Plain Text)

array = showuserform();

well thats what i think anyways i could be wrong.

vidar · Mar 15th, 2005, 11:45 AM

My functions are actually written reversed. It does the showuserform function first, then when I select a user from it, I want it to execute the edituser function. so declaring an array variable in the edituser function, won't give me anything the first time through...

Perhaps declare it globally?

Mar 15th, 2005, 10:48 AM	#1
vidar Newbie Join Date: Mar 2005 Posts: 3 Rep Power: 0	Returning an array value New to PHP and just learning. Old hack at programming, but this is new. I'm trying to return an array of data from an SQL database. Here, I'll just post the code snippets, might be easier to read than for me to explain it... (Toggle Plain Text) <?php $conn = mysql_connect("localhost", "admin", "*****"); mysql_select_db("users",$conn); $sqlcheck = "SELECT FROM user_db"; $result = mysql_query($sqlcheck, $conn) or die(mysql_error()); // create edituser function // arguments are $userid function edituser($userid,$newarray) { showuserform(); echo '<BR><BR>'; echo '<b>'.$newarray[address].'</b><br><br>' ; echo '<FORM method="POST">'; echo 'Name : <input type="text" name="name" value="'.$newarray[name].'">'; echo '<BR>'; echo 'Address : <input type="text" name="address">'; echo '<BR>'; echo 'City : <input type="text" name="city">'; echo '<BR>'; echo 'Province/State : <input type="text" name="province" size=2>'; echo '<BR>'; echo 'PostalCode/Zip : <input type="text" name="postalcode">'; echo '<BR>'; echo 'Country : <input type="text" name="country">'; echo '<BR>'; echo 'Password : <input type="password" name="password">'; echo '<BR>'; } // create the form that shows the users to edit function showuserform() { echo '<FORM method="POST">'; echo '<select name="userid">'; while ($newarray = mysql_fetch_array($GLOBALS["result"])) { echo '<option value="'.$newarray[name].'">'.$newarray[name].'</option>'; } echo '</select><BR>'; echo '<input type=submit value="Edit User" name="submit">'; return $newarray; } if ($_POST['submit']) { edituser($userid,$newarray); return; } else { showuserform(); } ?> <?php $conn = mysql_connect("localhost", "admin", "*****"); mysql_select_db("users",$conn); $sqlcheck = "SELECT FROM user_db"; $result = mysql_query($sqlcheck, $conn) or die(mysql_error()); // create edituser function // arguments are $userid function edituser($userid,$newarray) { showuserform(); echo '<BR><BR>'; echo '<b>'.$newarray[address].'</b><br><br>' ; echo '<FORM method="POST">'; echo 'Name : <input type="text" name="name" value="'.$newarray[name].'">'; echo '<BR>'; echo 'Address : <input type="text" name="address">'; echo '<BR>'; echo 'City : <input type="text" name="city">'; echo '<BR>'; echo 'Province/State : <input type="text" name="province" size=2>'; echo '<BR>'; echo 'PostalCode/Zip : <input type="text" name="postalcode">'; echo '<BR>'; echo 'Country : <input type="text" name="country">'; echo '<BR>'; echo 'Password : <input type="password" name="password">'; echo '<BR>'; } // create the form that shows the users to edit function showuserform() { echo '<FORM method="POST">'; echo '<select name="userid">'; while ($newarray = mysql_fetch_array($GLOBALS["result"])) { echo '<option value="'.$newarray[name].'">'.$newarray[name].'</option>'; } echo '</select><BR>'; echo '<input type=submit value="Edit User" name="submit">'; return $newarray; } if ($_POST['submit']) { edituser($userid,$newarray); return; } else { showuserform(); } ?> Does that make sense in my showuserform() function to return the $newarray so that it can be used in the edituser function? Should I set that as a global?

Mar 15th, 2005, 11:05 AM	#2
vidar Newbie Join Date: Mar 2005 Posts: 3 Rep Power: 0	As a note, the two lines in the code : (Toggle Plain Text) echo '<b>'.$newarray[address].'</b><br><br>' ; echo '<FORM method="POST">'; echo 'Name : <input type="text" name="name" value="'.$newarray[name].'">'; echo '<b>'.$newarray[address].'</b><br><br>' ; echo '<FORM method="POST">'; echo 'Name : <input type="text" name="name" value="'.$newarray[name].'">'; are just for testing purposes to see if it worked. :-)

Mar 15th, 2005, 11:36 AM	#3
Berto Programming Guru Join Date: Aug 2004 Posts: 1,022 Rep Power: 6	your show user form is returning a value but as with programming you need a variable in the main function to store that variable as.... so declare an array in edit user function then (Toggle Plain Text) array = showuserform(); array = showuserform(); well thats what i think anyways i could be wrong.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2005, 11:45 AM	#4
vidar Newbie Join Date: Mar 2005 Posts: 3 Rep Power: 0	My functions are actually written reversed. It does the showuserform function first, then when I select a user from it, I want it to execute the edituser function. so declaring an array variable in the edituser function, won't give me anything the first time through... Perhaps declare it globally?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > PHP

Returning an array value