Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 10th, 2012  |  syntax: None  |  size: 0.72 KB  |  hits: 3  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Why can't i write my MySQL database using a 'required' function?
  2. function dbconn()
  3. {
  4. $servername="127.0.0.1";
  5. $username="root";
  6. $conn=mysql_connect($servername,$username)or die(mysql_error());
  7. mysql_select_db("profit",$conn) or die(mysql_error());
  8. }
  9.        
  10. <?php
  11. require ("lib.php");
  12. set_time_limit(60);
  13. session_start();
  14. dbconn();
  15. $sql="update `city` set end_dt=now() where city_id='$_POST[killcity]'";
  16. $result=mysql_query($sql,$conn) or die(mysql_error());
  17. header("Location: manipulate.php");
  18. ?>
  19.        
  20. function dbconn() {
  21.     $servername="127.0.0.1";
  22.     $username="root";
  23.     $conn=mysql_connect($servername,$username)or die(mysql_error());
  24.     mysql_select_db("profit",$conn) or die(mysql_error());
  25.     return $conn;
  26. }
  27.  
  28. $conn = dbconn();