note 104295 deleted from function.mysql-connect by danbrown
| From: | danbrown@php.net | Date: | Tue, 07 Jun 2011 15:06:41 +0000 |
| Subject: | note 104295 deleted from function.mysql-connect by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-180311@lists.php.net to get a copy of this message | ||
Note Submitter: jojamspa at gmail dot com
----
testdb.html
<html>
<head>
<script src="selectpartner.js"></script>
</head>
<body>
<form>
Partner:<br />
<select name="partners" onchange="showPartner(this.value)">
<option value="1">Partner 1</option>
<option value="2">Partner 2</option>
<option value="3">Partner 3</option>
</select>
</form>
<div id="txtHint"><b>(Information will go here)</b></div>
</body>
</html>
---------------------------------------------------------------------
selectpartner.js
var xmlhttp
function showPartner(str) {
xmlhttp=GetXmlHttpObject();
if (xmlhttp==null) {
alert ("Your browser does not support AJAX!");
return;
}
var url="getpartner.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) {
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
function GetXmlHttpObject() {
if (window.XMLHttpRequest) {
// code for IE7+, Firefox, Chrome, Opera, Safari
return new XMLHttpRequest();
}
if (window.ActiveXObject) {
// code for IE6, IE5
return new ActiveXObject("Microsoft.XMLHTTP");
}
return null;
}
----------------------------------------------------------------------------
getpartner.php
<?php
$response = "";
$link = mysql_connect('localhost', 'root', '');
if($link) {
if($setnames = mysql_query("set names 'utf8'")) {
mysql_select_db('web2');
$query = 'SELECT * FROM partners where id = '.$_GET['q'];
$result = mysql_query($query);
if($result) {
$response .= "<table>\n";
if ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
foreach ($line as $col_name => $col_value) {
$response .= "\t<tr>\n";
$response .=
"\t\t<td><b>".$col_name."</b></td>\n";
$response .= "\t\t<td>".$col_value."</td>\n";
$response .= "\t</tr>\n";
}
}
$response .= "</table>\n";
mysql_free_result($result);
}
mysql_close($link);
}
}
echo $response;
?>
----------------------------------------------------------------------