note 104295 added to function.mysql-connect
| From: | jojamspa at gmail dot com | Date: | Tue, 07 Jun 2011 06:00:36 +0000 |
| Subject: | note 104295 added to function.mysql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-180305@lists.php.net to get a copy of this message | ||
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;
?>
----------------------------------------------------------------------
----
Server IP: 92.43.200.200
Probable Submitter: 77.111.81.155
----
Manual Page -- http://www.php.net/manual/en/function.mysql-connect.php
Edit -- https://master.php.net/note/edit/104295
Del: integrated -- https://master.php.net/note/delete/104295/integrated
Del: useless -- https://master.php.net/note/delete/104295/useless
Del: bad code -- https://master.php.net/note/delete/104295/bad+code
Del: spam -- https://master.php.net/note/delete/104295/spam
Del: non-english -- https://master.php.net/note/delete/104295/non-english
Del: in docs -- https://master.php.net/note/delete/104295/in+docs
Del: other reasons-- https://master.php.net/note/delete/104295
Reject -- https://master.php.net/note/reject/104295
Search -- https://master.php.net/manage/user-notes.php