PHP - Separate Query Using Newlines (retrieving Not Inserting)

Below is my code that is suppose to insert and show records from database using ajax.    Retrieving the records from the database works.  However it won't insert a record.  I do not get any errors. The page simply refreshes when I hit submit button.   Can you see what might be wrong in my code?     index.php

<script>
	$(document).ready(function(){
		function showComment(){
		  $.ajax({
			type:"post",
			url:"process.php",
			data:"action=showcomment",
			success:function(data){
				 $(".wrapper").html(data);
			}
		  });
		}

		showComment();


		$("#submit").click(function(){

			  var name=$("#name").val();
			  var message=$("#details").val();

			  $.ajax({
				  type:"post",
				  url:"process.php",
				  data:"name="+name+"&details="+message+"&action=addcomment",
				  success:function(data){
					showComment();
					  
				  }

			  });

		});
   });
   </script>

$id      =     $_GET['id'];
$title    =    $_GET['title'];
        
$_SESSION['id']      =    $id;
$_SESSION['title']   =    $title;

<div class="wrapper"></div>

<form action="" method="post" enctype="multipart/form-data">
    <div class="newfield">
        <label for="title">Name <span class="highlight">*</span></label>
        <input id="name" type="text" name="name">
    </div>
    <div class="newfield">
        <label for="details">Details <span class="highlight">*</span></label>
        <textarea id="details" name="details""></textarea>
    </div>
    <input type="submit" name="submit" id="submit" value="Submit Tale">
</form>

process.php

<?php require_once '/core/init.php';

$id 	= 	$_SESSION['id'];
		
$action = $_POST['action'];

if($action == 'showcomment') {

	try {
		$get = $db->prepare("SELECT * FROM sub_posts WHERE id = :id");
		$get->bindParam('id', $id);
		$get->execute();
		$getStmt = $get->fetchAll(PDO::FETCH_ASSOC);
		if(count($getStmt) > 0) {
			
			foreach($getStmt as $row) {
			
				$new_name		= 	$row['name'];
				$new_details	= 	$row['details'];
				
				?>	
					<ul>
						<li>
							<?php echo $new_name; ?>
						</li>
						<li>
							<?php echo $new_details; ?>
						</li>
					</ul>
				<?php 
			}	
			
		} else {

			// no records found.
			
		}
		
	} catch(Exception $e) {
		die($e->getMessage());
	}

} else if($action == 'addcomment') {
								
	$name		= 	$_GET['name'];
	$details	= 	$_GET['details'];
			
	
		try {
			
			$insert = $db->prepare("INSERT INTO sub_posts(id, name, details) VALUES(:id, :name, :details)");
			$insert->bindParam('id', $id);
			$insert->bindParam('name', $name);
			$insert->bindParam('details', $details);
			$insert->execute();
			
			if($insert == false){
				
				echo 'record could not be inserted.';
				
			} else {
			
				echo 'record has been inserted.';
			
			}
			
		} catch(Exception $e) {
			die($e->getMessage());
		}
	

} else {

	echo 'no results.';
}

Edited by helloworld001, 20 December 2014 - 05:18 PM.

Hi all,

I'm currently working on a webpage that dynamically shows tables of sales for products. I'm using SQL to store 2 tables, one containing product info (name, price etc.) and one containing sales for each product.

One on of my web pages I want to show the product name and sales for a single year. This would involve ripping the product name from my product table and the sales and year from my sales table. Is this possible in one query?

$Query= "select name from productTable and sales, year from salesTable where year = $desiredyear;

Obviously I know this is wrong because it isn't working but am I even on the right lines?

Thank you.

To accomplish the layout I was looking for, I used the following code:

for ($i=1; $i<=7; $i++)
   {

//set day of week for display as title of columns
$dow=date("l", strtotime($year.'W'."$weekno"."$i"));

echo "<td class=\"wvcolumn\" valign=\"top\">
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" width=\"$daycolumn\">
<tr><th class=\"wvtitle\" valign=\"bottom\" align=\"center\" width=\"$daycolumn\"><a class=\"titledate\" href=\"createticket.php?action=o&month=".date("m", strtotime($year.'W'."$weekno"."$i"))."&date=".date("d", strtotime($year.'W'."$weekno"."$i"))."&year=".date("Y", strtotime($year.'W'."$weekno"."$i"))."\">$dow, ".date("F d", strtotime($year.'W'.$weekno."$i"))."</a>&nbsp;<a onClick=\"window.open('http://www.batchgeo.com')\" title=\"Map $dow's Appointments\" href=\"mapday.php?week=$weekno&year=$year&day=$i\"><img width=\"20\" style=\"border-style: none\" src=\"../images/icon_globe.png\"></a></th></tr>";

if(date("Y-m-d")==date("Y-m-d", strtotime($year.'W'."$weekno"."$i"))) {
$query = "SELECT fieldtickets.ticketnumber, fieldtickets.business, title, apptdatetime, DATE_FORMAT(apptdatetime,'%h:%i %p') AS fapptdatetime, status, billstatus, type, assigntech, clients.business FROM fieldtickets LEFT JOIN clients ON fieldtickets.business = clients.id WHERE status='Open' AND (type = 'Field' OR type = 'Phone') AND apptdatetime BETWEEN '".date("Y-m-d", strtotime($year.'W'."$weekno"."$i"))." 00:00:00' AND '".date("Y-m-d", strtotime($year.'W'."$weekno"."$i"))." 23:59:59' UNION SELECT fieldtickets.ticketnumber, fieldtickets.business, title, apptdatetime, DATE_FORMAT(apptdatetime,'%h:%i %p') AS fapptdatetime, status, billstatus, type, assigntech, clients.business FROM fieldtickets LEFT JOIN clients ON fieldtickets.business = clients.id WHERE status = 'Pending' ORDER BY status ASC, apptdatetime ASC";
} else { $query = "SELECT fieldtickets.ticketnumber, fieldtickets.business, title, apptdatetime, DATE_FORMAT(apptdatetime,'%h:%i %p') AS fapptdatetime, status, billstatus, type, assigntech, clients.business FROM fieldtickets LEFT JOIN clients ON fieldtickets.business = clients.id WHERE status='Open' AND (type = 'Field' OR type = 'Phone') AND apptdatetime BETWEEN '".date("Y-m-d", strtotime($year.'W'.$weekno."$i"))." 00:00:00' AND '".date("Y-m-d", strtotime($year.'W'.$weekno."$i"))." 23:59:59' ORDER BY apptdatetime ASC"; }

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
//if ticket is open show appt time and business, if ticket pending display DELIVERY and business name
if($row[status]=="Open") { $href="createticket.php?action=e&ticket=".$row[ticketnumber]; $time=$row[fapptdatetime]; $delivery=""; } elseif($row[status]=="Pending") { $href="createticket.php?action=c&ticket=".$row['ticketnumber'].""; $time=""; $delivery="DELIVER"; }
echo "<tr><td valign=\"top\"><a title=\"".$row[ticketnumber]." - ".$row[title]."\" class=\"".$row[status]."\" href=\"$href\"><span>$delivery$time ".substr($row['business'], 0, $displaychars)."</span></a></td></tr>\n"; }

echo "</table>";

}

echo "</td></tr>
</table>";

Output is similar to this, and any existing "deliveries" are displayed under the current day.
 _________________________________________________ ______________
|     Monday     |     Tuesday     |    Wednesday    |     Thursday     |       Friday       |
|appointments |appointments |appointments     |appointments   |appointments

This works great, but requires 5 separate queries. My database is very small for now, so its not a big deal, but I know this can be done much more efficiently.

How can I query the whole week and put appointments in their corresponding tables (days)? Thank you for your help!

hi guys

Ive written this php to take in two variables from the http POST, the idea is that I can multiple devices submit temperature readings to the php script, the script then append the unix time stamp and then the the 3 variables - device id, temp and unix time are then stored in a mysql DB.

I can get the variables to present on a php page for debugging but I cant get the variables to be stored in the mysql DB.

See the code:

Code: [Select]
<?php

$unixtime = time();
// get device variables
$device_id=$_GET['device'];
$device_temp=$_GET['temp'];

/* 
//for testing purposes
echo "unixtime: " . $unixtime . "<br />";
echo "device id: " . $device_id . "<br />";
echo "device_temp: " . $device_temp . "<br />";
 */

// Make a MySQL Connection
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

//mysql query
$query = "INSERT INTO temperature VALUES ('',$device_id,$temp,$unixtime)";

// Insert a row of information into the relevant device table
mysql_query($query);
or die(mysql_error());  

mysql_close();
echo "Data Inserted!";


?>

I cant see where Im going wrong to correct this, but as nothing is displayed on the page i believe I am not forming the query correctly?
- any ideas would be much appreciated.

Thank you
Mathew

I am at a loss why my query is not inserting values into db. Even if I do echo $query or var_dump($query) there is nothing printed at all. All values are being passed successfully just not being inserted. I am getting 'Could not connect' but I do not know why. All connections are established and as a test I took this code and ran it on it's own with dummy data and it inserted the data fine. I can only think it has something to do with the $response_array.  Where am I going wrong. and would appreciate any help. Thanks

Code: [Select]
<?php require_once('Connections/sample.php'); ?>
<?php

session_start();

$new = 1;
$activity = 'General Contact Enquiry';
$mobile = 'Submitted from mobile';
$name = mysql_real_escape_string($_POST['GC_name']);
$department = mysql_real_escape_string($_POST['GC_department']);
$message = mysql_real_escape_string($_POST['GC_message']);
$email = mysql_real_escape_string($_POST['GC_email']);
$company = mysql_real_escape_string($_POST['GC_company']);
$position = mysql_real_escape_string($_POST['GC_position']);

//response array with status code and message
$response_array = array();

//validate the post form

//check the name field
if(empty($name)){

    //set the response
    $response_array['status'] = 'error';
    $response_array['message'] = 'Name cannot be blank';

//check the name field
} elseif(empty($company)) {

    //set the response
    $response_array['status'] = 'error';
    $response_array['message'] = 'You must enter a company name';

//check the position field
}elseif(empty($position)) {

    //set the response
    $response_array['status'] = 'error';
    $response_array['message'] = 'You must enter a position';

//check the email field
} elseif(empty($email)) {

    //set the response
    $response_array['status'] = 'error';
    $response_array['message'] = 'You must enter a valid email address';

//check the dept field
}elseif($department=="Choose Department") {

    //set the response
    $response_array['status'] = 'error';
    $response_array['message'] = 'You must select a department';

//check the message field
}elseif(empty($message)) {

    //set the response
    $response_array['status'] = 'error';
    $response_array['message'] = 'You must enter a message';

//check the dept field
}
else {

    //set the response
    $response_array['status'] = 'success';
    $response_array['message'] = 'Your enquiry has been sent succesfully';
    $flag=1;
 }

//send the response back
echo json_encode($response_array);

if($flag == 1) {

    mysql_select_db($database_sample, $sample);
    $query = 'INSERT INTO feedback (company, department, name,  email, position, feedback, date, new) VALUES (\''.$company.'\', \''.$department.'\', \''.$name.'\', \''.$email.'\', \''.$position.'\', \''.$message.'\', NOW() , \''.$new.'\')';
    mysql_query($query) or die("Could not connect");
    }
    

?>