PHP的数据库操作

PHP的数据库操作

第十章

<?php  //   login.php 
 $db_hostname  = 'localhost' ;
  $db_database  = 'publications' ;
  $db_username  = 'username' ;
  $db_password  = 'password' ;
 ?>

<? php
  require_once  'login.php' ;
  $db_server  =  mysql_connect ( $db_hostname ,  $db_username ,  $db_password  );
  if  (! $db_server )  die ("Unable to connect to MySQL: " .  mysql_error  ());
 ?>


<? php
  mysql_select_db ( $db_database ) or  die ("Unable to select database: " .  mysql_error  ());
 ?>

<? php
  $query  = "SELECT * FROM classics" ;
  $result  =  mysql_query ( $query  );
  if  (! $result )  die  ("Database access failed: " .  mysql_error  ());
 ?>

<? php
  mysql_close ( $db_server  );
 ?>

<? php
  require_once  'login.php' ;
  $db_server  =  mysql_connect ( $db_hostname ,  $db_username ,  $db_password  );
  if  (! $db_server )  die ("Unable to connect to MySQL: " .  mysql_error  ());
  mysql_select_db ( $db_database  )
    or   die ("Unable to select database: " .  mysql_error  ());

  $query  = "DROP TABLE cats" ;
  $result  =  mysql_query ( $query  );
  if  (! $result )  die  ("Database access failed: " .  mysql_error  ());

  $query  = "INSERT INTO cats VALUES(NULL, 'Lion', 'Leo', 4)" ;
  $result  =  mysql_query ( $query  );
  if  (! $result )  die  ("Database access failed: " .  mysql_error  ());
 ?>


 //   ×Ó²éѯ 
 $query  = "SELECT * FROM customers" ;
  $result  =  mysql_query ( $query  );
  if  (! $result )  die  ("Database access failed: " .  mysql_error  ());
  $rows  =  mysql_num_rows ( $result  );

  for  ( $j  = 0 ;  $j  <  $rows  ; ++ $j  )
{
      $row  =  mysql_fetch_row ( $result  );
      echo  " $row [0] purchased ISBN  $row [1]:<br />" ;

      $subquery  = "SELECT * FROM classics WHERE isbn=' $row [1]'" ;

      $subresult  =  mysql_query ( $subquery  );
      if  (! $subresult )  die  ("Database access failed: " .  mysql_error  ());
      $subrow  =  mysql_fetch_row ( $subresult  );
      echo  "  ' $subrow [1]' by  $subrow [0]<br />" ;
}
 ?>

<? php
  $user   = mysql_fix_string( $_POST ['user' ]);
  $pass   = mysql_fix_string( $_POST ['pass' ]);
  $query  = "SELECT * FROM users WHERE user=' $user ' AND pass=' $pass '" ;

  function  mysql_fix_string( $string  )
{
      if  ( get_magic_quotes_gpc ())  $string  =  stripslashes ( $string  );
      return   mysql_real_escape_string ( $string  );
}
 ?>

<? php
  require  'login.php' ;

  $db_server  =  mysql_connect ( $db_hostname ,  $db_username ,  $db_password  );
  if  (! $db_server )  die ("Unable to connect to MySQL: " .  mysql_error  ());
  mysql_select_db ( $db_database  )
    or   die ("Unable to select database: " .  mysql_error  ());

  $query  = ' PREPARE statement FROM "INSERT INTO classics
    VALUES(?,?,?,?,?)" ' ;
  mysql_query ( $query  );

  $query  = 'SET @author = "Emily Brontë",' .
         '@title = "Wuthering Heights",' .
         '@category = "Classic Fiction",' .
         '@year = "1847",' .
         '@isbn = "9780553212587"' ;
  mysql_query ( $query  );

  $query  = 'EXECUTE statement USING @author,@title,@category,@year,@isbn' ;
  mysql_query ( $query  );

  $query  = 'DEALLOCATE PREPARE statement' ;
  mysql_query ( $query  );
 ?>

第十章

查看更多关于PHP的数据库操作的详细内容...

声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://www.haodehen.cn/did48451