Code này các bạn xài tạm nha rất căn bản + rất tốt đó đừng coi thường nó cơ bản nha
Code đã được chôm chỉa tại 1 trang wed nước ngoài trong những ngày cơ cực mình tìm hiểu về PHP để làm Forum cho lớp tiếc là do lâu ko đóng tiền forum này đã sập tiệm
đầu tiên là file j-s+html để gọi ajax:
<html><body><script language="javascript" type="text/javascript"><!--//Browser Support Codefunction ajaxFunction(){var ajaxRequest; // The variable that makes Ajax possible!try{// Opera 8.0+, Firefox, SafariajaxRequest = new XMLHttpRequest();} catch (e){// Internet Explorer Browserstry{ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");} catch (e) {try{ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");} catch (e){// Something went wrongalert("Your browser broke!");return false;}}}// Create a function that will receive data sent from the serverajaxRequest.onreadystatechange = function(){if(ajaxRequest.readyState == 4){document.myForm.time.value = ajaxRequest.responseText;}}var age = document.getElementById('age').value;var wpm = document.getElementById('wpm').value;var sex = document.getElementById('sex').value;var queryString = "?age=" + age + "&wpm=" + wpm + "&sex=" + sex;ajaxRequest.open("GET", "ajax-example.php" + queryString, true);ajaxRequest.send(null);}//--></script><form name='myForm'>Max Age: <input type='text' id='age' /> <br />Max WPM: <input type='text' id='wpm' /><br />Sex: <select id='sex'><option>m</option><option>f</option></select><input type='button' onclick='ajaxFunction()' value='Query MySQL' /></form></body></html>còn đây là file Ajax code bằng PHP<?php$dbhost = "localhost";$dbuser = "dbusername";$dbpass = "dbpassword";$dbname = "dbname";//Connect to MySQL Servermysql_connect($dbhost, $dbuser, $dbpass);//Select Databasemysql_select_db($dbname) or die(mysql_error());// Retrieve data from Query String$age = $_GET['age'];$sex = $_GET['sex'];$wpm = $_GET['wpm'];// Escape User Input to help prevent SQL Injection$age = mysql_real_escape_string($age);$sex = mysql_real_escape_string($sex);$wpm = mysql_real_escape_string($wpm);//build query$query = "SELECT * FROM ajax_example WHERE ae_sex = '$sex'";if(is_numeric($age))$query .= " AND ae_age <= $age";if(is_numeric($wpm))$query .= " AND ae_wpm <= $wpm";//Execute query$qry_result = mysql_query($query) or die(mysql_error());//Build Result String$display_string = "<table>";$display_string .= "<tr>";$display_string .= "<th>Name</th>";$display_string .= "<th>Age</th>";$display_string .= "<th>Sex</th>";$display_string .= "<th>WPM</th>";$display_string .= "</tr>";// Insert a new row in the table for each person returnedwhile($row = mysql_fetch_array($qry_result)){$display_string .= "<tr>";$display_string .= "<td>$row[ae_name]</td>";$display_string .= "<td>$row[ae_age]</td>";$display_string .= "<td>$row[ae_sex]</td>";$display_string .= "<td>$row[ae_wpm]</td>";$display_string .= "</tr>";}echo "Query: " . $query . "<br />";$display_string .= "</table>";echo $display_string;?>Nguồn: leech
Còn đây là một số hàm của Mysql_ trong PHP .
Đừng nản lòng khi nhìn những hàm này. Bạn sẽ chẳng bao giờ dùng hết chúng !
| Function | Description | PHP |
|---|---|---|
| mysql_affected_rows() | Returns the number of affected rows in the previous MySQL operation | 3 |
| mysql_change_user() | Deprecated. Changes the user of the current MySQL connection | 3 |
| mysql_client_encoding() | Returns the name of the character set for the current connection | 4 |
| mysql_close() | Closes a non-persistent MySQL connection | 3 |
| mysql_connect() | Opens a non-persistent MySQL connection | 3 |
| mysql_create_db() | Deprecated. Creates a new MySQL database. Use mysql_query() instead | 3 |
| mysql_data_seek() | Moves the record pointer | 3 |
| mysql_db_name() | Returns a database name from a call to mysql_list_dbs() | 3 |
| mysql_db_query() | Deprecated. Sends a MySQL query. Use mysql_select_db() and mysql_query() instead | 3 |
| mysql_drop_db() | Deprecated. Deletes a MySQL database. Use mysql_query() instead | 3 |
| mysql_errno() | Returns the error number of the last MySQL operation | 3 |
| mysql_error() | Returns the error description of the last MySQL operation | 3 |
| mysql_escape_string() | Deprecated. Escapes a string for use in a mysql_query. Use mysql_real_escape_string() instead | 4 |
| mysql_fetch_array() | Returns a row from a recordset as an associative array and/or a numeric array | 3 |
| mysql_fetch_assoc() | Returns a row from a recordset as an associative array | 4 |
| mysql_fetch_field() | Returns column info from a recordset as an object | 3 |
| mysql_fetch_lengths() | Returns the length of the contents of each field in a result row | 3 |
| mysql_fetch_object() | Returns a row from a recordset as an object | 3 |
| mysql_fetch_row() | Returns a row from a recordset as a numeric array | 3 |
| mysql_field_flags() | Returns the flags associated with a field in a recordset | 3 |
| mysql_field_len() | Returns the maximum length of a field in a recordset | 3 |
| mysql_field_name() | Returns the name of a field in a recordset | 3 |
| mysql_field_seek() | Moves the result pointer to a specified field | 3 |
| mysql_field_table() | Returns the name of the table the specified field is in | 3 |
| mysql_field_type() | Returns the type of a field in a recordset | 3 |
| mysql_free_result() | Free result memory | 3 |
| mysql_get_client_info() | Returns MySQL client info | 4 |
| mysql_get_host_info() | Returns MySQL host info | 4 |
| mysql_get_proto_info() | Returns MySQL protocol info | 4 |
| mysql_get_server_info() | Returns MySQL server info | 4 |
| mysql_info() | Returns information about the last query | 4 |
| mysql_insert_id() | Returns the AUTO_INCREMENT ID generated from the previous INSERT operation | 3 |
| mysql_list_dbs() | Lists available databases on a MySQL server | 3 |
| mysql_list_fields() | Deprecated. Lists MySQL table fields. Use mysql_query() instead | 3 |
| mysql_list_processes() | Lists MySQL processes | 4 |
| mysql_list_tables() | Deprecated. Lists tables in a MySQL database. Use mysql_query() instead | 3 |
| mysql_num_fields() | Returns the number of fields in a recordset | 3 |
| mysql_num_rows() | Returns the number of rows in a recordset | 3 |
| mysql_pconnect() | Opens a persistent MySQL connection | 3 |
| mysql_ping() | Pings a server connection or reconnects if there is no connection | 4 |
| mysql_query() | Executes a query on a MySQL database | 3 |
| mysql_real_escape_string() | Escapes a string for use in SQL statements | 4 |
| mysql_result() | Returns the value of a field in a recordset | 3 |
| mysql_select_db() | Sets the active MySQL database | 3 |
| mysql_stat() | Returns the current system status of the MySQL server | 4 |
| mysql_tablename() | Deprecated. Returns the table name of field. Use mysql_query() instead | 3 |
| mysql_thread_id() | Returns the current thread ID | 4 |
| mysql_unbuffered_query() | Executes a query on a MySQL database (without fetching / buffering the result) | 4 |
