Hello everyone,
I´m newbie in PHP and I can´t solve following problem.
My code contains form of unknown number of rows. I add it using jQuery class ( clone the last row ).
I wanted to use array. Write out complete form for confirmation and insert it i. e. as 'order' into Mysql.
My problems are:
1) I can´t write it out correctly. There is list of two form rows:
( Item:1
Type: Acoustic
Model:
Quantity:
Item:2
Type:
Model:
Standard
Quantity:
Item:3
Type:
Model:
Quantity: 8
Item:4
Type: Acoustic
Model:
Quantity:
Item:5
Type:
Model: Standard
Quantity:
Item:6
Type:
Model:
Quantity: 1
Comments:
Hello, folks)
I suspect that the problem is in the variable $i, but I have no idea how to define it if I don´t know number of rows.
2) How can I insert it into Mysql
Please help. Thanks a lot. Petr
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" type="text/css" media="scReen" href="css/style.css"/> <script case="javascript" type="text/javascript" src="js/jquery.js"></script> <script type="text/javascript" src="js/jquery.table.addrow.js"></script> <script type="text/javascript"> (function($){ $(document).ready(function(){ $(".addRow").btnAddRow(); $(".delRow").btnDelRow(); }); })(jQuery); </script> </head> <body> <?php echo "<font color='#CC3300' size='5'>Order</font><br /><br />"; echo"<form method='POST' action='#'>"; echo"<table cellspacing='0' style='border: #DDDDDD 1px solid;'> <tr><td><input type='button' class='delRow' value='Delete Row'/></td> <td><div><select name='case[$i][typ]' style='width:200px;'> <option value='Acoustic'>Acoustic</option> <option value='Electric'>Electric</option> <option value='Jazz'>Jazz</option> </select> </td> <td><select name='case[$i][mod]' style='width:180px;'> <option value='Standard'>Standard</option> <option value='Luxury'>Luxury</option> <option value='Professional'>Professional</option> </select></div></td> <td><div><input type='text' name='case[$i][poc]' size='2' value=''></div></td> </tr> <tr><td colspan='3' align='right'> <input type='button' class='addRow' name='add' value='Add Row'/></td></tr> <tr><td>Comments: </td></tr> <tr><td colspan='5'><textarea name='comment' cols='53' rows='3'></textarea></td><tr> <tr><td colspan='5' align='center'><input type='submit' name='send' value='Send'></td></tr>"; echo"</table>"; echo"</form>"; ?> <?php if(isset($_POST['send'])) { $case = $_POST['case']; $n = count($case); $i = 0; $c = $_POST['comment']; echo "Your select: \r\n" . "<ol>"; for ($i = 0; $i < $n; $i++) { echo "<b>Item:</b>" .($i+1); echo "<li><b>Type:</b> {$case[$i]['typ']}</li> \r\n"; echo "<li><b>Model:</b> {$case[$i]['mod']}</li> \r\n"; echo "<li><b>Quantity:</b> {$case[$i]['poc']}</li> \r\n"; } echo "<li><b>Comments:</b> </li>". $c; echo "</ol>"; } ?> </body> </html>I´m sorry, I forgot jQuery code.
/* * * Copyright (c) 2009 C. F., Wong (<a href="http://cloudgen.w0ng.hk">Cloudgen Examplet Store</a>) * Licensed under the MIT License: * http://www.opensource.org/licenses/mit-license.php * * See details in: <a href="http://cloudgen.w0ng.hk/javascript/javascript.php">Javascript Examplet</a> * */ (function($){ var ExpandableTableList=[]; function ExpandableTable(target,maxRow){ if(target) this.init(target,maxRow); } ExpandableTable.prototype.init=function(target,maxRow){ ExpandableTableList.push(this); this.target=$(target).data("ExpandableTable",this); this.maxRow=maxRow; this.seed=Math.round(Math.random()*10000); return this }; ExpandableTable.prototype.live=function(){ if (!this.goLive){ var t=this; $(".addRow"+this.seed).live("click",function(){ t.addRow().update(); }); $(".delRow"+this.seed).live("click",function(){ $(this).closest("tr").remove(); t.update(); }); this.update(); this.goLive=true; } return this }; ExpandableTable.prototype.update=function(){ this.delRowButtons=$(".delRow"+this.seed,this.target); if(this.delRowButtons.size()==1) this.delRowButtons.hide(); else this.delRowButtons.show(); return this }; ExpandableTable.prototype.addRow=function(){ if(!this.maxRow || (this.maxRow && $(".delRow"+this.seed).size()<this.maxRow)){ this.delRowButtons.show(); var lastRow=$(".delRow"+this.seed+":last",this.target).closest("tr"); var newRow=lastRow.clone() .insertAfter(lastRow) .find("input:text").val(""); } return this }; $.fn.btnAddRow=function(options){ var maxrow=(options && typeof options.maxRow!="undefined")?options.maxRow:null; this.each(function(){ var tbl=$(this).closest("table"); if(tbl.size()>0){ if(typeof tbl.data("ExpandableTable")==="undefined"){ var etbl=new ExpandableTable(tbl,maxrow); $(this) .addClass("addRow"+etbl.seed) .data("ExpandableTable",etbl); }else{ $(this) .addClass("addRow"+tbl.data("ExpandableTable").seed) .data("ExpandableTable",tbl.data("ExpandableTable")); } }; }); for(var i=0;i<ExpandableTableList.length;i++){ if(!ExpandableTableList[i].goLive){ ExpandableTableList[i].live(); } } }; $.fn.btnDelRow=function(options){ var maxrow=(options && typeof options.maxRow!="undefined")?options.maxRow:null; this.each(function(){ var tbl=$(this).hide().closest("table"); if(tbl.size()>0){ if(typeof tbl.data("ExpandableTable")==="undefined"){ var etbl=new ExpandableTable(tbl,maxrow); $(this) .addClass("delRow"+etbl.seed); }else{ $(this) .addClass("delRow"+tbl.data("ExpandableTable").seed) } } }); for(var i=0;i<ExpandableTableList.length;i++){ if(!ExpandableTableList[i].goLive){ ExpandableTableList[i].live(); } } }; })(jQuery);
