Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2017
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. <?php
  2. $host = 'localhost:3306'; //database host
  3. $user = 'root'; // DataBase User
  4. $pass = ''; //database password
  5. $dbname = 'mydb2'; //database name
  6.  
  7. //Connection to Databse
  8. $conn = mysqli_connect($host, $user, $pass,$dbname);
  9.  
  10. // Check connection
  11. if(!$conn){
  12. die('Could not connect: '.mysqli_connect_error());
  13. }
  14. echo 'Connected successfully<br/>';
  15.  
  16. //Update the table
  17. $id=2;
  18. $name="Rahul";
  19. $emp_salary=80000;
  20.  
  21. //Table Query
  22. $sql = "update emp5 set name=\"$name\", emp_salary=$emp_salary where id=$id";
  23.  
  24. //checking for update
  25. if(mysqli_query($conn, $sql)){
  26. echo "Record updated successfully";
  27. }else{
  28. echo "Could not update record: ". mysqli_error($conn);
  29. }
  30.  
  31.  
  32. // Close connection
  33. mysqli_close($conn);
  34. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement