[RESOLVED] Save auto generated rows and data

[maxat]

Hi everybody,

I have a problem with function

I want to store orders of each company in the database. But each company has different number of items in the order list.
There is a HTML table with user defined number of rows and with text fields inside the row based on number of items. After rows are generated name of each text field remaining the same.

How can I add each row and text field data into my MySql database under the same order number? Because there might be 1 row or 100 rows.
Do you have any idea how to solve this problem?

Thanks in Advance

[Krik]

Make each row in the table a row in the database and just put the order number with each row in the database. And when you need to recall that customers order it can retrieve all rows that have the order number.

[maxat]

Thanks,
I got it, but how to do it? How to save in database, cause I have the same text field names.

Thanks

[djjjozsi]

The problem is if these html files are static contents,
and the textfields haven't got a variable name which determine an identify for that company.

but how to do it? How to save in database, cause I have the same text field names.

Lets create the textfields dynamically:

<input type="text" name="order[1233][]">

where 1233 is the primary key of the Companies table.

And when you process the form , you will know which order comes to which company.
And here comes another important issue is to design them to allow many to one relation.
Where the one is the company(table), and the orders(table) is the many.

Hello, jjozsi.

[maxat]

I think you did not understand me. My problem is how to send multiple auto generated text fields to database. I need SQL statement that will send them all one by one. Lets say user wanted to have 7 rows, in each row we will have 7 text fields. I can put text field name in array so it will be named as "name1" to "name7", the problem is how to send them one by one to database, what is the SQL statement if there will be 5 rows, 7 rows, 20 rows?

Thanks in advance.

[djjjozsi]

If you have an order table:
orders(orders_id , company_id (FK) , order, order_date_time , session_id)

Then you have a company table,
company (c_id, Company_name)

You have a table, order_definition:
definition_id (PK)
company_id (FK)
number_of_orders ----- how many order textfields needed

You have the "number_of_orders" the orders number, for example 6 ...
$number_of_orders=6;
You have a "definition_id" , for example: 112

create the textfields like this:

for($i=0; $i<$number_of_orders, $i++)
{
print ("<input type=\"text\" name=\"order{$definition_id}[$i]\"> \r" ); 
}

Now, store the definition_id into a hidden form, or a session... I store it in a hidden for example:

print "<input type=\"hidden\" name=\"def_id\" value=\"$definition_id\"> <br /> \r";

On the process page, select how many orders you expect using the previously stored definition_ID value, like:

$def_id=(int)$_POST["def_id"];  //this is the hidden field value
$sql="SELECT
  order_definition.definition_id, order_definition.company_id, order_definition.number_of_orders
FROM
  test4.order_definition
WHERE
  order_definition.definition_id = '$def_id' ";

use the mysql fetch_assoc to get these value.

If that definition ID is exists in the database,

use a foreach cycle to get the values, like this:

$i=1;
foreach($_POST["order".$def_id] AS $row)
{

print ("Order :" . htmlspecialchars($row)    );   /*  Just for test*/
$sql= sprintf("INSERT INTO orders(definition_id , order , session_id) VALUES (%d , %s , %s)" , $def_id , mysql_real_escape_string($row)  , session_id()   );
print $sql; // JUST FOR TEST...
mysql_query($sql)  or  $error[]="Error with the $i. order of $def_id definition  :  ". htmlspecialchars($row)." - from: " . session_id() ;
$i++;
}

if(isset($error))
{

foreach ($error AS $rows)
{

/*mail_to_the_adminl($rows);*/

print $rows . "<br />";
}

}

And how to list the orders joining with the company, orders , and orders_definition table?
Click here to see:
http://phptool.extra.hu/orders.jpg

SELECT
  `company`.`c_id` AS `c_id`, `company`.`Company_name` AS `Company_name`, `orders`.`orders_id` AS `orders_id`, `orders`.`order` AS `order`, `orders`.`order_date_time` AS `order_date_time`
FROM
  ((`company` JOIN `orders`) JOIN `order_definition` ON ((`order_definition`.`company_id` = `company`.`c_id`)))
ORDER BY
  `company`.`Company_name`, `orders`.`order_date_time` DESC

[maxat]

Thanks a ton man. You really helped me.

[djjjozsi]

Your Welcome,
I found a little part where i talked about the process program:

FROM
test4.order_definition

test4. is not necessary to take into the query, you can leave it.

And don't dorget to set this thread as resolved, if you think you finished with this project 🙂

Hello, jjozsi.