php - Syntax error with mysql when trying to fetch data from database using options in drop down list -

-

when select option retrieve data db, error message:

you have error in sql syntax; check manual corresponds mysql server version right syntax use near '' @ line 1.

why that? there's nothing @ line 1? also, teach me how search in retrieved data?

example. if choose option 1 "antal narvaro" , press ok-button, following sql-query execute: select * mytable fran = 'besok';

once i've retrieved data, want further search in information name, age , on. otherwise i'm grateful execute following sql-queries choosing option in drop down list press ok-button.

i'm new php , html, in advance!

<html>     <head>          <title>aifind</title>         <link rel="stylesheet" href="style.css">         <script type="text/javascript" src="logic.js"></script>       </head>     <body>         <h1><img src="https://imagizer.imageshack.us/v2/278x186q90/844/k32d.png"                   height="70" width="100" alt="aifind-logo copy"></h1>     </body>  </html>   <?php  include "connection.php";  $sql = "select";  if (isset($_post['search'])) {      $search_term = mysql_real_escape_string($_post['search_box']);      switch($_post['filter']) {          default:              $sql .= " ";             break;         case 1:             $sql .= " * mytable fran = 'besök'; ";             break;         case 2:             $sql .= " * mytable fran = 'bok'; ";             break;         case 3:             $sql .= " postort, count(*) mytable aaa_diam != ";             $sql .= " 'missing' group postort; ";             break;         case 4:             $sql .= " *, count(*) mytable aaa_diam = 'missing'";             $sql .= " group postort";             break;         case 5:             $sql .= " count(*) antal_over_30 mytable ";             $sql .= " aaa_diam > 30 , aaa_diam != 'missing' , ";             $sql .= " aaa_diam != 'n.a' , aaa_diam != 'missing'";             break;         case 6:             $sql .= " count(*) antal_over_30 mytable ";             $sql .= " aaa_diam > 50 , aaa_diam != 'missing' , ";             $sql .= " aaa_diam != 'n.a' , aaa_diam != 'missing'";             break;         case 7:             $sql .=  "";             break;      }  }   $query = mysql_query($sql) or die(mysql_error());   ?>   <!--sökrutan där sökord matas in --> <form name="select_filter" method="post" action="vgr_data_display.php">      <select id="dropdown" name="filter">         <option value=""></option>         <option value="1">antal narvaro</option>         <option value="2">antal franvaro</option>         <option value="3">antal narvaro: destination</option>         <option value="4">antal franvaro: destination</option>         <option value="5">antal a_diam > 3cm</option>         <option value="6">antal a_diam > 5cm</option>         <option value="7">antal franvaro: procent</option>      </select>      <!--search bar search term input -->     <input id="search_box" type="text" name="search_box" value="" />     <input id="submit" type ="submit" name ="search" value ="ok">  </form>  <table style="margin:auto;" id="table" border='1'> <tr> <th>id</th> <th>f_ar</th> <th>postnr</th> <th>postort</th> <th>vardgivare</th> <th>team</th> <th>orsak</th> <th>planerat_datum</th> <th>fran</th> <th>aaa_diam</th> </tr>   <?php while($row = mysql_fetch_array($query)) { ?>   <tr>   <td><?php echo $row['id']; ?></td>   <td><?php echo $row['f_ar']; ?></td>   <td><?php echo $row['postnr']; ?></td>   <td><?php echo $row['postort']; ?></td>   <td><?php echo $row['vardgivare']; ?></td>   <td><?php echo $row['team']; ?></td>   <td><?php echo $row['orsak']; ?></td>   <td><?php echo $row['planerat_datum']; ?></td>   <td><?php echo $row['fran']; ?></td>   <td><?php echo $row['aaa_diam']; ?></td>   </tr>  <?php } ?>


Comments

Post a Comment

Popular posts from this blog

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

-
i read alot other solution still confused should mine... #include <opencv2/objdetect/objdetect.hpp> #include <opencv2/highgui/highgui.hpp> #include <opencv2/imgproc/imgproc.hpp> #include <iostream> #include <stdio.h> using namespace std; using namespace cv; int main(int argc, const char** argv) { //create cascade classifier object used face detection cascadeclassifier face_cascade; //use haarcascade_frontalface_alt.xml library face_cascade.load("haarcascade_frontalface_alt.xml"); //setup video capture device , link first capture device videocapture capturedevice; capturedevice.open(0); //setup image files used in capture process mat captureframe; mat grayscaleframe; //create window present results namedwindow("outputcapture", 1); //create loop capture , find faces while (true) { //capture new image frame capturedevice >> captureframe; ...
Read more

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

The canvas has been tainted by cross-origin data in chrome only -

-
uncaught securityerror: failed execute 'getimagedata' on 'canvasrenderingcontext2d': canvas has been tainted cross-origin data i getting above error in chrome. code(following) works fine in mozilla. have not corss domain issue. why above error in chrome? var wheel_canvas, wheel_context, can_w, can_h, wheel_grd; var large_radius = 160; var small_radius = 120; var wheel_canvas = document.getelementbyid('wheel_canvas'); var wheel_context = wheel_canvas.getcontext('2d'); var can_w = $(wheel_canvas).width(); var can_h = $(wheel_canvas).height(); var centerx = can_w / 2, centery = can_h / 2; var wheel_grd = null; test('#ff0000'); function test(hex) { $('#clrpicker').css({'left': 210, 'top': 210 }); inverted = hexbw(hex); $('#color_val_show').val(hex); current_color_hex_val_selected = hex; $('#color_val_show').css({'color':inverted,'background':hex}); fillgradient...
Read more