Edit Mysql Data With Forms

**kfordham281** · December 12, 2006

I was wondering if someone could point me in the right direction to a tutorial or something along those lines. Basically I want to be able to pull data from a mysql db into a form and edit the information in that form and then send the updated data back to the db. Got any links?

**TCH-Bruce** · December 12, 2006

Here is one tutorial and you can find many others with a Google search.

**kfordham281** · December 13, 2006

I did a few google searches and didn't find anything that was close to what I was looking for. Thanks for the link but unfortunately it's not exactly what I'm looking for. Thank you for looking though.

**Steve Scrimpshire** · December 14, 2006

Maybe this'll get you started:

><?php
$username = "username";
$password = "password";
$database = "database";
$table = "table";

// Connecting, selecting database
$link = mysql_connect("localhost", "$username", "$password")
  or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db("$database") or die('Could not select database');

// Performing SQL query
$query = "SELECT * FROM $table";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
// echo "<table>\n";
echo "<html><body>";
echo "<p>";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
  foreach($line as $key => $value) {
   echo "\$$key == $value";
   echo "<br>";
   }
  echo "<p>";
  
  }

echo "</body></html>";

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
?>

When I have more time, if you still haven't figured the rest out, I might be able to look deeper into it.

Although, you could just use phpmyAdmin in your controlpanel:

http://yoursite.com:2082/3rdparty/phpMyAdmin/index.php

Edited December 14, 2006 by Steve Scrimpshire

Sign In

Edit Mysql Data With Forms

Recommended Posts

kfordham281

TCH-Bruce

kfordham281

Steve Scrimpshire

Join the conversation

Hosting