Forms with php

[Dynoserv]

hello php builder peeps,
what i am tring to do is pull all the info in from a database and then have a check box beside each one, to allow me to beable to
take the ones that have the check box beside it and submit it to another database.

The one datavase shows the cdorder has been order,
and when you put a check box beside it, and click submit it will take those file from one database and move it to another database. and the it will delete the one that has been check from the first database .

here is the code i have now on pulling it from the one database

<?php 
$conn = mysql_connect("localhost", "xxxxx", "xxxxxxx"); 
mysql_select_db("cdorder", $conn); 
$sql = "SELECT * FROM cd_order ";

$res = mysql_query($sql); 
if(mysql_num_rows($res)>0) { 
   /* If we have rows, build the table header */ 
   echo "<table border=\"1\"> 
           <tr> 
             <th align=\"center\">Client ID</th> 
             <th align=\"center\">First Name</th>
			 <th align=\"center\">Last Name</th> 
             <th align=\"center\">Address</th> 
			 <th align=\"center\">Apartment</th>
             <th align=\"center\">City</th> 
             <th align=\"center\">State</th> 
             <th align=\"center\">Zip</th> 
			 <th align=\"center\">Phone Number</th>
			 <th align=\"center\">Quantity</th>
			 <th align=\"center\">Tech</th>
			 <th align=\"center\">Date    </th>
			 <th align=\"center\">Notes</th>
			 <th align=\"center\">FTD Members Number</th>
			 <th align=\"center\">FTD Companys Name</th>
           </tr>"; 
   while($row=mysql_fetch_array($res)) { 
      echo "<tr> 
              <td>".$row['Client_ID']."</td> 
              <td>".$row['First_Name']."</td>
			  <td>".$row['Last_Name']."</td> 
              <td>".$row['Address']."</td> 
			  <td>".$row['Apartment']."</td>
              <td>".$row['City']."</td> 
              <td>".$row['State']."</td> 
              <td>".$row['Zip_Code']."</td> 
			  <td>".$row['Phone_Number']."</td>
			  <td>".$row['Quantity']."</td>
			  <td>".$row['Tech']."</td>
			  <td>".$row['todaydatetime']."</td>
			  <td>".$row['Notes']."</td>
			  <td>".$row['FTD_Members_Number']."</td>
			  <td>".$row['FTD_Companys_Name']."</td>

        </tr>"; 
   } 
   echo "</table>"; 
} 
else { 
   echo "No rows found"; 
} 
?>

And then print the ones that have been checked while it submits to the other database or something... gosh i cant wait until i ge to know this stuff.

can someone help me with this, or show me what i need to do ???
Thanks Michael

[LordShryku]

Is it going to another database or just another table?

[Dynoserv]

Hello,

Same database, differ table

Thanks michael

[Dynoserv]

It will be in the same cdorder database, but under the table called cd_order_sent

Michael

[LordShryku]

Ok, here's an idea. You'll probably need to fuss with it a bit to get it going for ya

<?php 
$conn = mysql_connect("localhost", "xxxxx", "xxxxxxx"); 
mysql_select_db("cdorder", $conn); 
$sql = "SELECT * FROM cd_order ";

$res = mysql_query($sql); 
if(mysql_num_rows($res)>0) { 
   /* If we have rows, build the table header */ 
   echo "<form name=\"blah\" action=\"page2.php\" method=\"post\">
         <table border=\"1\">
           <tr>
             <th align=\"center\">Delete</th>
             <th align=\"center\">Client ID</th>
             <th align=\"center\">First Name</th>
             <th align=\"center\">Last Name</th>
             <th align=\"center\">Address</th>
             <th align=\"center\">Apartment</th>
             <th align=\"center\">City</th>
             <th align=\"center\">State</th>
             <th align=\"center\">Zip</th>
             <th align=\"center\">Phone Number</th>
             <th align=\"center\">Quantity</th>
             <th align=\"center\">Tech</th>
             <th align=\"center\">Date    </th>
             <th align=\"center\">Notes</th>
             <th align=\"center\">FTD Members Number</th>
             <th align=\"center\">FTD Companys Name</th>
           </tr>"; 
   while($row=mysql_fetch_array($res)) { 
      echo "<tr>
              <td><input type="checkbox" name="deleteThese[]" value=".$row['Client_ID']."></td>
              <td>".$row['Client_ID']."</td>
              <td>".$row['First_Name']."</td>
              <td>".$row['Last_Name']."</td>
              <td>".$row['Address']."</td>
              <td>".$row['Apartment']."</td>
              <td>".$row['City']."</td>
              <td>".$row['State']."</td>
              <td>".$row['Zip_Code']."</td>
              <td>".$row['Phone_Number']."</td>
              <td>".$row['Quantity']."</td>
              <td>".$row['Tech']."</td>
              <td>".$row['todaydatetime']."</td>
              <td>".$row['Notes']."</td>
              <td>".$row['FTD_Members_Number']."</td>
              <td>".$row['FTD_Companys_Name']."</td>

        </tr>"; 
   } 
   echo "</table>"; 
} 
else { 
   echo "No rows found"; 
} 
?> 

So on the next page, you should have an array of Client ID's to delete

<?php
/* page2.php, insert into other table, delete the entries */
$conn = mysql_connect("localhost", "xxxxx", "xxxxxxx"); 
$db   = mysql_select_db("cdorder", $conn); 
$clients = implode("', '", $_POST['deleteThese']);
$sql = "INSERT INTO cd_order_sent 
        SELECT * 
        FROM cd_order 
        WHERE Client_ID IN ('".$clients."')";
if(mysql_query($sql)) {
   mysql_query("DELETE FROM cd_order WHERE Client_ID IN ('".$clients."')";
}
else {
   die(mysql_error()."<br /><br />".$sql);
}

[Dynoserv]

That looks like it would work,

but i get a error on the first page :
Parse error: parse error, expecting ','' or';'' in /home/httpd/vhosts/xxxx.xxx.xxx/httpdocs/tables.php on line 40

Its on the line with the checkout ...

I looked all though that line and i didnt see where, but which i am a newbie, so i dont know SHRUGS

Thanks for all of your help also

Cheers
Michael

[pjleonhardt]

can u post that line along with 2 or 3 above and below it?

[Dynoserv]

Hello,

Yes here it is...

 <th align=\"center\">FTD Companys Name</th> 
           </tr>";  

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

      echo "<tr> 
--This Line------>            <td><input type="checkbox" name="deleteThese[]" value=".$row['Client_ID']."></td> 
              <td>".$row['Client_ID']."</td> 
              <td>".$row['First_Name']."</td> 

Thanks Michael

[LordShryku]

My bad. I usually seperate my HTML from my PHP, so change

input type="checkbox" name="deleteThese[]" value=".$row['Client_ID'].">

// to this

input type=\"checkbox\" name=\"deleteThese[]\" value=\"".$row['Client_ID']."\">

[edit] It doesn't show the first one, but it should be input type=\"checkbox\". You need to add a \ beore and double quotes used in HTML that is echoed from the PHP.

[Dynoserv]

Hello LordShryku,

Thank you again for all your help,
I found that right before your last edit.

I added my input button and my </form> and i check a box, but it doesnt seem to submit.

I view the source( html ) and it showed the start form and end form.

I hate to be sooo stupied, i have even read and went though a few courses on this.

But i just cant get this down, ima have send you a gift certificate
to somewhere for all your hard work.

Thanks again michael

[Dynoserv]

okay, i got that fixed,

Now when it submits to the next page Error:
Parse error: parse error in /home/httpd/vhosts/xxx.xxx.xxx/httpdocs/tables2.php on line 19

<?php 
/* page2.php, insert into other table, delete the entries */ 
$conn = mysql_connect("localhost", "xxxx", "xxxxx");  

$db   = mysql_select_db("cdorder", $conn);  

$clients = implode("', '", $_POST['deleteThese']); 
$sql = "INSERT INTO cd_order_sent 
        SELECT * 
        FROM cd_order 
        WHERE Client_ID IN ('".$clients."')"; 
if(mysql_query($sql)) { 
----LINE 19 -->   mysql_query("DELETE FROM cd_order WHERE Client_ID IN ('".$clients."')"; 
} 
else { 
   die(mysql_error()."<br /><br />".$sql); 
} 
?> 

[Dynoserv]

okay,
i got that fixed with a simple )

now i get
Column count doesn't match value count at row 1

INSERT INTO cd_order_sent SELECT * FROM cd_order WHERE Client_ID IN ('Mfire', 'Enter Information')

[Dynoserv]

let me show you the database i have

cd_order :

#

Table structure for table cd_order

#

Creation: Nov 19, 2003 at 12:19 PM

Last update: Nov 19, 2003 at 10:36 PM

#

CREATE TABLE cd_order (
id tinyint(4) NOT NULL default '0',
Client_ID varchar(30) NOT NULL default '',
First_Name varchar(30) NOT NULL default '',
Last_Name varchar(30) NOT NULL default '',
Address varchar(100) NOT NULL default '',
Apartment varchar(25) NOT NULL default '',
City varchar(50) NOT NULL default '',
State varchar(20) NOT NULL default '',
Zip_code varchar(20) NOT NULL default '',
Phone_Number varchar(25) NOT NULL default '',
Quantity varchar(10) NOT NULL default '',
Tech varchar(25) NOT NULL default '',
Notes varchar(255) NOT NULL default '',
FTD_Members_Number varchar(255) NOT NULL default '',
FTD_Companys_Name varchar(255) NOT NULL default ''
) TYPE=MyISAM;

#

Dumping data for table cd_order

#

INSERT INTO cd_order VALUES (1, 'Talk America', '14141', '2424', '159 Vet dr', '109', 'Bronx', 'AZ', '90210', '256-256-2566', '5', 'michael', '', '', '');
INSERT INTO cd_order VALUES (2, 'Talk America', 'john', 'homes', '159 Vet dr', '109', 'Bronx', 'AZ', '90210', '256-256-2566', '5', 'michael', '', '', '');

cd_order_sent :

#

Table structure for table cd_order_sent

#

Creation: Nov 19, 2003 at 12:19 PM

Last update: Nov 19, 2003 at 10:36 PM

#

CREATE TABLE cd_order_sent (
id tinyint(4) NOT NULL default '0',
Client_ID varchar(30) NOT NULL default '',
First_Name varchar(30) NOT NULL default '',
Last_Name varchar(30) NOT NULL default '',
Address varchar(100) NOT NULL default '',
Apartment varchar(25) NOT NULL default '',
City varchar(50) NOT NULL default '',
State varchar(20) NOT NULL default '',
Zip_code varchar(20) NOT NULL default '',
Phone_Number varchar(25) NOT NULL default '',
Quantity varchar(10) NOT NULL default '',
Tech varchar(25) NOT NULL default '',
Notes varchar(255) NOT NULL default '',
FTD_Members_Number varchar(255) NOT NULL default '',
FTD_Companys_Name varchar(255) NOT NULL default ''
) TYPE=MyISAM;cd_order: cd_order:

[Dynoserv]

Originally posted by Dynoserv
let me show you the database i have

cd_order :



#

Table structure for table cd_order

#

Creation: Nov 19, 2003 at 12:19 PM

Last update: Nov 19, 2003 at 10:36 PM

#

CREATE TABLE cd_order (
id tinyint(4) NOT NULL default '0',
Client_ID varchar(30) NOT NULL default '',
First_Name varchar(30) NOT NULL default '',
Last_Name varchar(30) NOT NULL default '',
Address varchar(100) NOT NULL default '',
Apartment varchar(25) NOT NULL default '',
City varchar(50) NOT NULL default '',
State varchar(20) NOT NULL default '',
Zip_code varchar(20) NOT NULL default '',
Phone_Number varchar(25) NOT NULL default '',
Quantity varchar(10) NOT NULL default '',
Tech varchar(25) NOT NULL default '',
Notes varchar(255) NOT NULL default '',
FTD_Members_Number varchar(255) NOT NULL default '',
FTD_Companys_Name varchar(255) NOT NULL default ''
) TYPE=MyISAM;

#

Dumping data for table cd_order

#

INSERT INTO cd_order VALUES (1, 'Talk America', '14141', '2424', '159 Vet dr', '109', 'Bronx', 'AZ', '90210', '256-256-2566', '5', 'michael', '', '', '');
INSERT INTO cd_order VALUES (2, 'Talk America', 'john', 'homes', '159 Vet dr', '109', 'Bronx', 'AZ', '90210', '256-256-2566', '5', 'michael', '', '', '');


cd_order_sent :

#

Table structure for table cd_order_sent

#

Creation: Nov 19, 2003 at 12:19 PM

Last update: Nov 19, 2003 at 10:36 PM

#

CREATE TABLE cd_order_sent (
id tinyint(4) NOT NULL default '0',
Client_ID varchar(30) NOT NULL default '',
First_Name varchar(30) NOT NULL default '',
Last_Name varchar(30) NOT NULL default '',
Address varchar(100) NOT NULL default '',
Apartment varchar(25) NOT NULL default '',
City varchar(50) NOT NULL default '',
State varchar(20) NOT NULL default '',
Zip_code varchar(20) NOT NULL default '',
Phone_Number varchar(25) NOT NULL default '',
Quantity varchar(10) NOT NULL default '',
Tech varchar(25) NOT NULL default '',
Notes varchar(255) NOT NULL default '',
FTD_Members_Number varchar(255) NOT NULL default '',
FTD_Companys_Name varchar(255) NOT NULL default ''
) TYPE=MyISAM

[Dynoserv]

can we delete by order id ??

it doesnt matter how it gets deleted,

but its all under one database but two differ perfixes as you can see cd_order and cd_order_sent

[Dynoserv]

Any one ??

Please Help me....

Cheers

[LordShryku]

The error is when you happening during the insert query, saying that you're number of values doesn't match the number of columns in the table. Are there any other extra columns in the new table that are causing this? Or are the two tables identical?

[Dynoserv]

You was correct, i got that fixed,

Now one last thing,

How when i check them and it goes into the other database to a print the ones that i have checked, not the ones already in the database.

To when i check it and i hit submit it prints those ???

Cheers
Michael