Advanced Search

full php mysql connection script

/ Published in: PHP
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. <?php 
  2. //mysql connect
  3.  
  4. //connect to db and insert
  5. mysql_connect(localhost,$username,$password);
  6. mysql_select_db($database) or die( "Unable to select database");
  7. $query = "INSERT INTO contacts VALUES ('','John','Smith','01234 567890','00112 334455','01234 567891','[email protected]','http://www.gowansnet.com')";
  8. mysql_query($query);
  9. echo "Record added";
  10. mysql_close();
  11.  
  12.  
  13.  
  14.  
  15. //mysql select query
  16. $result = mysql_query("SELECT id,name FROM table");
  17. if(!$result) {
  18.   echo mysql_error();
  19. }
  20. while($row = mysql_fetch_assoc($result)) {
  21.    echo "Row data: " . $row['id'] . " - " . $row['name'];
  22. }
  23.  
  24. //alternative select query
  25. mysql_connect(localhost,$username,$password);
  26. mysql_select_db($database) or die( "Unable to select database");
  27. $query="SELECT * FROM contacts";
  28. $result=mysql_query($query);
  29. echo "Data displayed";
  30. mysql_close();
  31.  
  32.  
  33. //mysql update
  34. mysql_connect(localhost,$username,$password);
  35. mysql_select_db($database) or die( "Unable to select database");
  36. $query = "UPDATE contacts SET 
  37. 							first = '$ud_first', 
  38. 							last = '$ud_last', 
  39. 							phone = '$ud_phone', 
  40. 							mobile = '$ud_mobile', 
  41. 							fax = '$ud_fax', 
  42. 							email = '$ud_email', 
  43. 							web = '$ud_web' 
  44. 							WHERE id = '$ud_id'";
  45. mysql_query($query);
  46. echo "Record Updated";
  47. mysql_close();
  48.  
  49.  
  50.  
  51. //delete contact
  52. mysql_connect(localhost,$username,$password);
  53. mysql_select_db($database) or die( "Unable to select database");
  54. $query = "DELETE FROM contacts WHERE id='$id'";
  55. mysql_query($query);
  56. echo "Record Deleted";
  57. mysql_close();
  58.  
  59.  
  60. ?>

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.