Hi...
Im trying to connect AJAX with PHP/MYSQL. I wrote a basic code for connecting this. I got codings from http://www.w3schools.com/PHP/php_ajax_database.asp.
1) I created database and tables.
2) While i run the ajax_db.html, if i select anything, im getting
Unable to connect with the server:
[Object error]
I used document.write message and i checked the select name number is passing in the java script. But i doesnt call the xmlhttp.open(). I wrote the correct address. But im getting the error...
Will any one help me to correct this?
Below i list out the codings
ajax_db.html - <html>
-
<head>
-
<title>Connecting with DB</title>
-
<script type="text/javascript" src="ajax_db.js"> </script>
-
-
</head>
-
-
<body>
-
-
<form>
-
Select a person
-
<select name="users" onchange="showUser(this.value)">
-
<option value="">Select a person:</option>
-
<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>
-
-
<br />
-
<div id="txtHint"><b>Person info will be listed here.</b></div>
-
-
</body>
-
</html>
ajax_db.js - function showUser(str)
-
{
-
// document.write(str);
-
-
if (str=="")
-
{
-
document.getElementById("txtHint").innerHTML="";
-
return;
-
}
-
if (window.XMLHttpRequest)
-
{
-
// code for IE7+, Firefox, Chrome, Opera, Safari
-
xmlhttp=new XMLHttpRequest();
-
}
-
else
-
{
-
// code for IE6, IE5
-
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
-
}
-
xmlhttp.onreadystatechange=function()
-
{
-
if (xmlhttp.readyState==4 && xmlhttp.status==200)
-
{
-
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
-
}
-
}
-
-
try{
-
//xmlhttp.open('GET','getuser.php?q='+str,true);
-
xmlhttp.open('GET','http://192.168.100.152/~rekha/AJAX/getuser.php?q='+str,true);
-
xmlhttp.send();
-
}catch(e) {
-
alert("Unable to connect with the server:\n" +e.toString());
-
}
-
}
getuser.php - <?php
-
-
$q = $_GET["q"];
-
echo $q;
-
-
$con = mysql_connect("192.168.100.152", "DB", "bbscn107");
-
if (!$con)
-
{
-
die('Could not connect: ' . mysql_error());
-
}
-
-
mysql_select_db("TEST", $con);
-
-
$sql="SELECT * FROM user WHERE id = '".$q."'";
-
echo $sql;
-
-
$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);
-
?>
-
6  4023 
Have you tried making a direct request to getuser.php with a query string? For example, enter this into your browser: http://192.168.100.152/~rekha/AJAX/getuser.php?q=1
Does it come up with anything? If it gives you the error, then the problem is with your database connection or query. Do that and post back the results and we'll help you more, right now there are too many things it could be.
All I needed to know was whether or not typing the path directly into the browser resulted in the error. I'm not 100% positive because I use jQuery, but I'm pretty sure you can't make AJAX calls to full URLs ( http://something.com), some security thing or whatever. If you've got all 3 files in the same folder, then you need to remove this line:
xmlhttp.open('GET','http://192.168.100.152/~rekha/AJAX/getuser.php?q='+str,true);
And uncomment this line:
//xmlhttp.open('GET','getuser.php?q='+str,true);
Do that and let me know what the result is. Also, this line:
document.getElementById("txtHint").innerHTML=xmlht tp.responseText;
Make sure there is no space in the word xmlhttp. I don't know why I didn't see that earlier, but that's probably your problem.
I checked my program. There is no space in b/w xmlhttp.
document.getElementById("txtHint").innerHTML=xmlht tp.responseText;
I kept all 2 files in the same folder. I uncomment the below line.
xmlhttp.open('GET','getuser.php?q='+str,true);
I tried to run the program. But i got the same error message :(
My object xmlhttp.open wouldnt call the PHP program...
yyy?????
You said all 2 files, but there should be 3, ajax_db.html, ajax_db.js, and getuser.php.
Maybe someone else will be able to help you, because I see nothing wrong with the code, you pretty much copied it word-for-word from the w3schools site.
Sorry... I have all 3 files in the same folder... But i cant able to run it... Im getting the error msg... :(
Sign in to post your reply or Sign up for a free account.
Similar topics
by: JMB |
last post by:
Hello,
I was wondering if anyone knew of any projects extending the inline upload
progress bar to utilize an inpage image uploader with bar, without having to
refresh or go to a seperate page,...
|
by: Martin |
last post by:
Hello NG,
I've been doing some AJAX for a few weeks now. The basics worked fine so
far, but now I've got the following problem which I can't solve:
With AJAX you typically update/replace only...
|
by: abrtlt |
last post by:
I would like to have a web page in which, when the user clicks on any
of several specific elements, a specific audio file is played, without
reloading the page.
The specific audio file name is...
|
by: jafarsalam |
last post by:
hi;
I'm new to PHP and AJAX MySQL codes. I found a simple code for
PHP and AJAX MySQL Database communication on :
http://www.w3schools.com/php/php_ajax_database.asp
I downloaded the code and...
|
by: bss |
last post by:
Dear All,
I have developing a French website using PHP & Ajax. In that I tried
to display some French texts from mysql database using Ajax. Form
local I got the text from db with
Correct...
|
by: buss123 |
last post by:
Hi,
in our application we are using AJAX . but application is working in IE well but in FIREFOX it is is not opening .my doubt is wether FIREFOX will support AJAX or not
|
by: acl20032003 |
last post by:
anyone here could show me a simple codes on deleting files from the database using ajax?
any help would be appreciated.
im just new to ajax.
|
by: ghjk |
last post by:
I'm developing web application using php. In there i want to refresh one of my table which is having mysql data, using ajax. How can I do that? I didn't know anything about ajax and could you please...
|
by: javediq143 |
last post by:
Hi All,
This is my first post in this forum. I'm developing a CMS for my latest website. This CMS is also in PhP & MySQL. I'm done with the ADD section where the Admin can INSERT new records in...
|
by: raamay |
last post by:
hello experts, i have fetched records from mysql database and against each record i want to place a update tag which when clicked will update the corresponding record using ajax and php. But here...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
