PROBLEMS Making a Search Page PHP and MYSQL -


i'm facing issue due lack of experience.

i'm getting data mysql database , populating second dropdown menu.

the problem is... when click in "validate" submit , record data in variable cleans previous option selected. i'm being unable record selected options in variables.

<?php $location = ""; $locationf = ""; $system = ""; $systemf = "";  $conn = mysqli_connect('localhost', 'root', 'test', 'srsbase')         or die('cannot connect db');  $result = $conn->query("select distinct sub_account srsload");  if (isset($_post["selec"]["account"])) {     $location = $_post["selec"]["account"];     $locationf = $location;     $locationf = sprintf('%s', $locationf); }  echo "location: $locationf";  $conn2 = mysqli_connect('localhost', 'root', 'test', 'srsbase')         or die('cannot connect db');  $result2 = $conn2->query("select distinct systemname srsload sub_account='$locationf'");  if (isset($_post["selec"]["system"])) {     $system = $_post["selec"]["system"];     $systemf = $system; }  echo "system: $systemf";  $post_at = ""; $post_at_to_date = ""; $post_at_todate = "";  $querycondition = ""; if (!empty($_post["search"]["post_at"])) {     $post_at = $_post["search"]["post_at"];     list($fiy, $fim, $fid) = explode("-", $post_at);      $post_at_todate = date('yy-mm-dd');     if (!empty($_post["search"]["post_at_to_date"])) {         $post_at_to_date = $_post["search"]["post_at_to_date"];         list($tiy, $tim, $tid) = explode("-", $_post["search"]["post_at_to_date"]);         $post_at_todate = "$tiy-$tim-$tid";      //testing selected targets     //echo $post_at;     //echo "/";     //echo $post_at_todate;     }      //$querycondition .= "where rdate between '$fiy-$fim-$fid' , '" . $post_at_todate . "'";     $querycondition .= "where rdate between '$post_at' , '" . $post_at_todate . "'"; }  //$sql = "select * srsload " . $querycondition . " order post_at desc"; //$sql = "select * srsload rdate between '$post_at' , $post_at_todate;"  $sql = sprintf("select * srsload rdate between '%s' , '%s' , systemname='%s' , sub_account='%s'", $post_at, $post_at_todate, $systemf, $locationf);  $result3 = mysqli_query($conn, $sql); ?> <!doctype html> <html>     <head>         <title>storage report system - search</title>         <script src="jquery-1.9.1.js"></script>         <link rel="stylesheet" href="jquery-ui-1.11.4.css">          <style>             .table-content{border-top:#cccccc 4px solid; width:50%;}             .table-content th {padding:5px 20px; background: #f0f0f0;vertical-align:top;}             .table-content td {padding:5px 20px; border-bottom: #f0f0f0 1px solid;vertical-align:top;}         </style>     </head>     <body>          <h2 style='font-family:arial'>storage report system - search</h2>          <form name='sname' id='sname' action='' method='post'>             <select id='select' name="selec[account]" value="<?php echo $location; ?>" >                 <option value='-1'>--select location--</option>                  <?php                 while ($row = $result->fetch_assoc()) {                     unset($sub_acc);                     $sub_acc = $row['sub_account'];                     echo '<option value="' . $sub_acc . '">' . $sub_acc . '</option>';                 }                 ?>              </select>             <input type='submit' value='validate' />         </form>          <form name='sname' id='sname' action='' method='post' >             <select id='system' name="selec[system]" value="<?php echo $system; ?>" >                  <option value='-1'>--select system--</option>                 <?php                 while ($row2 = $result2->fetch_assoc()) {                      unset($syst);                     $syst = $row2['systemname'];                     echo '<option value="' . $syst . '">' . $syst . '</option>';                 }                 ?>             </select>             <input type='submit' value='validate' />         </form>          <div class="demo-content">             <form name="frmsearch" method="post" action="">                 <p class="search_input">                     <input type="text" placeholder="from date" id="post_at" name="search[post_at]" value="<?php echo $post_at; ?>" class="input-control" />                     <input type="text" placeholder="to date" id="post_at_to_date" name="search[post_at_to_date]" style="margin-left:10px" value="<?php echo $post_at_to_date; ?>" class="input-control" />                     <input type="submit" name="go" value="search" >                 </p>                 <?php if (!empty($result3)) { ?>                     <table class="table-content">                         <thead>                             <tr>                                 <th width="30%"><span>system name</span></th>                                 <th width="50%"><span>date</span></th>                                 <th width="20%"><span>hsm</span></th>                             </tr>                         </thead>                         <tbody>                             <?php                             while ($row3 = mysqli_fetch_array($result3)) {                                 ?>                                 <tr>                                     <td><?php echo $row["systemname"]; ?></td>                                     <td><?php echo $row["rdate"]; ?></td>                                     <td><?php echo $row["hsm_mcds"]; ?></td>                                  </tr>                                 <?php                             }                             ?>                         <tbody>                     </table>                 <?php } ?>             </form>         </div>         <script src="jquery-ui-1.10.3.js"></script>         <script>             $.datepicker.setdefaults({                 showon: "button",                 buttonimage: "datepicker.png",                 buttontext: "date picker",                 buttonimageonly: true,                 dateformat: 'yy-mm-dd'             });             $(function () {                 $("#post_at").datepicker();                 $("#post_at_to_date").datepicker();             });         </script>     </body> </html>

it because have 2 forms there. every form has own select , submit. when click submit, appropriate form select sent. when want have data both selects, have have both selects in 1 form 1 submit. code:

<form name='sname' id='sname' action='' method='post'>     <select id='select' name="selec[account]" value="<?php echo $location; ?>" >         <option value='-1'>--select location--</option>         <?php         while ($row = $result->fetch_assoc()) {             unset($sub_acc);             $sub_acc = $row['sub_account'];             echo '<option value="' . $sub_acc . '">' . $sub_acc . '</option>';         }         ?>     </select>      <select id='system' name="selec[system]" value="<?php echo $system; ?>" >         <option value='-1'>--select system--</option>         <?php         while ($row2 = $result2->fetch_assoc()) {             unset($syst);             $syst = $row2['systemname'];             echo '<option value="' . $syst . '">' . $syst . '</option>';         }         ?>     </select>     <input type='submit' value='validate' /> </form>

Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more