Editing data from the data base

@stephan_gerlachSep 13.2006 — #you need to connect to the database server

[code=php]
 mysql_connect('localhost','username','password');
 [/code]

Select the desired database

[code=php]
 mysql_select_db('db_name');
 [/code]

then run the query like

[code=php]
 $sql = 'SELECT * FROM user WHERE id=2 LIMIT 1';
 $query = mysql_query($sql);
 if (mysql_num_rows($query)==1)
 {
 $result=mysql_fetch_assoc($query);
 }
 [/code]

create a form

[code=html]
 <form action="update.php" method="post">
 <input type="hidden" name="id" value="<?php echo $result['id'];?>" />
 Username: <input type="text" name="username" value="<?php echo $result['username'];?>" /><br />
 Email: <input type="text" name="email" value="<?php echo $result['email'];?>" /><br />
 <input type="submit" value="Update" name="update"/>
 </form>
 [/code]

and then update the entry

[code=php]
 if ( isset ($_POST['update']) )
 {
 
 $sql = 'UPDATE user SET username="'.$_POST['username'].'" AND email="'.$_POST['email'].'" WHERE id="'.$_POST['id'].'" LIMIT 1';
 
 mysql_query($sql);
 }
 
 [/code]

THESE ARE THE BASICS AND NOT SECURE. CODE IS NOT TESTED. IF YOU USE IT LIKE THAT WITHOUT EDITING ITS YOUR OWN FAULT IF YOU GET HACKED.

Editing data from the data base

2 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Editing data from the data base

2 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

2 Comments(s) _↴

Also in #PHP _↴