PHP - Ajax And Php Issue

Hello,

I've been trying this for hours now, looking at different examples and trying to change them to work for me, but with no luck...

This is what I am trying to do:

I have a simple form with:
- 1 input field, where I can enter a number
- 1 Submit Button

When I enter a number into the field and click submit, I want that number to be send to the php file that is in the ajax call, then the script will take that number and run a bunch of queries and then return a new number. I want that new number to be used to call the php script via ajax again, until no number is returned, or something else is returned like the word "done" or something like that, at which point is simply makes an alert or populated a div with a message...

The point is, that depending on the number entered it could take up to an hour to complete ALL the queries, so I want the script that is called to only run a fixed amount of queries at a time and then return the number it is currently at (+1), so that it can continue with the next number when it is called again.

I would like to use jquery, but could also be any other way, as long as I get this to work. I already have the php script completed that needs to be called by the ajax, it returns a single number when being called.

Thank you,
vb

As the title say, I can not for the life of me get the "$bank" content to display, no matter HOW much I try...
Does anyone see any errors. I am sooooooo wiped out at this!


main page

<?
$body = '

<script type="text/javascript" src="change-content.js"></script>

<div id="addSold">
<form action="'.$_SERVER['REQUEST_URI'].'" method="post" name="form" autocomplete="off">

<fieldset id="Vehicle">
<legend>Vehicle</legend>
<ul>
<li><label for="Year">Year</label>'.$Year.'</li>
<li><label for="Make">Make</label>'.$Make.'</li>
<li><label for="Model">Model</label>'.$Model.'</li>
<li><label for="Trim">Trim</label><input type="text" name="Trim" id="Trim" size="10" value="'.$trim.'" disabled="disabled"></li>
</ul>
<ul>
<li><label for="Mileage">Mileage</label><input type="text" name="Mileage" id="Mileage" size="5" maxlength="6" value="'.$row['mileage'].'"></li>
<li><label for="VIN">VIN</label><input type="text" name="VIN" id="VIN" size="23" maxlength="17" value="'.$row['vin'].'" disabled="disabled"></li>
<li><label for="Color">Color</label>'.$Exterior.'</li>
</ul>
</fieldset>

<fieldset id="Deal">
<legend>Deal</legend>
<ul>
<li>
<label for="soldDte1">Date</label>
<input type="text" name="soldDte1" id="soldDte1" size="1" maxlength="2" onkeyup="return autoTab(this, 2, event)" value="08"> / 
<input type="text" name="soldDte2" id="soldDte2" size="1" maxlength="2" onkeyup="return autoTab(this, 2, event)" value="30"> / 
<input type="text" name="soldDte3" id="soldDte3" size="1" maxlength="2" value="'.$year.'">
<a href="#"><img id="date_'.$row[stock].'" src="images/Icons/dateOff.png" onfocus="this.select();lcs(this)" onmouseover="MM_swapImage(\'date_'.$row[stock].'\',\'\',\'images/Icons/dateOn.png\',1)" onmouseout="MM_swapImgRestore()" alt="Choose Date"></a>
</li>
<li>
<label for="salesman">Salesman</label> 
<select name="salesman" id="salesman">
<option></option>
'.$salesmen.'
</select>
</li>
</ul>
<ul>
<li>
<label for="dealType">Deal Type</label>
<select name="dealType" class="select-content" onchange="getFile(this.value)">
<option></option>
<option value="AL">Auto Loan</option>
<option value="Cash">Cash</option>
<option value="CAC">Credit Acceptance</option>
<option value="IH">In House</option>
<option value="SAL">Sensible Auto</option>
</select>
</li>
<li>
<label for="tradeDrop">Trade</label> 
<select name="tradein" id="tradeDrop" onchange="show_hide_trade(this.value);">
<option value="No">No</option>
<option value="Yes">Yes</option>
</select>
</li>
</ul>
</fieldset>

<div id="Bank" class="view">'.$bank.'</div>
</form>
</div>
';
?>


get_Bank.php

<?
if ($_GET['dealType'] == "AL") {
$bank = '
<fieldset id="AL">
<legend>Auto Loan Figures</legend>
<ul>
<li><label for="price">Price</label><input type="text" name="price" id="price" class="price" size="7" onchange="currency(this)"></li>
<li><label for="down">Down</label><input type="text" name="down" id="down" class="price" size="6" onchange="currency(this)"></li>
<li><label for="tax">Tax</label><input type="text" name="tax" id="tax" class="price" size="6" onchange="currency(this)"></li>
<li><label for="reg">Plates</label><input type="text" name="reg" id="reg" class="price" size="4" onchange="currency(this)"></li>
<li><label for="gap">Gap</label><input type="text" name="gap" id="gap" class="price" size="4" onchange="currency(this)"></li>
</ul>
<ul>
<li>
<label for="pymtNum">--------------- Payment ---------------</label>
<input type="text" name="pymtNum" id="pymtNum" size="3" maxlength="3" onkeyup="return autoTab(this, 3, event)"> @ 
<input type="text" name="pymtAmnt" id="pymtAmnt" class="price" size="5" onchange="currency(this)"> per 
<select name="pymtType">
<option value="Weekly" selected="selected">Week</option>
<option value="Monthly">Month</option>
</select>
</li>
<li><label for="APR">APR</label><input type="text" name="APR" id="APR" class="rate" size="6" value="19.00"></li>
</ul>
</fieldset>
';
} elseif ($_GET['dealType'] == "CAC") {
$bank = '
Credit Acceptance stuff goes here
';
} else {
$bank = 'You must choose a bank before continuing';
}

?>


change-content.js
Code: [Select]
window.onload = init;

// finds all <select> tags will class="select-content" and activates function
function init() {
var sel = document.getElementsByTagName("select");
for (var i=0; i<sel.length; i++){
if (sel[i].className == "select-content") {
sel[i].onchange = getFile;
}
sel[i].selectedIndex = 0;
}
}

function getFile (url) {
var url = "AJAX/get_Bank.php?dealType="+ this.value;
if (window.XMLHttpRequest) {xmlhttp=new XMLHttpRequest();}
else {xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");}

xmlhttp.open("GET",url,false);
xmlhttp.send();

// a loop that looks through all <div>s on the page
// and then replaces the id with the value and gets that file
var divs = document.getElementsByTagName("div");
for (var i=0; i<divs.length; i++) {
if(divs[i].id == "bank") {
divs[i].id = this.value;
divs[i].innerHTML=xmlhttp.responseText;
}
}
}

Folks,

I remember once having a php or html5 issue where the first option had to be blank in the drop down. Otherwise, it wasn't working.

What wasn't working ? How wasn't working ? I can't remember. either php had difficulty reading user input or the drop down was not showing any options. And so, I had to add a blank value.

So, something like this wasn't working ...

	<label for="tos_agreement">Agree to TOS or not ?</label>
<select name="tos_agreement" id="tos_agreement">
<option value="yes">Yes</option>
<option value="no">No</option>
</select>
	

 

And, I think I added a blank value, at somebody's advice, to get it to work. I think it was something like this, if I remember correctly:

	<label for="tos_agreement">Agree to TOS or not ?</label>
<select name="tos_agreement" id="tos_agreement">
	<option value=" ">Select here</option>
<option value="yes">Yes</option>
<option value="no">No</option>
</select>
	

Or, maybe it was something like this:

	<label for="tos_agreement">Agree to TOS or not ?</label>
<select name="tos_agreement" id="tos_agreement">
	<option value=" "></option>
<option value="yes">Yes</option>
<option value="no">No</option>
</select>
	

 

I can't remember. All I remember slightly that there was a blank value.

I been going through my php files to find that particular file to jog my memory but I failed to find it.

Can you folks explain to me if a blank value is required or not ? What is the benefit/disaster of adding it and how should the blank value be added ? Show me an example.

 

Was this a php or html 5 issue ? Can anybody fugure ?

 

Thank You

Hi, I have this code below which groups all the SubHeading together and then queries the same table to find RiskConsequence which are grouped that match SubHeading then to query this table one more last time with all the Risk Mitigation that matches the grouped RiskConsequence.

Problem I get is it does the SubHeading, the RiskConsequences it only does one of them not all of them before it moves onto the RiskMitigation.

I know I have a php coding issue just cant see the wood from the tree's as the queries work.

Code: [Select]
<?php
include ("include.php");
$query = "SELECT * FROM tblriskassessmentdatabank GROUP BY SubHeading";
$results = mysql_query($query) or die("Error: " . mysql_error());
while($row1 = mysql_fetch_array($results)){
    

    echo'<a href="#" onClick="return(changeDisplay(';echo"'";echo($row1[SubHeading]);echo"'))";echo'">';echo($row1[SubHeading]);echo'</a><br /><br />';
echo'<div id="';echo($row1[SubHeading]); echo'" class="HideText">';

$risksub = $row1[SubHeading];

$query1 = "SELECT * FROM tblriskassessmentdatabank GROUP By RiskConsequence";
$results1 = mysql_query($query1) or die("Error: " . mysql_error());
while($row2 = mysql_fetch_array($results1)){


echo'<a href="#" onClick="return(changeDisplay(';echo"'";echo($row2[RiskConsequence]);echo"'))";echo'">';echo($row2[RiskConsequence]);echo'</a><br />';
echo'<div id="';echo($row2[RiskConsequence]); echo'" class="HideText">';
$risksub1 = $row2[RiskConsequence];
$query1 = "SELECT * FROM tblriskassessmentdatabank WHERE RiskConsequence = '$risksub1'";
$results1 = mysql_query($query1) or die("Error: " . mysql_error());
while($row3 = mysql_fetch_array($results1)){

echo'<input name="checkbox[]" type="checkbox" id="checkbox[]" value="';echo($row3[IssueNumber]);echo'" />
    <label for="checkbox[]"></label>';echo($row3[RiskMitigation]);echo'<br /><br />';
}
echo'</div>';

}

echo'</div>';
  }
?>

i have a select box and need to change the  data with the selection.it is working correctly , my problem is that  in the data  i have a paging .when we going to next page no data showing . ie select box will not have any value.
how to solve this problem.


thanks in advance

Just thought I would ask as I see that the AJAX help board is something of a ghost town (much like the MS SQL board).  Since my post there doas also have some php in it, and I am in no way certain my problem is not in the php could anyone that knows a bit of both please have a look at it he http://www.phpfreaks.com/forums/index.php?topic=343419.0

cheers, just hope this circumvents the double posting rule 

How should I structure XMLHTTPRequests? Should I create a controller called Ajax and post/get all ajax calls through the methods of that controller?

What have other people done in the past? What worked best for you?

Hi guys,
I am after some simple code/tutorial that shows how to make an AJAX/jQuery function to fetch data from a PHP MySQL Database on a timed interval.

So far I have not been able to find a simple example of this so if anyone can help out that would be very much appreciated.

Cheers in advance.

im trying to get this ajax function working but for some reason it runs the error function...I've corresponded with the manual and I can't see a fault...any advise would be great...thanks

$(document).ready(function() 
{
	$.ajax(
	{
		url: "items.php",
		dataType: "json",
		data: '<?php echo $data; ?>',
		timeout: '2000',
		cache: false,

		error: function(data) 
		{ 
                  alert('error');
	    },

		success: function(data)
		{ 
			$.each(data, function() 
			{
				$("#table").append('<div class="row"><span class="cell">'+ data.title +'</span><span class="cell"></span><span class="cell"></span></div>');
			});
		}
	 });
});

Hey guys.

I was hoping that someone could tell me how i could make an auto update sort of thing.

my php:
for($i = $num; $i <= 100; $i++){
       //lots more code here
       echo $i
}

But what i want it to do is echo $i once the code has finished then when it dose it agien it replaces $i with the
new $i

Thanks

JRagon

I have this first example for ajax but it dosent work is there importance for import jquery librery?

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>

<body>
<div id="commit">
</div>
<script type="text/javascript">
function getinfo ()
{
var xmlhttp;
	if(window.XMLHttpRequest)
	   xmlhttp = new XMLHttpRequest();
	else
	   xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
xmlhttp.onreadystatechange = function ()
{
	if(xmlhttp.readyState ==4 & xmlhttp.status == 200)
	   document.getElementById("commit").innerHTML =xmlhttp.responeText;
}
xmlhttp.open("GET","info.php",true);
xmlhttp.send();
}
</script>
<button type="button" onClick="getinfo()">send</button>
</body>
</html>

Hi folks, i am trying to impliment a ajax php search function to my site, but just stuck on how to prevent a undefined variable

Here is thee ofending code:

<?php
$con = mysql_connect("localhost", "root", ""); 
if (!$con)
{
die('<p>There seems to be a problem, please try again soon.</p>');
}
$db_selected = mysql_select_db("database",$con);

//get the q parameter from URL
$q=$_GET["q"];

//lookup all links from the xml file if length of q>0
$sql="SELECT * FROM simp_search WHERE `sbody` LIKE '%{$q}%' OR `varia` LIKE '%{$q}%' OR `stitle` LIKE '%{$q}%' ORDER BY `stitle`";

$result = mysql_query($sql);


      
      if (mysql_num_rows($result) < 1) {
         $error[] = "<p>Please try another search...";
      }else {
         $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($result)) {
            $results[] = "{$i}:<a href=\"http://www.mysite/{$row['url']}\">{$row['stitle']}</a><br />{$row['sbody']}<br /><br />";
            $i++;
         }
      }
   

function removeEmpty($var) {
   return (!empty($var)); 
}

if ($results > 0){$output = "<p>Your search term: " . $q .  " returned:<br><br>" . implode("", $results);
}
else {$output= "No results found!";}
echo "$output";
?>

At the moment its a mishmash of code from other applications.
Works fine if you insert a search term that is in the database, however if you enter something that doesnt match, the output is:

Notice: undefined variable: results in C:\www\website\livesearch.php on line 35
No results found!


Any ideas on what to change to prevent this? Also i know there is some code in there that is not needed.

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=312841.0

Hi,
I am going to start a project which would be like a single page site, sending requests from one page and displaying result on same page. I would like to know which framework would be better.

here i see top 10 frameworks
http://www.phpframeworks.com/top-10-php-frameworks/

any suggestion please?
Thanks

Evening fellow freaks

I am having a major problem with what I think is quite a simple script, its basically just a ajax same page registration script that is throwing up some php errors. I am not sure if the error lies in the php or js, or both!

Ill post the scripts and then explain the problem

login.php
<script type="text/javascript" src="http://code.jquery.com/jquery-latest.js"></script>
<script type="text/javascript">
$(document).ready(function() {

//if submit button is clicked
$('#signin_submit').click(function () {

//Get the data from all the fields
var username = $('input[name=username]');
var email = $('input[name=email]');
var password = $('input[name=password]');


//Simple validation to make sure user entered something
//If error found, add hightlight class to the text field
if (username.val()=='') {
name.addClass('hightlight');
return false;
} else name.removeClass('hightlight');

if (email.val()=='') {
email.addClass('hightlight');
return false;
} else email.removeClass('hightlight');

if (password.val()=='') {
comment.addClass('hightlight');
return false;
} else password.removeClass('hightlight');

//organize the data properly
var data = 'username=' + username.val() + '&email=' + email.val() + '&password=' + 
password.val();

//disabled all the text fields
$('.text').attr('disabled','true');

//show the loading sign
$('.loading').show();

//start the ajax
$.ajax({
//this is the php file that processes the data and send mail
url: "processreg.php",

//GET method is used
type: "GET",

//pass the data
data: data,

//Do not cache the page
cache: false,

//success
success: function (html) {
//if process.php returned 1/true (send mail success)
if (html==1) {
//hide the form
$('.form').fadeOut('slow');

//show the success message
$('.done').fadeIn('slow');

//if process.php returned 0/false (send mail failed)
} else alert('Sorry, unexpected error. Please try again later.');
}
});

//cancel the submit button default behaviours
return false;
});
});
</script>


<div id="logincontainer">
<div id="topnav" class="topnav">
<a href="login" class="login"><span>Register</span></a>
<a href="login" class="signin"><span>Log In</span></a> 
</div>

 <fieldset id="signin_menu">
<form method="post" id="signin" action="">
<label for="username">Username</label>
    <input id="username" name="username" value="" title="username" tabindex="4" type="text">
      <br>
<label for="password">Password</label>
    <input id="password" name="password" value="" title="password" tabindex="5" type="password">
 <p class="remember">
<input id="signin_submit" value="Sign in" tabindex="6" type="submit">
<input id="remember" name="remember_me" value="1" tabindex="7" type="checkbox">
<label for="remember">Remember me</label>
</p>
<p class="forgot"> <a href="#" id="resend_password_link">Forgot your password?</a> </p>
<p class="forgot-username"> <A id=forgot_username_link title="If you remember your password, try logging in with your email" href="#">Forgot your username?</A> </p>
</form>
</fieldset>
    
     <fieldset id="login_menu">
<form method="post" id="login" action="processreg.php">
<label for="username">Username</label>
    <input id="username" name="username" title="username" type="text">
    <br>
    <label for="email">Email</label>
    <input id="email" name="email" title="email" type="text"><br>
    <label for="password">Password</label>
    <input id="password" name="password"  title="password" type="password">
<input id="submit" value="Register" type="submit">


</p>
</form>
</fieldset>
    
    <div class="loading"></div>
    <div class="done">
<b>Thank you for joining!</b> You can now login. 
</div>

</div>
<script type="text/javascript">

        $(document).ready(function() {



            $(".signin").click(function(e) {          

e.preventDefault();

                $("fieldset#signin_menu").toggle();

$(".signin").toggleClass("menu-open");

            });



$("fieldset#signin_menu").mouseup(function() {

return false

});

$(document).mouseup(function(e) {

if($(e.target).parent("a.signin").length==0) {

$(".signin").removeClass("menu-open");

$("fieldset#signin_menu").hide();

}

});



        });


$(document).ready(function() {



            $(".login").click(function(e) {          

e.preventDefault();

                $("fieldset#login_menu").toggle();

$(".login").toggleClass("menu-open");

            });



$("fieldset#login_menu").mouseup(function() {

return false

});

$(document).mouseup(function(e) {

if($(e.target).parent("a.login").length==0) {

$(".login").removeClass("menu-open");

$("fieldset#login_menu").hide();

}

});



        });

</script>

<script src="javascripts/jquery.tipsy.js" type="text/javascript"></script>

<script type='text/javascript'>

    $(function() {

  $('#forgot_username_link').tipsy({gravity: 'w'});   

    });

  </script>



and processreg.php
<?php
include('connect.php');

//Retrieve form data. 
//GET - user submitted data using AJAX
//POST - in case user does not support javascript, we'll use POST instead
$username = ($_GET['username']) ? $_GET['username'] : $_POST['username'];
$email = ($_GET['email']) ?$_GET['email'] : $_POST['email'];
$password = ($_GET['password']) ?$_GET['password'] : $_POST['password'];


//flag to indicate which method it uses. If POST set it to 1
if ($_POST) $post=1;

//Simple server side validation for POST data, of course, you should validate the email
if (!$username) $errors[count($errors)] = 'Please enter your name.';
if (!$email) $errors[count($errors)] = 'Please enter your email.'; 
if (!$password) $errors[count($errors)] = 'Please enter your required password.'; 

//if the errors array is empty, send the mail
if (!$errors) {



$newpassword= md5($password);

$result="INSERT INTO userbase (username, email, password)
VALUES
('$username','$email','$newpassword')";

//if POST was used, display the message straight away
if ($_POST) {
if (!mysql_query($result)) echo 'Thank you! We have received your message.';
else echo 'Sorry, unexpected error. Please try again later';

//else if GET was used, return the boolean value so that 
//ajax script can react accordingly
//1 means success, 0 means failed
} else {
echo $result;
}

//if the errors array has values
} else {
//display the errors message
for ($i=0; $i<count($errors); $i++) echo $errors[$i] . '<br/>';

exit;
}


?>


The output errors
Quote

Notice: Undefined index: username in C:\wamp\www\buy2earn\processreg.php on line 7

Notice: Undefined index: email in C:\wamp\www\buy2earn\processreg.php on line 8

Notice: Undefined index: password in C:\wamp\www\buy2earn\processreg.php on line 9

Notice: Undefined variable: errors in C:\wamp\www\buy2earn\processreg.php on line 21
Thank you! We have received your message.


Now this is basic basic errors, which I know normally means I have named my form inputs different to the processing script, but in this case they are correct.

I am using the second form in the login script  which is this one:
Code: [Select]
<form method="post" id="login" action="processreg.php">
<label for="username">Username</label>
    <input id="username" name="username" title="username" type="text">
    <br>
    <label for="email">Email</label>
    <input id="email" name="email" title="email" type="text"><br>
    <label for="password">Password</label>
    <input id="password" name="password"  title="password" type="password">
<input id="submit" value="Register" type="submit">

Can anyone explain what's the problem? My js skills are non existent so this came from my collection of saved rar files with no explanations and some very basic editing!

Many Thanks