Update Admin Page

PaulaRun

I'm doing an admin page and I'd like the user to be able to search the database for a product, then display the product fields (in text boxes?) so the user can change them. How can I do that?

Thanks!

cgraz

make a search form

<form method="post" action=". . .>

Product # <input type="text" name="product_number"><br><br>

<input type="submit" value="submit">

Now process that with a query. If you want an exact result, use a query that looks like this

$query = mysql_query("SELECT * FROM your_table WHERE product_num = '" . $_POST["product_number"] . "'") or die(mysql_error());

/* or if you want something similar to what they typed in (maybe not as good of an idea to use with numbers, but works great with text */

$query = mysql_query("SELECT * FROM your_table WHERE product_num LIKE '%" . $_POST['product_number'] . "%'") or die(mysql_error());

Now put the results in an array, then inside your while loop build a form with the values in the text field


while($row = mysql_fetch_assoc($query)) {

echo "<form method=\"post\" action= . . . >\n";

echo "Product Name: <input type=\"text\" name=\"product_name\" value=\"" . $row["product_name"] . "\"><br>\n";

// etc etc

// end form
echo "</form>";

// end while loop
}

then on the page that processes this form, you update your db.

Cgraz

largo

Once you retrieved the search results from your database, you can populate the required form fields with them. ex:

When the form is submitted you can update the fields as required.

hth.

wama_tech

You can do it like this:

first- make the queries and all of the required processing if needed in the <?php ?> part before <head>, make the varriables u use to stor the results as global Varriables

second- put the textfields as follows:

this should initialize your textfield's value to the result you wanted

largo

You know I caught this post pretty much as soon as it came online and typed an answer out fairly quickly... not only did cgraz clock his reply in before I did, his post is far more detailed and helpful... many kudos on your insane typing speed & copy / paste skills 🙂

PaulaRun

Wow, thanks everybody! I'm on my way!

cgraz

that's not copying/pasting skills, that's 130 words per minute at work. 😉

Cgraz