(转)PHP and AJAX MySQL Database Example-php教程-PHP中文網

首頁

後端開發

php教程

(转)PHP and AJAX MySQL Database Example

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 23, 2016 pm 02:33 PM

引用地址:http://www.w3schools.com/PHP/php_ajax_database.asp

AJAX can be used for interactive communication with a database.

AJAX Database Example

In the AJAX example below we will demonstrate how a web page can fetch information from a MySQL database using AJAX technology.

Select a Name in the Box Below

Select a User: Peter Griffin Lois Griffin Joseph Swanson Glenn Quagmire

User info will be listed here.

This example consists of four elements:

a MySQL database a simple HTML form a JavaScript a PHP page

The Database

The database we will be using in this example looks like this:

id FirstName LastName Age Hometown Job

1	Peter	Griffin	41	Quahog	Brewery
2	Lois	Griffin	40	Newport	Piano Teacher
3	Joseph	Swanson	39	Quahog	Police Officer
4	Glenn	Quagmire	41	Quahog	Pilot

The HTML Form

The example above contains a simple HTML form and a link to a JavaScript:

<html>            <head>            <script src="selectuser.js"></script>            </head>            <body>

<form>            Select a User:            <select name="users" onchange="showUser(this.value)">            <option value="1">Peter Griffin</option>            <option value="2">Lois Griffin</option>            <option value="3">Glenn Quagmire</option>            <option value="4">Joseph Swanson</option>            </select>            </form>

<p>            <div id="txtHint"><b>User info will be listed here.</b></div>            </p>

</body>            </html>

Example Explained - The HTML Form

As you can see it is just a simple HTML form with a drop down box called "users" with names and the "id" from the database as option values.

The paragraph below the form contains a div called "txtHint". The div is used as a placeholder for info retrieved from the web server.

When the user selects data, a function called "showUser()" is executed. The execution of the function is triggered by the "onchange" event.

In other words: Each time the user changes the value in the drop down box, the function showUser() is called.

The JavaScript

This is the JavaScript code stored in the file "selectuser.js":

var xmlHttp

function showUser(str)            {            xmlHttp=GetXmlHttpObject()            if (xmlHttp==null)            {            alert ("Browser does not support HTTP Request")            return            }            var url="getuser.php"            url=url+"?q="+str            url=url+"&sid="+Math.random()            xmlHttp.onreadystatechange=stateChanged            xmlHttp.open("GET",url,true)            xmlHttp.send(null)            }

function stateChanged()            {            if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")            {            document.getElementById("txtHint").innerHTML=xmlHttp.responseText            }            }

function GetXmlHttpObject()            {            var xmlHttp=null;            try            {            // Firefox, Opera 8.0+, Safari            xmlHttp=new XMLHttpRequest();            }            catch (e)            {            //Internet Explorer            try            {            xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");            }            catch (e)            {            xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");            }            }            return xmlHttp;            }

Example Explained

The stateChanged() and GetXmlHttpObject functions are the same as in the PHP AJAX Suggest chapter, you can go to there for an explanation of those.

The showUser() Function

If an item in the drop down box is selected the function executes the following:

Calls on the GetXmlHttpObject function to create an XMLHTTP object Defines the url (filename) to send to the server Adds a parameter (q) to the url with the content of the dropdown box Adds a random number to prevent the server from using a cached file Call stateChanged when a change is triggered Opens the XMLHTTP object with the given url. Sends an HTTP request to the server

The PHP Page

The server page called by the JavaScript, is a simple PHP file called "getuser.php".

The page is written in PHP and uses a MySQL databse.

The code runs a SQL query against a database and returns the result as an HTML table:

<?php            $q=$_GET["q"];            $con = mysql_connect('localhost', 'peter', 'abc123');            if (!$con)            {            die('Could not connect: ' . mysql_error());            }            mysql_select_db("ajax_demo", $con);            $sql="SELECT * FROM user WHERE id = '".$q."'";            $result = mysql_query($sql);            echo "<table border='1'>            <tr>            <th>Firstname</th>            <th>Lastname</th>            <th>Age</th>            <th>Hometown</th>            <th>Job</th>            </tr>";            while($row = mysql_fetch_array($result))            {            echo "<tr>";            echo "<td>" . $row['FirstName'] . "</td>";            echo "<td>" . $row['LastName'] . "</td>";            echo "<td>" . $row['Age'] . "</td>";            echo "<td>" . $row['Hometown'] . "</td>";            echo "<td>" . $row['Job'] . "</td>";            echo "</tr>";            }            echo "</table>";            mysql_close($con);            ?>

Example Explained

When the query is sent from the JavaScript to the PHP page the following happens:

PHP opens a connection to a MySQL server The "user" with the specified name is found A table is created and the data is inserted and sent to the "txtHint" placeholder

陳述

本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn

超越炒作：評估當今PHP的角色Apr 12, 2025 am 12:17 AM

PHP在現代編程中仍然是一個強大且廣泛使用的工具，尤其在web開發領域。 1)PHP易用且與數據庫集成無縫，是許多開發者的首選。 2)它支持動態內容生成和麵向對象編程，適合快速創建和維護網站。 3)PHP的性能可以通過緩存和優化數據庫查詢來提升，其廣泛的社區和豐富生態系統使其在當今技術棧中仍具重要地位。

PHP中的弱參考是什麼？什麼時候有用？Apr 12, 2025 am 12:13 AM

在PHP中，弱引用是通過WeakReference類實現的，不會阻止垃圾回收器回收對象。弱引用適用於緩存系統和事件監聽器等場景，需注意其不能保證對象存活，且垃圾回收可能延遲。

解釋PHP中的__ Invoke Magic方法。Apr 12, 2025 am 12:07 AM

\_\_invoke方法允許對象像函數一樣被調用。 1.定義\_\_invoke方法使對象可被調用。 2.使用$obj(...)語法時，PHP會執行\_\_invoke方法。 3.適用於日誌記錄和計算器等場景，提高代碼靈活性和可讀性。

解釋PHP 8.1中的纖維以進行並發。Apr 12, 2025 am 12:05 AM

Fibers在PHP8.1中引入，提升了並發處理能力。 1)Fibers是一種輕量級的並發模型，類似於協程。 2)它們允許開發者手動控制任務的執行流，適合處理I/O密集型任務。 3)使用Fibers可以編寫更高效、響應性更強的代碼。

PHP社區：資源，支持和發展Apr 12, 2025 am 12:04 AM

PHP社區提供了豐富的資源和支持，幫助開發者成長。 1)資源包括官方文檔、教程、博客和開源項目如Laravel和Symfony。 2)支持可以通過StackOverflow、Reddit和Slack頻道獲得。 3)開發動態可以通過關注RFC了解。 4)融入社區可以通過積極參與、貢獻代碼和學習分享來實現。