How could I pass PHP URL variables to AJAX so I can get the page content load in the same page ?? Here is an example of what I am trying to to do .. I am trying for example to get the "profile.php?id= to AJAX so that page content be be loaded .. However , I first started using a loop .. I dont know if that's the right way to go about it ..
Below is the code
<div id="myDiv"><h2>Let AJAX change this text</h2></div>
<?php
require('../madscore/database/connect.php');
database_connect();
$query = "select * from Entertainers";
$result = $connection->query($query);
$row_count =$result->num_rows;
for($i = 1; $i <= $row_count; $i++)
{
$row = $result->fetch_assoc();
//echo $i. "<br />";
// echo $row['Name']."<br />";
// echo $row['Profession']."<br />";
// echo $row['Score']."<br />";
?>
<!DOCTYPE html>
<html>
<head>
<script>
function loadXMLDoc()
{
var xmlhttp;
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("myDiv").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","profile.php?id="<?php echo $row['ID'] ?>, true");
xmlhttp.send();
}
</script>
<?php echo "<a href='/profile.php?id=".$row['ID']."' onclick='loadXMLDoc()'><img src ='../".$row['Picture']."' width='100' height='100' /> </a>"; } ?>
</body>
</html>
Change this --
xmlhttp.open("GET","profile.php?id="<?php echo $row['ID'] ?>, true");
To this --
xmlhttp.open("GET","profile.php?id=<?php echo $row['ID'] ?>", true);
EDIT as per comments - Try this-
myid = <?php echo $row['ID'] ?>;
//myid = "<?php echo $row['ID'] ?>"; //Or this if its a string type
xmlhttp.open("GET","profile.php?id="+myid, true);
After such a long chat --
<?php echo "<a href='/profile.php?id=".$row['ID']."' onclick='loadXMLDoc(".$row['ID'].")'><img src ='../".$row['Picture']."' width='100' height='100' /> </a>"; } ?>
Pass $row['ID'] to your loadXMLDoc() method.
Final Code ---
<div id="myDiv"><h2>Let AJAX change this text</h2></div>
<?php
require('../madscore/database/connect.php');
database_connect();
$query = "select * from Entertainers";
$result = $connection->query($query);
$row_count =$result->num_rows;
for($i = 1; $i <= $row_count; $i++)
{
$row = $result->fetch_assoc();
?>
<!DOCTYPE html>
<html>
<head>
<script>
function loadXMLDoc( myid )
{
var xmlhttp;
var myloveid = id;
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("myDiv").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","profile.php?id="+myloveid, true");
xmlhttp.send();
}
</script>
<?php echo "<a href='/profile.php?id=".$row['ID']."' onclick='loadXMLDoc(".$row['ID'].")'><img src ='../".$row['Picture']."' width='100' height='100' /> </a>"; } ?>
</body>
</html>
Replace this
xmlhttp.open("GET","profile.php?id="<?php echo $row['ID'] ?>, true");
with this
xmlhttp.open("GET","profile.php?id=<?php echo $row['ID']; ?>, true");
The ; is very important.
If you dont write it then it will not echo the value.