dbcustomer member CREATE TABLE member id int5 NOT
ทดลองสรางฐานขอมล ����� : db_customer ����� : member • CREATE TABLE member ( id int(5) NOT NULL auto_increment, user varchar(30) NOT NULL default '', pass varchar(50) NOT NULL default '', name varchar(50) NOT NULL default '', email varchar(50) NOT NULL default '', address varchar(50) NOT NULL default '', PRIMARY KEY (id) ) TYPE=My. ISAM; 6
My. SQL DATABASE FUNCTION My. SQL ����������� PHP �������������� RDBMS (ralational database management system) ระบบฐานขอมลท PHP สามารถเชอมตอได Oracle My. SQL Sybase Solid m. SQL ODBC Postgre. SQL Adabas D File. Pro Velocis Informix d. Base Unix dbm
คำสง SQL (��� ) คำสงทใชอานขอมล SELECT [ALL | DISTINCT] select_list [INTO new_table_] FROM table_source [WHERE search_condition] [GROUP BY group_by_expression] [HAVING search_condition] [ORDER BY order_expression [ASC | DESC] ]
คำสง SQL ? (��� ) คำสงทใชแกไขขอมล UPDATE { table_name WITH ( <table_hint_limited> […n]) | view_name | rowset_function_limited } SET Column_name = { expression | DEFAULT | NULL } { [FROM {<table_source>} [, …n] [ WHERE <search_condition>] }
คำสง SQL ? (��� ) คำสงทใชเพมขอมล INSERT [INTO] { table_name WITH ( <table_hint_limited> […n]) | view_name | rowset_function_limited } { [(column_list)] { VALUES { ( DEFAULT | NULL | expression } [, …n] ) | derived_table | execute_statement } }
คำสง SQL ? (��� ) คำสงทใชลบขอมล DELETE [FROM] { table_name WITH ( <table_hint_limited> […n] ) | view_name |rowset_function_limited } [FROM {<table_source>} […n] ] [WHERE <search_condition> ]
mysql_db_query • ใชสงคำสงไปยง My. SQL ��������� mysql_query() ������������ int mysql_db_query(string databasename, string query, int link_identifier); รปแบบคำสง - databasename ������� - query ������ SQL - link_identifier
ตวอยาง <? //����������� My. SQL $link = mysql_connect(“localhost”, ”seree”, ”phpseree”); //�������������� $query = “select id, name, surname from phpuser”; //�������������� test_db ��� My. SQL //��������� mysql_select_db() $result = mysql_db_query(“test_db”, $query, $link);
mysql_drop_db • เปนฟงกชนทใชลบ (drop) ������������ My. SQL รปแบบของคำสง int mysql_drop_db(string databasename, int link_identifier); - databasename ������� - link_identifier ������������ My. SQL
mysql_query • เปนฟงกชนทใชสงคำสง (SELECT, INSERT, DELETE)��������� My. SQL ��������� function mysql_db_query() �������� int mysql_query(string query, Int link_identifier);
ตวอยาง <? //���������� My. SQL $link = mysql_connect(“localhost”, “seree”, “phpseree”); //���������� mysql_select_db(“test_db”, $link); //���������� $query = “select * from phpuser”;
<? php $host = "localhost"; $un = "root"; $pwd = ""; $Myconn = mysql_connect($host, $un, $pwd); if($Myconn) { echo "��������� "; $Str. SQL = "Select * From Tb. Member Where User. Name ='". $Txt. UN. "' and Password = '". $Txt. PWD. "'"; $result =mysql_db_query("Car. DB", $Str. SQL, $Myconn); $totalrow = mysql_num_rows($result); if($totalrow !=0) { echo " �������� "; echo "$Txt. UN $Txt. PWD "; } else { echo " �������������� "; } } else { echo "�������������� "; } ? >
<html> <body> <form name="form 1" method="post" action=“register_result. php"> ������ <table width="27%" border="0" cellspacing="0" cellpadding="0" height="27"> <tr> <td>User-Name</td> <input type="text" name="user"> </td> </tr> <td>password</td> <input type="password" name="pass"> </td> </tr> <td>name</td> <input type="text" name="name"> </td> </tr> <td>email</td> <input type="text" name="email"> </td> </tr> <td>address</td> <input type="text" name="address"> </td> </tr> <td> </td> <input type="submit" name="Submit" value="Ok"> </td> </tr> </table> </form> </body> </html> register. php 45
<? $host="localhost"; $username="root"; $pass_word="123456"; $db="db_customer"; $tb="member"; register_result. php mysql_connect( $host, $username, $pass_word) or die ("��������� Mysql ������ "); mysql_select_db($db) or die("���������� "); $md 5 pass=md 5($pass); mysql_query("INSERT INTO $tb (id, user, pass, name, email, address) values('', '$user', '$md 5 pass', '$name ', '$email', '$address')") or die ("������������ "); echo "������� $name "; echo "user ������ $user "; echo "������ $pass "; echo "��������� md 5 ��� ", md 5($pass); mysql_close(); ? > <a href=“login. php">���������� </a> 46
Quiz (page 1) login. php Password : เขารหสแบบ MD 5 47
Quiz (page 2) user. php USER logout. php �������� logout. php - ���� session ������� (session_unregister) - �������� 48
- Slides: 48