StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP Array insert into MySQL table as individual rows.
primarykey
Id
6886631
data
AcceptedAnswerId
6889147
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-07-30T23:43:37.757
FavoriteCount
0
LastActivityDate
2011-07-31T11:23:16.460
LastEditDate
2011-07-31T11:23:16.460
LastEditorUserId
768110
OwnerUserId
837168
ParentId
0
PostTypeId
1
Score
1
ViewCount
4507
LastEditorDisplayName
text
Body
I want to insert mutiple rows in mysql table using php. Data is in arrays and I am trying to employ following codes but its not working. Please help me. Query String is: <pre><code>new_document.php?doctype=Inv&paytype=u&docno=3&bookno=31&prname=40329&pename=1001&paydate=07%2F22%2F2011&indate=7%2F30%2F2011&accname1=Man+Site&DrAmount1=20&CrAmount1=1&accname2=Man+Site&DrAmount2=0&CrAmount2=5&ref=Jul%2F2011 </code></pre> <pre><code> $rows = explode("&", $_SERVER['QUERY_STRING']); $rowcount =((count($rows)-9)/3); // Count set of rows received , 9 is the costant no of inputs $serialno = array(); $acc_name = array(); $debit = array(); $credit = array(); $serialno [] = $i; array_unshift($serialno,""); unset($serialno[0]); $acc_name[] = ($_GET['accname'.$i]); array_unshift($acc_name,""); unset($acc_name[0]); $debit[] = ($_GET['DrAmount'.$i]); array_unshift($debit,""); unset($debit[0]); $credit[] = ($_GET['CrAmount'.$i]); array_unshift($credit,""); unset($credit[0]); echo 'Serial Numbers : '.print_r($serialno); echo ' A/C Names : '.print_r($acc_name); echo ' Debit Amount : '.print_r($debit); echo ' Credit Amount : '.print_r($credit); This gives me following result : ARRAY ( [1] => 1 [2] => 2 ) SERIAL NUMBERS : 1ARRAY ( [1] => MAN SITE [2] => MAN SITE ) A/C NAMES : 1ARRAY ( [1] => 20 [2] => 0 ) DEBIT AMOUNT : 1ARRAY ( [1] => 1 [2] => 5 ) CREDIT AMOUNT : 1 for ($i=1;$i=$rowcount;$i++) { $amount = ($debit[$i]-$credit[$i]); $accname=$acc_name[$i]; $insert2 = "INSERT INTO `khata2`.`docitems` ( `dateinput`, `docno`, `itemno`, `accountname`, `amount`, `picrefno`, `updatestamp`) VALUES ( NOW(''), '$docno', '$i', '$accname', '$amount', '$docno', Null)"; } if (!mysql_query($insert2)){ echo ' <a style="color:RED">Zero</a> items saved! Try Again.. '; die('Error: ' . mysql_error()); break; } echo ' <a style="color:GREEN">'.$rowcount.' </a>record inserted.'; exit(); RESULTS AS : Fatal error: Maximum execution time of 30 seconds exceeded in F:\server\htdocs\xampp\Khata2\processor\new_document.php on line 184 ( Line 184 is '$amount',) </code></pre>
Tags
<php><mysql><arrays><insert>
Title
PHP Array insert into MySQL table as individual rows.
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USRiaD
UserOwnerUserId
1. USuser837168
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POPHP Array insert into MySQL table as individual rows.
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.