PHP - Get City Id From Ajax Generating City Select Box To My Original Php Page

I have a problem with the following code but i really don't see it:

I try to populate the city textfield by the zipcode entered on the zipcode textfield

function fillcitystate(controlname)
   {
   
   var zipstring = "";
   xmlhttp = new XMLHttpRequest();
   xmlhttp.open("GET", "postcode.php?postcode=" + controlname.value, true);
   xmlhttp.onreadystatechange=function()
      {
      if (xmlhttp.readyState==4)
         {
         var zipstring = xmlhttp.responseText;
         if (zipstring!="Error")
            {
            var ziparray = zipstring.split("|");
            document.getElementById("test").innerHTML = ziparray[1];
            }
         }
      }
   xmlhttp.send(null);
   }


In postcode.php

$returnval = "Error";
$postcode = $_GET['postcode'];


$query = "SELECT * FROM city WHERE code='$postcode'";
$resultval = mysql_query($query);
$rowcount = mysql_num_rows($resultval);
if ($rowcount==1)

   {
   $row = mysql_fetch_array($resultval);
   $returnval = $row['code']."|".ucwords(strtolower($row['name']))."|".$row['province'];
   }
else

   {
   }
echo $returnval;


When entering a zipcode, nothing happened so i decided to just echo the name of the city using the innerHTML. Still nothing happened, so i commented out all the php in my postcode.php and decided to just do:

$postcode = $_GET['postcode'];
echo $postcode;

then it printed out: 'undefined'


Can somebody point me out?

Hi, Im not sure whether this is a PHP or MySQL question, but im trying to get a select menu to only display the number of options that are defined in the mysql database.   For example   The code I have that retrieves the $quantity from the database.   Lets say that   $quantity = 3   Now I would like the option menu to only display three options, like this:

<select name="quantity">
<option value="<?php echo $quantity ?>"><?php echo 'Maximum of ' . $quantity . ' available'?></option>
<option value="1">1</option> 
<option value="2">2</option>
<option value="3">3</option>
</select>

but for example, if the $quantity was equal to 10 then I would like the menu to be displayed as such

<select name="quantity">
<option value="<?php echo $quantity ?>"><?php echo 'Maximum of ' . $quantity . ' available'?></option>
<option value="1">1</option> 
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>

How is it possible to do this? I am completely at a loss here.   Many Thanks   aquaman

I want people to login and then be redirected back to the page from where they came from.  I was thinking that maybe I would have to use $_GET for 3 pages but I don't know if there is any easier way.

I'm trying to generate a page with javascript in it with PHP.  But the quotations are causing me problems, I need a third set of quotations.  Here is the part I am having trouble with:


echo"<div class='level'>Edit:</div><div class='box'><input type = 'text'  size='50' name='cat' value='$cat'/> <b><input type='button' value='+ Details' onclick='document.getElementById('rev$clicker').style.display='block';'/></b> </div><br>";


When I view the html it comes out onclick='document.getElementById('rev$clicker').style.display='block';'

I can't use "" quotations for 'block' and 'rev$clicker' because that would exit from the echo and I can't exit php because I need the $clicker variable.

Hey guys!

I need your help with some issues.
Firstly, I have an own website with a database filled with products, and also a template page(template.php) for each product. Problem is that I don't know how to generate each product from the database in the template.php file using their id from the database. How can I do this?

Second problem, I got an own checkout and I don't know how to redirect the customer to a "thank you for buying" page after clicking "Finish Order". It sends the customer to a white page where it says: "Thanks for buying!".

Third and last thing, do you guys know where can I find a php checkout template to follow?

Thanks in advance for your answers!
Cheers!

This topic has been moved to Ajax Help.

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

Hi,
It appears I ran into the dreaded IE <select> issue with innerhtml.  I have looked at multiple solutions but alas I reach out for help!
The code works beautifully in Safari and Firefox but fails in IE  by simply loading blanks when AJAX is called.
I read up on microsoft.com a DIV may work outside the <select>.  But I must be messing something up.
Thanks for your puzzle solving help!

Code:

AJAX:
xmlHttp.onreadystatechange=function(){
       if(xmlHttp.readyState==4) {
         var temp=(xmlHttp.responseText);
         document.getElementById("option").innerHTML=temp;   
            }
   }
   var queryString = "?page=" + page;                                
   xmlHttp.open("GET","AJAX_page.php" + queryString,true);
   xmlHttp.send(null);

PHP:
<?php
echo "<form action='next.php' method='POST'>";
echo "<select name='id' id='option'><option value=0>Option_0/option>";
{
echo "<option value ='$id'>$choice</option>";
}
echo "</select>";
echo "<input type='submit' value='Submit'></form>";                  
?>

Here is my code

if(isset($_POST['pass_btn']))
{
    $numchars = 8;
    $chars = explode(',','2,3,4,5,6,7,8,9,a,b,c,d,e,f,g,h,i,j,k,m,n,p,q,r,s,t,u,v,w,x,y,z,2,3,4,5,6,7,8,9,A,B,C,D,E,F,G,H,J,K,L,M,N,P,Q,R,S,T,U,V,W,X,Y,Z,2,3,4,5,6,7,8,9');
    $password='';
        for($i=0; $i<$numchars;$i++)
        {
            $password.=$chars[rand(0,count($chars)-1)];
        }
}

This is set up so when a person pressing the pass_btn, a password is provided.  This works just fine.  However, it refreshes the page and clears all other data that user may have entered.

Suggestions?

This topic has been moved to Ajax Help.

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

I had this working, but when I try and get fancy and use AJAX the data doesn't display. I think this is a PHP problem though.

My code for the select form including AJAX code

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-GB">
<head>
<title>AJAX Example</title>
<link rel="stylesheet" type="text/css" href="Form.css" media="screen" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript">
 $(document).ready(function(){
 $("tr:odd").addClass("odd");
 });
</script>
<script type="text/javascript">
function showPlayers(str)
{
var xmlhttp;
if (str=="")
  {
  document.getElementById("DataDisplay").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("DataDisplay").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","Query.php?category_id="+str,true);
xmlhttp.send();
}
</script>
        </head>

<body>

<h1">AJAX Example</h1>

<?php
#connect to MySQL
$conn = @mysql_connect( "localhost","username","pw")
or die( "You did not successfully connect to the DB!" );

#select the specified database
$rs = @mysql_SELECT_DB ("MyDB", $conn )
or die ( "Error connecting to the database test!");
?>
<form name="sports" id="sports">
<legend>Select a Sport</legend>
<select name="category_id" onChange="showPlayers(this.value)">
<option value="">Select a Sport:</option>
<?php
$sql = "SELECT category_id, sport FROM sports ".
"ORDER BY sport";

$rs = mysql_query($sql);

while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"".$row['category_id']."\">".$row['sport']."</option>\n  ";
}
?>
</select>

</form>
<br />
<div id="DataDisplay"></div>

</body>
</html>


             
                       
 
Query.php


<?php
#get the id
$id=$_GET["category_id"];

#connect to MySQL
$conn = @mysql_connect( "localhost","username","pw")
or die( "Error connecting to MySQL" );

#select the specified database
$rs = @mysql_SELECT_DB ("MyDB", $conn )
or die ( "Could not select that particular Database");
#$id="category_id";
#create the query
$sql ="SELECT *
FROM sports
INNER JOIN players ON sports.category_id = players.category_id
WHERE players.category_id = '".$id."'";


echo $sql;

#execute the query
$rs = mysql_query($sql,$conn);
#start the table code
echo "<table><tr><th>Category ID</th><th>Sport</th><th>First Name</th><th>Last Name</th></tr>";
#write the data
while( $row = mysql_fetch_array( $rs) )
{
echo ("<tr><td>");
echo ($row["category_id"] );
echo ("</td>");
echo ("<td>");
echo ($row["sport"]);
echo ("</td>");

echo ("<td>");
echo ($row["first_name"]);
echo ("</td>");

echo ("<td>");
echo ($row["last_name"]);
echo ("</td></tr>");
}
echo "</tr></table>";
mysql_close($conn);
?>


I think the problem is either with this part in the AJAX
Code: [Select]
xmlhttp.open("GET","Query.php?category_id="+str,true);

or most likely in my Query.php code

when I wasn't using AJAX and using POST it worked fine, but adding the AJAX stuff and GET it doesn't work.

When I echo out the SQL the result is

Code: [Select]
SELECT * FROM sports INNER JOIN players ON sports.category_id = players.category_id WHERE players.category_id = ''

so the category_id is not being selected properly and that is the primary key/foreign key in the MySQL table which connects the JOIN.

 

My index.php,

$output .= '
		<div class="col-sm-3 col-lg-4 col-md-3">
			<div style="border:1px solid #ccc; border-radius:5px; padding:10px; margin-bottom:16px; height:300px;">
				<audio controls controlsList="nodownload" style="padding: 10px 10px 10px 10px;margin-left: -21px;">
					<source src="audio_sample/'. $row['voice_audio_file'] .'" alt="" class="img-responsive">
				</audio>
				<p align="center"><strong> '. $row['voice_name'] .'</strong></p>

				<p style="font-size: 12px;">
				Id				  : '. $row['voice_id'].' <br />
				Name			  : '. $row['voice_name'].' <br />
				Gender		      : '. $row['voice_gender'].' <br />
				Genres 			  : '. $row['voice_genres'].' <br />
				Voice Modulation  : '. $row['voice_voice_modulation'].' <br />
				Languages		  : '. $row['voice_languages'].' <br />
				Jingle Moods	  : '. $row['voice_jingle_moods'].' <br />
				Ivr 			  : '. $row['voice_ivr'].' <br /> </p>
				
				<button type="button" class="btn btn-primary" type="submit" onclick="addCart('. "'".$row["voice_id"]."'".','."'". $row["voice_name"]."'".');" style="padding: 5px 83px 5px 83px;">Add to PlayList </button>

same page ajax :

 

<script>
function addCart(voice_id, voice_name)
	{

		$.ajax({
			type: 'POST',
			url: 'cart.php',
			data: {
				voice_id   : voice_id,
				voice_name : voice_name
			},
			dataType: 'text',
			success: function(data) {
				// alert(data);


			}
		});
	}
$(document).ready(function(){

});
</script>

and get.php

 

<?php 


$voice_id =" ";
$voice_name=" ";
if(isset($_POST['voice_id']) && isset($_POST['voice_name']))
{
    $voice_id = $_POST['voice_id'];
    $voice_name = $_POST['voice_name'];

}

echo "$voice_id, . "&". , $voice_name";


?>

if click button, the value send but the get.php not properly get the value and display on the php page.

 

Edited June 12, 2019 by aveeva

Hey guys,

I'm making an Ajax call to my database and retrieving a newsletters HTML code as the result. I then prepend it into a div area called code_content. I use some php str_replace to add some links also.

When the content loads into the div, the user can then add further content to it via Ajax calls, appending articles and that.

What I'm trying to figure out is how can I then retrieve all the newly edited contents of this code_content div soni can send it to my Ajax function to write to te db?

Hello,
   First of all ,I have been a regular reader of the forum and it has increased my knowledge in the PHP a lot. 
 Till now i had just been a guest user and used to go through the queries and tips posted here.

Today , for the first time i am posting on the forum

Coming to a problem:
 I have to design a function for a client from travel domain. Where he wants the script/function to go and extract data from an airline website on the available fare for a specific date and destination. The problem is that only a part of fare(Base fare) is visible on the site and you have to select one of the given flight option(s) (after selecting the option through AJAX the full fare is displayed on the same page on the left hand site) to get the complete fare including fare and surcharges.

Now i want my function/script to extract the full fare for all the available flight options. I have written the below piece of code. But its not efffective as it gets only the base fare part of the result page and not the complete fare.. 

The airline booking url is : http://book.spicejet.com/skylights/cgi-bin/skylights.cgi

My code:

//---- Spicejet start
// ENGINE URL http://book.spicejet.com/skylights/cgi-bin/skylights.cgi?page=homecomp

//Taking some sample search data - just to test the script
$event="search" ;
$module="SB" ;
$page="SEARCH" ;
$mode="empty" ;
$travel="1" ;     // ONE WAY OR 2 WAY
$from1="HYD" ;
$to1="DEL" ;
$departDay1="13" ;
$departDay2="";
$departMonth1="201010" ;
$ADULT="1" ;
$CHILD="0" ;
$INFANT="0" ;
$toCity1="DEL" ;
$numberMarkets="1" ;

// the page needs data in POST form
$curlPost = 'event='  . urlencode($event) . '&module=' . urlencode($module) .'&page=' . urlencode($page) .'&mode=' . urlencode($mode) .'&travel=' . urlencode($travel) .'&from1=' . urlencode($from1) .'&to1=' . urlencode($to1) .'&departDay1=' . urlencode($departDay1) .'&departMonth1=' . urlencode($departMonth1) .'&ADULT=' . urlencode($ADULT) .'&CHILD=' . urlencode($CHILD) .'&INFANT=' . urlencode($INFANT) .'&toCity1=' . urlencode($toCity1) .'&numberMarkets=' . urlencode($numberMarkets).'&submitSearch=submitSearch';
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://book.spicejet.com/skylights/cgi-bin/skylights.cgi');
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_USERAGENT, "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 2.0.50727; .NET CLR 1.1.4322)");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $curlPost);
$data = curl_exec($ch);
curl_close($ch);

echo($data); 



Also one more query Is there something like beautiful soup (As in Python) to parse the data. I want to extract the flight timing and total price from the page and insert into a database.

Thanxs in advance

Hello, everyone. I have code that effectively calls a PHP page with AJAX  (no JQuery).  The PHP responds fine with an echo.  Here is the javaScript that calls the PHP so refreshing the page doesn't need to be done.

 

function deleteCategory()
{
	var e= document.getElementById("dropDown1");
	var var1 = e.options[e.selectedIndex].text;
	var xmlhttp = new XMLHttpRequest();
	xmlhttp.onreadystatechange = alerta() {
	if (this.readyState == 4 && this.status == 200) {
		
			document.getElementById("insert").innerHTML = xmlhttp.responseText;
		}
	};
	
	xmlhttp.open("GET", "deleteRow.php?q=" + var1 , true);
	xmlhttp.send();
 }

How do I call a PHP function on the same page while preserving the above AJAX.

 

Sincerely,

Joshua

Hi

I have put together a options page for the script that I have been working on.  I have 1 options page where there options are divided into 4 jQuery tabs with there own save button.  The options in each tab are posted using Ajax to their own separate file like process.php, process1.php etc. 
My question is there a way to place all the processing code in one file and if so would this affect the load on the server?  Would each form be better off having their own page for processing? 

For example:
Code: [Select]
<form id="options_1" action="process1.php" method="post" >

          <!-- this is form 1 that is processed with process1.php -->

</form>

<form id="options_2" action="process2.php" method="post" >

          <!-- this is form 2 Can this form be processed using process1.php instead of process2.php -->

</form>

<form id="options_3" action="process3.php" method="post" >

          <!-- this is form 3 Can this form be processed using process1.php instead of process3.php -->

</form>