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

How to get the arclen between two curve points in Maya? -

in maya 2015, can arclen of curve using command: cmds.arclen('bezier1') but want arclen of 2 points in curve. there anyway this? using maya's api surely best way @scottiedoo said, here function made when didn't know api , gives same results. from maya import cmds def computecrvlength(crv, startparam = none, endparam = none): ''' compute length of curve between 2 given uparameters. if both uparameters arguments set none (default), compute length of whole curve. arguments: - crv = string; existing nurbcurve - startparam = 0 <= float <= 1 or none; default = none; point parameter value, if not none, compute points between startpt , endpt values. - endparam = 0 <= float <= 1 or none; default = none; point parameter value, if not none, compute points between startpt , endpt values. returns: - length of curve between given uparameters - length of curve start startp...
Read more

C++ Linked List -

i trying create linked list download txt file , use linked list handle file line line. when handling downloaded linked list operations performed on such text editor would. encountering problems however. seems "node(string value)" section of code has wrong though original node() declaration no arguments passes. unable figure out quite is. node.h class node { public: node(); node(string value); void setnext(node *nextnode); // allows user set "next" pointer of node points friend class linkedlist; private: string data; // data box node* next; // pointer box }; node.cpp # include <string> # include "node.h" using namespace std; node::node() { data = ""; next = null; } node::node(string value) { data = value; next = null; } void node::setnext(node *nextnode) // allows user set "next" pointer of node points { this->next = nextnode; } your #include <string> ...
Read more

git svn - Unignore directories in git-svn (adding directories to a sparse checkout) -

when using git svn, sparse checkout of central repository may achieved along lines of git clone -s url-to-root --include-paths 'dir1|dir2|dir3' after using setup time, add directory dir4 tracked. directory has existed in many commits have checked out. editing variable svn-remote.svn.include-paths running git config --edit does not have desired effect on git fetch (only files changed in future commits checked out changed; not immediately), , following not check out dir4: git svn fetch --include-paths dir4 i think following work ineffective due refetching revisions since first revision @ dir4 appeared first time (let's call rev): git svn reset -r rev git svn fetch --include-paths dir4 git svn rebase what better way of tracking dir4? if not care history of dir4? is there better way initial sparse checkout git-svn if suspect want change list of tracked directories later? have tried starting listing directoreis not fetched in original commit, not know how...
Read more