PHP - How Do I Insert The Content Of Two Different Variables Into The Same Tablefield?

I have no idea and there is no reason why this should not be working.

im simply trying to add three variables into a database, and only one works.

the other two do not work for any reason i can find.

can someone point out my error, if any?

code:
<?php
$date = date("Y-m-d"); 
$dbc = mysqli_connect('localhost', 'root', '', 'timer')
or die('Error connecting to DB');
$query = @"INSERT INTO sessions (date, user, sessiontime) VALUES ('$date', '$user', '$sessiontime')";
$user = @$_GET['user'];
$sessiontime = @$_GET['clock'];
if (@$_GET['addDB'] == "Session Complete")
{
mysqli_query($dbc, $query)
or die( '<br>Query string: ' . $query . '<br>Produced error: ' . mysqli_error($dbc) );
}
?>

Form:
Code: [Select]
<label for="user"><b><em>Your name:&nbsp;&nbsp;</b></em></label><br /><input type="text" name="user" value="Admin/User" />
<input id="clock" name="clock" type="text" value="00:00:0" readonly><br>
<input id="startstopbutton" type="button" value="S t a r t" onClick="startstop();" style="font-weight:bold"><br> 
    <input type="submit" name="addDB" value="Session Complete" />
See, all the variables match up!?

I dont get what im doing wrong?

I am new to PHP and am currently learning the ropes.  I have writen some code to insert a line into a mySQL database.  I have created 3 fields in the mySQL database and am passing values two them.  I can use a declared variable to pass information to the filed ID (Index filed in mySQL) but if I use a variable to pass purely text values the database is not updated. 

mysql_query( "INSERT INTO $tbl_name (category_Name, ID, test) VALUES ($category, $internalId, $category2)" );

If I replace the variables with specific text, the rows are added successfully.

mysql_query( "INSERT INTO $tbl_name (category_Name, ID, test) VALUES ('werwerwer', $internalId, 'werrr')" );


It must be something stupid, I am sure.  Full code below




ob_start();
$host="localhost:8888"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name="expenses"; // Database name
$tbl_name="expense_category"; // Table name
$category="test3";
$internalId="7";
$category2="test3";

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

mysql_query( "INSERT INTO $tbl_name (category_Name, ID, test) VALUES ('werwerwer', $internalId, 'werrr')" );

    echo "Done now 6!";



?>

I am trying to modify a header redirect similar to this:

header("Location: index.html");
exit;

I would like to do something like this:

header("Location: index.html?user=' . $user . '");
exit;

Ofcourse, this does not work.  Any hints?

Hello.

I have  a simple enough code that takes information from one table and drops it into another.  This is great, but I have 2a new complexities that I have been unable to code correctly.

A.  'lastname', 'firstname' on table1 need to be combined into 'name'

How & Where do I combine these strings and then pass them?

Code: [Select]
<?php
include('dbconfig.php');


// Make a MySQL Connection
mysql_connect("localhost", "$user", "$password") or die(mysql_error());
mysql_select_db("$database") or die(mysql_error());

$result = mysql_query(
"INSERT INTO table2 (lastname, firstname, email)
SELECT lastname, firstname, email
FROM table1
WHERE email='someemail@gmail.com' ") or die(mysql_error());

?>

First page adds a new job number, then the order page loaded with the job number id as a get id. Basically there is a while loop in the order page which shows products/services client can order and he chooses what he requires 'one or eight services' (8 in total) and some other variables like date of order and client name etc. Here is the order item code

The first sql statement executes fine, but in the second sql query nothing happens


$sql="insert into job_order(order_num,order_date,order_customer_id, order_remarks) values(".$_GET['id'].",NOW(),".$_POST['companyBox'].",'".$_POST['remarkBox']."');"; $res=mysql_query($sql);  $id=mysql_insert_id();   foreach($_POST as $key => $value) {          if(!empty($value)) {           $key.' => '.trim(strip_tags($value));            $order="INSERT INTO orderprod (order_num,prod_id,order_amount,teeth_amount) VALUES ('$_GET[id]','$value','$value','$value');"; $orderres=mysql_query($order) or die(mysql_error()); } }?>$sql="insert into job_order(order_num,order_date,order_customer_id,
order_remarks)
values(".$_GET['id'].",NOW(),".$_POST['companyBox'].",'".$_POST['remarkBox']."');";
$res=mysql_query($sql);

$id=mysql_insert_id();


foreach($_POST as $key => $value) {


        if(!empty($value)) { 
 
         $key.' => '.trim(strip_tags($value));  
     
         $order="INSERT INTO orderprod (order_num,prod_id,order_amount,teeth_amount) VALUES
('$_GET[id]','$value','$value','$value');";
$orderres=mysql_query($order) or die(mysql_error());
}
}
?>



=============

This is the formI have removed parts which are irrelevant. Please note that dateBox and companyBox are not required to be looping as they are only for first table,



echo "<form action=".$config_basedir."./vieworder.php?id=".$_GET['id']."  name=form1 method=post>";?><table><tr><td><h4>JOB ORDER</H4></TD><TD></TD></TR><TR><TD>ORDER NUMBER</TD><TD><?PHP ECHO $_GET['id'] ?></td></tr><tr><td>ORDER DATE</td><td><input type=text name=dateBox></td></tr> <tr><td>COMPANY NAME</td><td><?PHP$sql="select * from customers";$res=mysql_query($sql);echo "<select name=companyBox><option value=''>Please select</option>";WHILE($fetch=mysql_fetch_assoc($res)){ echo "<option value='".$fetch['id']."'>".$fetch['cust_name']."</option>";} echo "</select>"; echo "</td></tr>"; ?>   </table> <table><tr><th>ITEM</th><th>QUANTITY</th><th>N0. of Teeths</th></tr><tr><?PHP$sql="select * from products";$res=mysql_query($sql); WHILE($fetch=mysql_fetch_assoc($res)){ echo "<td><input type=text name=desBox value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td><td><input type=text name=quantBox></td><td><input type=text name=teethBox></td>";echo "</tr>";}echo "</table>";?>echo "<form action=".$config_basedir."./vieworder.php?id=".$_GET['id']."  name=form1 method=post>";
?>
<table>
<tr>
<td><h4>JOB ORDER</H4></TD><TD></TD>
</TR>
<TR>
<TD>ORDER NUMBER</TD><TD><?PHP ECHO $_GET['id'] ?></td>
</tr>
<tr>
<td>ORDER DATE</td><td><input type=text name=dateBox></td>
</tr>

<tr>
<td>COMPANY NAME</td><td>
<?PHP
$sql="select * from customers";
$res=mysql_query($sql);
echo "<select name=companyBox><option value=''>Please select</option>";
WHILE($fetch=mysql_fetch_assoc($res)){

echo "<option value='".$fetch['id']."'>".$fetch['cust_name']."</option>";}
echo "</select>";
echo "</td></tr>";
?>



</table>

<table>
<tr>
<th>ITEM</th><th>QUANTITY</th><th>N0. of Teeths</th>
</tr>
<tr>
<?PHP
$sql="select * from products";
$res=mysql_query($sql);

WHILE($fetch=mysql_fetch_assoc($res)){

echo "<td><input type=text name=desBox value='".$fetch['prod_id']."'>".$fetch['prod_name']."</td>
<td><input type=text name=quantBox></td>
<td><input type=text name=teethBox></td>";
echo "</tr>";}
echo "</table>";
?>



HERE IS THE IMAGE showing the populated services.
http://dubads.com/images/order.jpg