Hey guys, nice to meet you.
I have PHP/MySQL driven site. I have finally found an AJAX script to load my data in a div on the same page. It works if i click a static link, but the main purpose i need is to click link with dynamic album ids in the url, which doesn't work. I cannot tell if it is simple syntax issue in the link or whether i cant use the AJAX script for this type of thing. I have no experience with AJAX. And i'm only a moderate user of the others.
This is the AJAX script:
<script type="text/javascript">
/***********************************************
* Dynamic Ajax Content- © Dynamic Drive DHTML code library (www.dynamicdrive.com)
* This notice MUST stay intact for legal use
* Visit Dynamic Drive at http://www.dynamicdrive.com/ for full source code
***********************************************/
var loadedobjects=""
var rootdomain="http://"+window.location.hostname
function ajaxpage(url, containerid){
var page_request = false
if (window.XMLHttpRequest) // if Mozilla, Safari etc
page_request = new XMLHttpRequest()
else if (window.ActiveXObject){ // if IE
try {
page_request = new ActiveXObject("Msxml2.XMLHTTP")
}
catch (e){
try{
page_request = new ActiveXObject("Microsoft.XMLHTTP")
}
catch (e){}
}
}
else
return false
page_request.onreadystatechange=function(){
loadpage(page_request, containerid)
}
page_request.open('GET', url, true)
page_request.send(null)
}
function loadpage(page_request, containerid){
if (page_request.readyState == 4 && (page_request.status==200 || window.location.href.indexOf("http")==-1))
document.getElementById(containerid).innerHTML=page_request.responseText
}
function loadobjs(){
if (!document.getElementById)
return
for (i=0; i<arguments.length; i++){
var file=arguments[i]
var fileref=""
if (loadedobjects.indexOf(file)==-1){ //Check to see if this object has not already been added to page before proceeding
if (file.indexOf(".js")!=-1){ //If object is a js file
fileref=document.createElement('script')
fileref.setAttribute("type","text/javascript");
fileref.setAttribute("src", file);
}
else if (file.indexOf(".css")!=-1){ //If object is a css file
fileref=document.createElement("link")
fileref.setAttribute("rel", "stylesheet");
fileref.setAttribute("type", "text/css");
fileref.setAttribute("href", file);
}
}
if (fileref!=""){
document.getElementsByTagName("head").item(0).appendChild(fileref)
loadedobjects+=file+" " //Remember this object as being already added to page
}
}
}
</script>which is between the header tags
And this is the PHP that works fine (it loads the page but obviously with errors cause it cannot find what album to get):
<a class="pics" href="javascript:ajaxpage('jobs/list-jobs-detail.php', 'mainwindow');">And when i need to add the album id it doesnt work, despite displaying the URL correctly when i hover over the link (it just wont load the content at all):
<a class="pics" href="javascript:ajaxpage('jobs/list-jobs-detail.php&album=<?php echo $row['al_id']; ?>', 'mainwindow');">Really appreciate any help you can give me.
NB: This is the MySQL query in case you needed it:
$sql = "SELECT jobboard.*, joboffers.*
FROM jobboard JOIN joboffers
ON jobboard.job_num = joboffers.jobnum
WHERE joboffers.al_uname = '$session->username'
ORDER BY joboffers.offerdate Desc";
$result = mysql_query($sql) or die('Error, get user info failed. ' . mysql_error());
while ($row = mysql_fetch_assoc($result)) { etc etc...
