php mysql dropdown value select -

-

currently following code displays filters individual publishers ie if select dc see dc titles.

the issue current code cannot display publishers dropdown menu.

<div id="main">   <form method="post" action="">     <div id="search_query" >      <select name="make" size="0">       <option value="all">all publishers</option>       <option value="dc">dc</option>       <option value="marvel">marvel</option>       <option value="image">image</option>     </select>      <input type="submit" name="submit" value="submit">    </div> </form> <div id="main_container">  <?php  $db_con = mysql_connect('127.0.0.1','root','root');  if (!$db_con) {    die('could not connect: ' . mysql_error());  }  mysql_select_db('work', $db_con);  if(isset($_post['submit']))  {    $make = mysql_real_escape_string($_post['make']);    $sql = sprintf("select * products publisher= '$make' ");     $result = mysql_query($sql);     echo "<table width= 970 border=1>    <tr>      <th width='120' scope='col'>title</th>      <th width='170' scope='col'>publisher</th>      <th width='185' scope='col'>price</th>      <th width='126' scope='col'>desc</th>    </tr>";    while($row = mysql_fetch_array($result))    {      echo "<tr>";      echo "<td>".$row['title']."</td>";      echo "<td>". $row['publisher'] . "</td>";      echo "<td>". $row['price'] ."</td>";      echo "<td>". $row['desc'] ."</td>";      echo "</tr>";    }    echo "</table>";  }  else  {   $sql = sprintf("select * products");   $result = mysql_query($sql);    echo "<table width= 970 border=1>   <tr>    <th width='120' scope='col'>title</th>    <th width='170' scope='col'>publisher</th>    <th width='185' scope='col'>price</th>    <th width='126' scope='col'>desc</th>  </tr>";  while($row = mysql_fetch_array($result))  {    echo "<tr>";    echo "<td>".$row['title']. "</td>";    echo "<td>". $row['publisher'] . "</td>";    echo "<td>". $row['price'] ."</td>";    echo "<td>". $row['desc'] ."</td>";    echo "</tr>";  }  echo "</table>"; }   mysql_close($db_con); ?>

in query, it's searching publisher = $make $make = "all". database table doesn't have record publisher = "make".

i'd suggest add if else condition here:

if (isset($_post['submit'])) {     $make = mysql_real_escape_string($_post['make']);     if ($make != "all") {        $sql = sprintf("select * products publisher= '$make' ");    } else {       $sql = sprintf("select * products");    }     /* other code */ }

Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more