PHP - Select sql from html checkbox -


i have html form, checkbox. my form 4 checkbox

i want write sql include checkbox.

for example on database:
column: stato
options: 0,1,2,3
where:

  • 0 = aperto,
  • 1 = stampato,
  • 2 = bloccato,
  • 3 = ❤ (favorite),

so, if selected must show me kinds, otherwise not.

how can write sql?

this checkbox:

<div id="radioset">         <input type="checkbox" id="radio1" name="aperto" checked="checked"><label for="radio1">aperto</label>         <input type="checkbox" id="radio2" name="stampato" checked="checked"><label for="radio2">stampato</label>         <input type="checkbox" id="radio3" name="bloccato" checked="checked"><label for="radio3">bloccato</label>         <input type="checkbox" id="radio4" name="favorite" checked="checked"><label for="radio4">&#9829</label> </div>

and php sql:

$input=$_post['input']; $id=$_post['id']; $tipo=$_post['tipo']; $numero1=$_post['numero1']; $numero2=$_post['numero2']; $data1=date('d/m/y', strtotime($_post['from']));; $data2=date('d/m/y', strtotime($_post['to']));;  $sql="select [id ord] [id], [tipo ord] [tipo], [n ord] [numero], [data ord] [data], [ragione sociale], [indirizzo], [totimp] [importo totale], [totiva] [importo iva] [ordini] [id ord] '$id' or [tipo ord] '$tipo' or [data ord] between #$data1# , #$data2#";  $rs = $con->execute($sql);

thanks!

firstly, define checkboxes array (don't use terminology "radio" - radio buttons quite different!), , change values match database records:

<div id="checkboxes">   <input type="checkbox" id="checkbox1" name="options[]" value="0" checked="checked"><label for="checkbox1">aperto</label>   <input type="checkbox" id="checkbox2" name="options[]" value="1" checked="checked"><label for="checkbox2">stampato</label>   <input type="checkbox" id="checkbox3" name="options[]" value="2" checked="checked"><label for="checkbox3">bloccato</label>   <input type="checkbox" id="checkbox4" name="options[]" value="3" checked="checked"><label for="checkbox4">&#9829</label> </div>

then can use each loop loop through them, , if option present (checkboxes values don't exist in postback if box wasn't checked) add bit of sql include option in search:

$optionssql = "";  foreach($_post["options"] $index => $option) {   if ($optionssql == "") $optionssql = "and stato in ("; //if it's first detected option, add in clause string   $optionssql .= $option.","; }  //trim trailing comma , add closing bracket of in clause instead if ($optionssql != "")  {   $optionssql = rtrim($optionssql, ",");    $optionssql .= ")"; }

then lastly, append $optionssql string query:

$sql="select [id ord] [id], [tipo ord] [tipo], [n ord] [numero], [data ord] [data], [ragione sociale], [indirizzo], [totimp] [importo totale], [totiva] [importo iva] [ordini] ([id ord] '$id' or [tipo ord] '$tipo' or ([data ord] between #$data1# , #$data2#))".$optionssql;

n.b. since quick example have not taken steps here guard against sql injection. should how guard against - malicious user tamper option values , try submit problematic data. should validate each option value before use in sql statement.


Comments

Post a Comment

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

actually have store importing products store product data insert , update image or image url not insert , update. this xml code name datapro.txt. <products_joined> <productcode>3710_012t</productcode> <vendor_partno>eah5450silent/di/1gd3(lp)</vendor_partno> <productname>test product ta</productname> <hideproduct>n</hideproduct> <stockstatus>20</stockstatus> <lastmodified>1/5/2016 10:25:00 am</lastmodified> <lastmodby>2</lastmodby> <productweight>0.9</productweight> <productprice>100</productprice> <productmanufacturer>asus tek</productmanufacturer> <vendor_price>32.69</vendor_price> <numproductssharingstock>0</numproductssharingstock> <categoryids>107</categoryids> <producturl>http://tebkq.mvlce.servertrust.com/productdetails.asp?productcode=3710_012t</producturl...
Read more

Laravel mail error `Swift_TransportException in StreamBuffer.php line 269: Connection could not be established with host smtp.gmail.com [ #0]` -

i developing website contact-us page guest users can send me email using gmail . anytime try send mail using contact-us form, error swift_transportexception in streambuffer.php line 269: connection not established host smtp.gmail.com [ #0] this mail.php return [ 'driver' => env('mail_driver', 'smtp'), 'host' => env('mail_host', 'smtp.gmail.com'), 'port' => 587, 'from' => ['address' => '', 'name' => ''], 'encryption' => env('mail_encryption', 'tls'), 'username' => env('mail_username'), 'password' => env(mail_password), 'sendmail' => '/usr/sbin/sendmail -bs', 'pretend' => env('mail_pretend', false), ]; this .env mail_driver=smtp mail_host=smtp.gmail.com mail_port=587 mail_username=afecjaped@gmail.com mail_password=********...
Read more

c# SetCompatibleTextRenderingDefault must be called before the first -

i tried search exception couldn't find solution on case i'am using code below invoke .net application : assembly assem = assembly.load(data); methodinfo method = assem.entrypoint; var o = activator.createinstance(method.declaringtype); method.invoke(o, null); the application invoked has form , in entrypoint of application : [stathread] static void main() { application.enablevisualstyles(); application.setcompatibletextrenderingdefault(false); //exception application.run(new form1()); } setcompatibletextrenderingdefault must called before first iwin32window object created in application. edit : assembly = assembly.load(data); methodinfo method = a.gettype().getmethod("start"); var o = activator.createinstance(method.declaringtype); method.invoke(o, null); you should create new method skips initialization...
Read more