Return an array with register_globals = off

bdl · 03-09-2003, 12:02 PM

I've got a script that works perfectly with register_globals turned on, and breaks with them off. It's pretty obvious that the array just isn't available with globals turned off, and I've run out of ideas on how to make this work. A mock-up of my script is shown below. What it does is grab the values from an SQL query, put those values into an array that are passed with POST to the script. Remember, this works as is.

PHP Code:


			
<?php

// include the link

require_once("../link.php");

// establish vars

$PHP_SELF = $_SERVER['PHP_SELF'];

$row_id = $_POST['row_id'];

$db = mysql_select_db("test");

$db_table = "test_table";



if ($_POST['submit'] == "Delete") {

foreach ($del_row as $row_id) {

            $result = mysql_query("DELETE FROM $db_table WHERE id = $row_id");

            $i++;

        }

        echo "<div align=center>\n";

        echo $i . " deleted.\n<br><br>\n";

        echo "[<a href=\"$PHP_SELF\">Delete more records.</a>]\n<br>\n</div>";

} else {

echo"<html>\n<head>\n<title>Delete Database Records</title>\n</head>\n<body>\n";

        echo "<div align=center>\n";

        echo "<strong>Delete Database Records</strong><br><br>\n";

        

        $query = "SELECT * FROM $db_table ORDER BY id";

        $result = mysql_query($query);

        $num_rows = mysql_num_rows($result);

        if ($num_rows == "0") {

            die("<font color=red>No records found.</font>\n</div>\n</body>\n</html>");

        } else {

            echo $num_rows . " record(s) found.<br>\n";

            echo "<form method=post action=\"$PHP_SELF\">";

            echo "<table border=1 cellpadding=1 cellspacing=1 width=\"50%\">";

            echo "<tr>\n";

            echo "<td align=center>Name</td>\n";

            echo "<td align=center>Serial #</td>\n";

            echo "<td align=center>Delete?\n";

            echo "</tr>\n";

            

            while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

                // define the row id

                $row_id = $row['id'];



                echo "<tr>\n";

                echo "<td align=center valign=center>" . $row['name'] . "</td>\n";

                echo "<td align=center valign=center>" . $row['serial_number'] . "</td>\n";

                echo "<td align=center valign=center>\n";

                echo "<input type=checkbox name=\"del_row[]\" value=\"$row_id\"></input>\n";

                echo "</td></tr>\n";

                }

        }



        echo "<tr>\n";

        echo "<td align=left valign=center>\n</tr>\n";

        echo "<tr>\n<td>\n";

        echo "<input type=submit name=submit value=\"Delete\"></input>\n";

        echo "<input type=reset value=\"Reset\"></input>\n";

        echo "</td>\n</tr>\n</table>\n</form>\n<br><br>\n";

}

?>

Now, how would I go about returning the value of del_row[] without globals on? Ideas?

abc123 · 03-09-2003, 01:57 PM

return it where? you don't have a function? you can't "return" anything without a function...

also, naming a html object with square brackets is considered bad form...

Quote:

echo "<input type=checkbox name=\"del_row[]\" value=\"$row_id\"></input>\n";

and naming a bunch of html objects with the same name is also not a great idea.. hmm.

what are you trying to achieve?

bdl · 03-09-2003, 02:19 PM

Quote:

Originally posted by abc123
return it where? you don't have a function? you can't "return" anything without a function...

You're right, I simply mean that it returns the value to the script from POST. When you hit 'submit', the script calls on itself to validate the form input and then take those values and do something with them. In this case, it loops the array through MySQL's DELETE command to delete each row you've selected, with the value of $row_id.

Quote:

also, naming a html object with square brackets is considered bad form...

Actually, I gleaned that bit from a book on PHP/MySQL that I've got, if there is another way of doing it I'd gladly learn. I'm not a professional PHP programmer.

Quote:

and naming a bunch of html objects with the same name is also not a great idea.. hmm.

?

Quote:

what are you trying to achieve?

Exactly what the script does now; gives you a dynamic table with a selection of rows from MySQL 'SELECT' and allows you to delete those rows from the database. I also have a similar script that does the same thing but gives the user the ability to actually update the database based on new data, using basically the same method.

This is all part of a website I'm putting together for coworkers to access / modify a database of products.

Admin · 03-09-2003, 06:35 PM

Quote:

Originally posted by abc123
and naming a bunch of html objects with the same name is also not a great idea.. hmm.

since they are check boxes wouldnt it return an array for every checkbox checked?

then you can use that to delete the rows from the table.

i would do multiple queries i would run something like this.

delete from TABLE where id = '1' or id = '2' or id = '8'

i like to keep queries to a minimum.

bdl · 03-10-2003, 05:12 AM

Quote:

Originally posted by Admin
since they are check boxes wouldnt it return an array for every checkbox checked?

then you can use that to delete the rows from the table.

i would do multiple queries i would run something like this.

delete from TABLE where id = '1' or id = '2' or id = '8'

i like to keep queries to a minimum.

Right, what it does is returns an array like so:

$del_row['$row_id']

and the the foreach loop steps through and deletes each entry in the array. The problem I have is, this works perfectly when register_globals is on, and it breaks if turned off. I was reading a similar problem on another site, someone was suggesting using $_SESSION to store the array and use those values, I'm going to look into that, otherwise I'm lost.

bdl · 03-10-2003, 07:10 AM

I guess the real title of the post should have been 'How to get an array with $_POST...', something like this:

$var = array[$key][$value];

PHP Code:


			
$del_row = array($_POST['del_row'][$_POST['key']][$_POST['row_id']]);

??

abc123 · 03-10-2003, 01:28 PM

given:

Code:

<input type="checkbox" name="test" /> a
<input type="checkbox" name="test" /> b
<input type="checkbox" name="test" /> c
<input type="checkbox" name="test" /> d

you should be able to access them as:

Code:

$POST["test"][0]  // a
$POST["test"][1]  // b
$POST["test"][2]  // c

if i remember correctly or else

$x = $POST["test"]; should return you the values in the form of "a, b, c, d"

bdl · 03-10-2003, 05:37 PM

Ok, I figured it out. What I needed to do was simply use the value of del_row[] instead of getting $row_id like so:

PHP Code:


			
$del_row = $_POST['del_row'];

That contains the value of the array $del_row.

Thanks to everyone that looked it over for me!