PHP - Passing Form Data To Multiple Scripts

Hello,
I have three scripts below that I was wondering if someone can look at as a second opinion.

What they all have in common is they are supposed to append data to some tables in my database.  They match the code on all my other scripts but for some reason these particular scripts will not append the data to the files.

This first one...
is supposed to insert the name of the doctor this person uses, and then gets the last ID created and inserts it into another table...no matter what I try, it will not do it.

Code: [Select]
<?php

session_start();
$userid=$_SESSION['userID'];
$firstName=$_SESSION['fname'];
$lastName=$_SESSION['lname'];
$camperID=$_POST['camperID'];
$physicianFName=$_POST['physicianFName'];
$physicianLName=$_POST['physicianLName'];
$physicianSuffix=$_POST['physicianSuffix'];
$practiceName=$_POST['practiceName'];
$physicianAddress1=$_POST['physicianAddress1'];
$physicianAddress2=$_POST['physicianAddress2'];
$physicianAddress3=$_POST['physicianAddress3'];
$physicianCity=$_POST['physicianCity'];
$physicianState=$_POST['physicianState'];
$physicianZip=$_POST['physicianZip'];
$physicianOfficeP=$_POST['physicianOfficeP'];
$physicianOfficeF=$_POST['physicianOfficeF'];
$physicianSpecialty=$_POST['physicianSpecialty'];


echo $camperID. ' ' .$physicianFName. ' ' .$physicianLName;

//htc information and physician

$htcName=$_POST['htcInfo'];
$htcPhysician=$_POST['htcPhysician'];

$con=mysql_connect("xxx.xxx.xxx.xx", "xxx", "xxxx") or die ("cannot connect");
mysql_select_db("testcamp") or die ("cannot select database");

$sql="INSERT INTO Physicians(physicianFName, physicianLName, physicianSuffix, practiceName, physicianAddress1, physicianAddress2, physicianAddress3, physicianCity,
physicianState, physicianZip, physicianOfficeP, physicianOfficeF, physicianSpecialty) VALUES ('$physicianFName', '$physicianLName', '$physicianSuffix', '$physicianAddress1',
'$physicianAddress2', '$physicianAddress3', '$physicianCity', '$physicianState', '$physicianZip', '$physicianOfficeP', '$physicianOfficeF', '$physicianSpecialty')";

$result=mysql_query($sql,$con);
$physicianID=mysql_insert_id();

$sql2="INSERT INTO CamperPhysicianInfo(physicianID, camperID) VALUES ('$physicianID', '$camperID')";
$result2=mysql_query($sql2,$con);

$sql3="INSERT INTO CamperHTCInfo(camperID, htcID) VALUES ('$camperID', '$htcName')";
$result3=mysql_query($sql3,$con);

$sql4="INSERT INTO camperHTCPhysicianInfo(camperID, htcPhysicianID) VALUES ('$camperID', '$htcPhysician')";
$result4=mysql_query($sql4,$con);

?>

This next one...is supposed to enter data into the CamperRegistrations tables and also enter data into another table for a questionaire that was completed on the form previous to this page...same thing no matter what I try will not append data.

Code: [Select]
<?php

$question12=$_POST['question12'];
$question12a=$_POST['question12a'];





session_start();
$userid=$_SESSION['userID'];
$firstName=$_SESSION['fname'];
$lastName=$_SESSION['lname'];

$camperID=$_SESSION['camperID'];


$con=mysql_connect("xxx.xxx.xxx.xx", "xxx", "xxx") or die ("cannot connect");
mysql_select_db("testcamp") or die ("cannot select database");

$sql="INSERT INTO Question12(camperID, question12Answer, teaching) VALUES ('$camperID', '$question12', '$question12a')";
$result=mysql_query($sql,$con);

$date=date("Y-m-d");
$defaultStatus=1;

$sql2="INSERT INTO CamperRegistrations(userID, camperID, registrationDate, registrationStatus) VALUES ('$userid', '$camperID', '$date', '$defaultStatus')";
$result2=mysql_query($sql2,$con);

?>

and then on this same page with this script...
is it possible to carry session information when using HTML links instead of a submit form?

I need the userid to carry to the next page with a link, but it won't do that either...

Any help would be appreciated and thanks in advance for looking.

~jcjst21

I can add and delete data from my table. Now I need to be able to change one or more fields in an entry. So I want to retrieve a row from the db, display that data on a form where the user can change any field and then pass the changed data to an update.php program.

I know how to go from form to php. But how do I pass the data from retrieve.php to a form so it will display? Do I use a URL and Get? Can I put the retrieve and form in the same program?

This topic has been moved to MySQL Help.

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

Ok so i want to grab an id from the checkbox then grab the option drop down associated with that check box and update a mysql row here is my code so far

any help is awesome help taaaanks guys

<?php
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());
$query = "SELECT * FROM tickets ORDER BY id DESC";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{

print "<input name='delete[]' value='{$row['id']}' type='checkbox'>";
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());
$query2 = "SELECT * FROM admin";
$result2 = mysql_query($query2) or die(mysql_error());
print "<form name='namestoupdate' method='post' action='update.php'>\n";
print '<select>';
while($row2 = mysql_fetch_array($result2))
{
if ($row2['priv']==prov){print '<option value="'.$row2['user'].'" name="prov['.$i++.']">'.$row2['user'].'</option>';}
}
print '</select>';
print "<input type='submit' value='submit' />";
print "</form>";
}
?>


Visual aid

Hello all,

   I am trying to learn OOP in PHP so please forgive my ignorance. I seem to be having difficulty inserting data into my database from checkbox items. My database has a column for each each fruit. I would like for each column to be populated with either a one(1) for checked or a zero(0)  for not checked. Currently, my attempts have failed. I can either get all checkboxes to insert all zeros or I can get the first column to insert a one(1) while the others as zeros. Is there anybody here that can help me figure out what I am doing wrong and help me to re-work my code so I can get this to work? If anybody can help me using OOP methods that would be fantastic. Thank you all in advance.

 

$preffruit->create_preffruit(array(

  'fruit_apple' => escape(Input::get(['fruit_selection'][0]) ? 1 : 0),
  'fruit_orange' => escape(Input::get(['fruit_selection'][1]) ? 1 : 0),
  'fruit_banana' => escape(Input::get(['fruit_selection'][2]) ? 1 : 0),
  'fruit_pear' => escape(Input::get(['fruit_selection'][3]) ? 1 : 0),
  'fruit_kiwi' => escape(Input::get(['fruit_selection'][4]) ? 1 : 0)

  ));

<input type="checkbox" name="fruit_selection[]" value="fruit_apple">
<input type="checkbox" name="fruit_selection[]" value="fruit_orange">
<input type="checkbox" name="fruit_selection[]" value="fruit_banana">
<input type="checkbox" name="fruit_selection[]" value="fruit_pear">
<input type="checkbox" name="fruit_selection[]" value="fruit_kiwi">



public function insert_preffruit($table, $fields = array()) {
			
			$keys = array_keys($fields);
			$values = '';
			$x = 1;			
			
			foreach($fields as $field) {
				$values .= '?';
				if($x < count($fields)) {
					$values .= ', ';
				}
				$x++;
			}		
				
				$sql = "INSERT INTO preffruit (`user_id`, `" . implode('`, `', $keys) . "`) VALUES (LAST_INSERT_ID(), {$values})";		
			
			if(!$this->query($sql, $fields)->error()) {
				return true;
			}			
			
			return false;
		}

 

Edited September 23, 2020 by ke-jo

Hello Everyone,

I'm not a programmer, so please bear with me.

I have a form, and on submit, need for it to send the data 1. to formmail.cgi (a PERL script) that emails me the information and then 2. sends the data to a shopping cart script called phpcart.php

I'm told the best way to do this, is to have the forms ACTION post to a php script, which executes the two scripts above.

I imagine something like this:

<?php
send data to formmail.cgi.  When finished
send data to phpcart.php
exit
?>

I've installed a few PHP applications on my site, but writing code is beyond me.

Can anyone help?

I would surely appreciate it.

James

Hi, after banging my head against the wall for a while thinking this would be a simple task, I'm discovering that this is more complicated than I thought.

Basically what I have is a link table linking together source_id and subject_id.   For each subject there are multiple sources associated with each.

I had created a basic listing of sources by subject... no problem.   I now need a way of having a form to create an ordered list in a user-specified way.  In other words, I can currently order by id or alphabetically (subject name lives on a different table), but I need the option of choosing the order in which they display.  I added another row to this table called order_by.  No problem again, and I can manage all of this in the database, however I want to create a basic form where I can view sources by subject and then enter a number that I can use for sorting.

I started off looping through each of the entries and the database (with a where), and creating a foreach like so (with the subject_id being grabbed via GET from the URL on a previous script)
Code: [Select]
while($row = mysqli_fetch_array($rs)) {


//update row order
if (isset($_POST['submit']))  {

//get variables, and assign order

$subject_id = $_GET['subject_id'];
$order_by = $_POST['order_by'];
$source_id = $row['source_id'];


//echo 'Order by entered as ' . $order_by . '<br />';

foreach ($_POST['order_by'] as $order_by) {

$qorder = "UPDATE source_subject set order_by = '$order_by'
WHERE source_id = '$source_id'
AND subject_id = '$subject_id'";

mysqli_query($dbc, $qorder)
or die ('could not insert order');

// echo $subject_id . ', ' . $order_by . ', ' . $source_id;
// echo '<br />';
} 
}
else {
$subject_id = $_GET['subject_id'];
$order_by = $row['order_by'];
$source_id = $row['source_id'];

}

And have the line in the form like so:
Code: [Select]
echo '<input type="text" id="order_by" name="order_by[]" size="1" value="'. $order_by .'"/>

(yes I know I didn't escape the input field... it's all stored in an htaccess protected directory;  I will clean it up later once I get it to work)

This, of course, results in every source_id getting the same "order_by" no matter what I put into each field.

I'm thinking that I need to do some sort of foreach where I go through foreach source_id and have it update the "order_by" field for each one, but I must admit I'm not sure how to go about this (the flaws of being self-taught I suppose;  I don't have anyone to go to on this).

I'm hoping someone here can help?

Thanks a ton in advance

So i got the following problem:

i got some pages : index.php , comment.php, viewArticle.php

When i try to submit something from comment.php appear a error "Undefined variable:result"
The var result is defined in index.php
When i click on one article from the list the function viewArticle() is requiring viewArticle.php and the function addcomment() is requiring comment.php

The addcomment function() is in viewArticle function()

I can't figure out what's wrong but I guess have something to do whit the form action="index.php?action=viewArticle&articleid=<?php echo $result['article']->id?>"

index.php code
Code: [Select]
<?php

include('config.php');

$action = isset($_GET['action'])?$_GET['action']:"";

switch($action)
{
case 'viewArticle':viewArticle();break;
    default:homepage();
}

function homepage()
{
$result = array();
    $data = Article::getlist(1);
    $result['article']=$data['result'];
$result['total']=$data['totalrows'];
    require('homepage.php');
}

function viewArticle()
{
if( !isset($_GET['articleid']) )homepage();
$result = array();
    $result['article'] =  Article::getbyid((int)$_GET['articleid']);
$result['name'] = $result['article']->name;
addcomment();
require('viewArticle.php');
}

function addcomment()
{

   
if(isset ($_POST['submit'] ))
{
$comment = new Comment;
$set = array();
$set['usern']="HJhj";
$set['com']="aca wqeq";
$set['page']=7;
$comment->storeFormValues($set);
$comment->insertc();
}
    else require('comment.php');

}

?>
viewArticle.php code
Code: [Select]
<center>
<h1> <?php echo $result['article']->text ?> </h1>


comment.php code:

Code: [Select]
<form method='post' action="index.php?action=viewArticle&articleid=<?php echo $result['article']->id?>" >
<input type="hidden" name="id" value="56"/>

<ul>
<li>
  <input type="text" name="usern" id="usern" />
</li>

<li>
<textarea name="com" id="com" COLS=40 ROWS=6></textarea>
</li>

<input type="hidden" name="page" value="56" />
<input type="submit" name="submit" value="submit" />

</form>

Hi.   I'm in the need of some help. Cant figure out what is wrong with the code. Getting undefined all the time.

The idea is to pass current playing video and user data to javascript using data-value="valuehere" and then let javascript to send the data to db with the current time and so on.   I had a working solution but wanted to use videojs player and now im stuck.

The code before was:

	(function(a){
		a(".history").on("click",function(){

			var b=a(this).data("mp4");
			var store_type=a(this).data("store_type");
			var store_title=a(this).data("store_title");
			var store_tmdbid=a(this).data("store_tmdbid");
			var subtitle=a(this).data("subtitle");
			var resume=a(this).data("resume");
			var user_id=a(this).data("user_id");
			var playpath=a(this).data("mp4")+a(this).data("resume");

			a(".yt-modal-box").append('<div class="modal fade" id="yt-modal"><div class="modal-dialog"><div class="modal-body flex-video widescreen"></div></div></div>');
			a("#yt-modal").modal();
			a("#yt-modal").find(".modal-body").html('<button type="button" class="modal-close" data-dismiss="modal" aria-hidden="true"></button><div id="video_container"><video width="100%" controls autoplay id="video"><source src="'+playpath+'" type="video/mp4"><track kind="subtitles" src="files/Movies/Subtitles/'+subtitle+'" srclang="et" />Your browser does not support the video tag.</video></div>');
			a(document).on("hide.bs.modal",function(){ clearInterval(refreshId); a(".modal-body").html("")})

			function updater(){
				$.post("modules/api/unfinished/update.php",{
					unban: "none",
					user_id: user_id,
					filename: b,
					store_type: store_type,
					store_title: store_title,
					store_tmdbid: store_tmdbid,
					lenght:	video.duration,
					position: video.currentTime,
				})
				.done(function(data){
			    if(data == 1){

						$.post("assets/api/unfinished/update.php",{
							unban: "unban", user_id: user_id, filename: b, lenght:	video.duration, position: video.currentTime,
						})

						function redirect(){
						   window.location = 'logout.php'
						}

						setTimeout(redirect, 2000);

			    }
			  });
			}

			var refreshId = setInterval(updater, 5000);

		})
	})(jQuery);

Now i have something like this:

 

<video id="example_video_1" class="video-js vjs-default-skin vjs-big-play-centered history" controls preload="auto" width="100%" height="389" data-resume="123" data-setup="{}" >

var myValue;

(function(a){
			
 a(".history").ready(function(){
  myValue=a(this).data("resume");
 })

 videojs("example_video_1").ready(function(){
			
  var myPlayer = this;
		  
  myPlayer.on("play", function(){
   alert(window.myValue);  // I would like to use the myValue under this.
  });
		  
  //myPlayer.play();
	
 });
	
})(jQuery);

If you have something then please help out. Thanks.

I have a form on our website that a user can fill out for custom product.  I want the form data to be 1) stored into a mysql database AND after storing said data, 2) email the same data to our sales department.

1)  The form data DOES get stored into mysql database (except for the first two fields, for some weird reason)

2) I added a "mail" section to the php file that stores the data into the database, but it is not working correctly.  I have stripped the email portion down to sending just one of the fields in the "message" to make it easier for troubleshooting

I have included here, both the form section of the html file, and the formdata.php file that processes the data for your  analysis.  I am relatively new to php so there are going to be some issues with security, but I can work on those after I get the store & email process to work correctly.  Please review my code and see if anyone can be of assistance.  I looked through the forums and couldn't find another issue that was the same as mine.  If I just overlooked, please tell me the thread post #.  Thanks

THE FORM WHICH COLLECTS THE DATA
*******************************
<form method=POST action=formdata.php>

                 
  <table width="640" border=0 align="center">
    <tr>
      <td align=right><b>First Name</b></td>
      <td><input type=text name=FName size=25></td>
      <td><div align="right"><b>Telephone</b></div></td>
      <td><input type=text name=Tel size=25></td>
    </tr>
    <tr>
      <td align=right><b>Last Name</b></td>
      <td><input type=text name=LName size=25></td>
      <td><div align="right"><b>Fax</b></div></td>
      <td><input type=text name=Fax size=25></td>
    </tr>
    <tr>
      <td align=right><b>Title</b></td>
      <td><input type=text name=Title size=25></td>
      <td><div align="right"><b>Email</b></div></td>
      <td><input type=text name=Email size=50></td>
    </tr>
    <tr>
      <td align=right><b>Company</b></td>
      <td><input type=text name=Comp size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Address</b></td>
      <td><input type=text name=Addr size=25></td>
      <td><div align="right"><b>Estimated Annual Volume</b></div></td>
      <td><input type=text name=EAV size=25></td>
    </tr>
    <tr>
      <td align=right><b>City</b></td>
      <td><input type=text name=City size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>State/Province</b></td>
      <td><input type=text name=SProv size=25></td>
      <td><div align="right"><b>Application</b></div></td>
      <td><input type=text name=Appl size=25></td>
    </tr>
    <tr>
      <td align=right><b>Country</b></td>
      <td><input type=text name=Ctry size=25></td>
      <td><div align="right"><b>Type of System</b></div></td>
      <td><input type=text name=Syst size=25></td>
    </tr>
    <tr>
      <td align=right><b>Zip/Postal Code</b></td>
      <td><input type=text name=ZPC size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td><div align="right"><strong><font color="#FFFF00" face="Arial, Helvetica, sans-serif">COIL
          DESIGN</font></strong></div></td>
      <td><font color="#FFFF00" face="Arial, Helvetica, sans-serif"><strong>PARAMETERS</strong></font></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Primary Resistance (ohms)</b></td>
      <td><input type=text name=Pres size=25></td>
      <td><div align="right"><b>Primary Inductance (mH)</b></div></td>
      <td><input type=text name=Pind size=25></td>
    </tr>
    <tr>
      <td align=right><b>Secondary Resistance (ohms)</b></td>
      <td><input type=text name=Sres size=25></td>
      <td><div align="right"><b>Secondary Inductance (H)</b></div></td>
      <td><input type=text name=Sind size=25></td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Peak Operating Current (Amps)</b></td>
      <td><input type=text name=POC size=25></td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b>Output Energy (mJ)</b></td>
      <td><input type=text name=Egy size=25></td>
      <td><div align="right"><b>Output Voltage (kV)</b></div></td>
      <td><input type=text name=Volt size=25></td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right><b># HV Towers per Coil</b></td>
      <td><input type=text name=TPC size=25></td>
      <td><div align="right"><b># of Coils per Package</b></div></td>
      <td><input type=text name=CPP size=25></td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td align=right>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <th colspan=4><b>Please enter any additional information he </b></th>
    </tr>
    <tr>
      <th colspan=4><textarea name=Mess cols=50 rows=10 id="Message"></textarea></th>
    </tr>
  </table>
  </dl>
  <div align="center">
    <p>
      <input type=hidden name=BodyTag value="&lt;body  bgcolor=&quot;#484589&quot; text=&quot;#FFFFFF&quot; link=&quot;#FFFF00&quot; alink=&quot;#FFFFFF&quot; vlink=&quot;#FF7F00&quot;&gt;">
      <input type=hidden name=FA value=SendMail>
    </p>
    <p><font color="#FFFF00" face="Arial, Helvetica, sans-serif"><strong>PLEASE MAKE SURE ALL
      INFORMATION<br>
      IS CORRECT BEFORE SUBMITTING</strong></font></p>
    <p>
      <input type=submit value="Submit Form">
    </p>
  </div>
</form>
THE FILE THAT PROCESSES THE FORM DATA (formdata.php)
***********************************************
<?php
$con = mysql_connect("localhost","XXX","XXX");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("customform", $con);

$sql="INSERT INTO formdata (Fname, Lname, Title, Comp, Addr, City, SProv, Ctry, ZPC, Tel, Fax, Email, EAV, Appl, Syst, Pres, Pind, Sres, Sind, POC, Egy, Volt, TPC, CPP, Mess)
VALUES ('$_POST[Fname]','$_POST[Lname]','$_POST[Title]','$_POST[Comp]','$_POST[Addr]','$_POST[City]','$_POST[SProv]','$_POST[Ctry]','$_POST[ZPC]','$_POST[Tel]','$_POST[Fax]','$_POST[Email]','$_POST[EAV]','$_POST[Appl]','$_POST[Syst]','$_POST[Pres]','$_POST[Pind]','$_POST[Sres]','$_POST[Sind]','$_POST[POC]','$_POST[Egy]','$_POST[Volt]','$_POST[TPC]','$_POST[CPP]','$_POST[Mess]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "Your Information Was Successfully Posted";

mysql_close($con);

$to = "recipient email address here"; 
$subject = "Custom Form"; 
$email = $_POST['Email'] ; 
$message = $_POST['Comp'] ; 
$headers = "From: $Email"; 
$sent = mail($to, $subject, $message, $headers) ; 
if($sent) 
{print "Your mail was sent successfully"; }
else 
{print "We encountered an error sending your mail"; }
?>

Having some issues, hopefully you guys can identify a solution for me.

There are 7 Servers involved in this situation - Each with its own website.

Server 1 houses a page with content that is shared by the other 6 servers.

I need to change an image (logo) at the top of Server 1 page based upon which server they originally came from.

For example they are traveling from server 4, when they arrive at server 1 they see server 1 content however the image at the top will corrospond with correct brand in this example server 4's logo.

Cookies have not been a reliable solution considering they are usually disabled.

Please Help Guys, Any feedback is Fantastic!

Hi guys,

I have a form with a multiselect option as below

Code: [Select]
       <select multiple="multiple" id="smoker" name="smoker[]">
               <option value="" selected="selected">Please select</option>     

<option value="No" >No</option>

<option value="Occasionally" >Occasionally</option>

<option value="Often" >Often</option>

<option value="Open to All" >Open to All</option>
   </select>

and need to pass this info into mysql insert, but before that I need them to be seperated by coma, i have the code below but keep getting errors



Code: [Select]

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$smoker=stripslashes($_POST['smoker']);
$smoker_db=implode(", ",$smoker);

}


this is the error i get

Quote

Notice: Array to string conversion in ......



Could you please help me with this?

Many thanks in advance

I'm using PHP and MySQL to display images on the first page.    When the image is clicked on I'm passing an ID to a new page.   I want that ID to display the ID data that's associated with  that ID.    For example:    ID 1 should display - Title - title1,  Details - details1, image - image1    and ID 2   ID 1 should dislay - Title - title2,  Details - details2, image - image2   But only displaying ID 1 data not matter if the URL is - website.com/thedetials.php?id=1  or  website.com/thedetials.php?id=2   In other words, it displays the same data even though the id in the URL is different.        Page 1

$sql="SELECT * FROM thetable";
	  
$result = mysqli_query($con,$sql);
  
 echo " <ul>";
	
  while($row = mysqli_fetch_array($result) {
  echo "<li'>";

  echo "<a href='page2.php?id=$row[id]'><img src=$row[image]></a>";
	                                          
  echo "</li>";
    
 }
  
  echo "</ul>";  
           
 ?> 
     
     

<?php
// End while loop.


mysqli_close($con);

?>

Page 2

$id = $_GET['id']; 

$sql="SELECT id, title, details, image, FROM thetable";
	  
$result = mysqli_query($con,$sql);


$row = mysqli_fetch_array($result);
?>


   <?php echo $row['title'] ?> 
   <?php echo $row['details'] ?>
   <img class='projectItem-pic' src="<?php echo $row['image']?>">

If I use below - No data displays, not sure why.

$sql="SELECT * FROM thetable WHERE id = $id";  

Can someone tell me what I'm doing wrong? 
Edited by patmon, 08 June 2014 - 09:22 PM.

Hi,   I have a php script that generates a select dropdown box   <option value="1"> Bob </option> <option value="2"> Tim </option> <option value="3"> Sam </option> <option value="4"> Phil </option>   I then have the following javascript to produce my google api graph:  

<script type="text/javascript">
google.load('visualization', '1', {'packages':['corechart']});
google.setOnLoadCallback(drawChart);


function drawChart() {
var jsonData = $.ajax({
url: "test1.php",
dataType:"json",
async: false,
}).responseText;


var data = new google.visualization.DataTable(jsonData);


var chart = new google.visualization.LineChart(document.getElementById('chart_div'));
chart.draw(data); 
}
</script>

This then runs a php script that returns the data back in Json format.   How can I pass the <option value=""> through the to the test1.php script to generate the json data based on the the value selected i.e 1, 2, 3 etc.    i an new at javascript and the google api can anyone let me know how I can get this variable sent through by the google api script. and for the graph to refresh every time another option is chosen.    Thanks   kris