PHP form with MYSQL only posts what I put in. Not the search result -

-

ok i'm frustrated. cant figure out did wrong. i'm new php , mysql. ok i've got database set up. tables set too. i'm having difficult time php though.
have 15 fields want search. on test run php keeps posting put in box. if put in "seth" posts "seth". that's nothing database. put 1 field in php test it.
put code in here. curly braces in right places. had trouble indenting on site.

the first 1 php.func.inc.

<?php include 'db.inc.php';  function search_results($keywords) {     $returned_results = array();     $where = "";      $keywords = preg_split('/[\s]+/', $keywords);     $total_keywords = count($keywords);      foreach ($keywords $key => $keyword) {         $where .= " 'keywords' '%$keyword%' ";         if ($key != ($total_keywords - 1)) {             $where .= " and";         }     }     $results = "select 'investigator', 'projecttitle', 'institution' 'studies'          where";     $results_num = $results = mysql_query($results) ? mysql_num_rows($results) : 0;     if ($results_num === 0) {          return false;     } else {         while ($results_row = mysql_fetch_assoc($results)) {             echo $results_row['othernotes'];         }     } } ?>

the next index.php. left out file connect database. 

<?php include 'func.inc.php'; ?>  <!doctype html> <html> <head> </head> <body> <h2> search </h2>  <form action="" method="post">     <p>         <input type="text" name="keywords"/> <input type="submit"                                                     value="search"/>     </p> </form> <?php if (isset($_post['keywords'])) {     $keywords = mysql_real_escape_string(htmlentities(trim($_post['keywords'])));     echo $keywords;     $errors = array();      if (empty($keywords)) {         $errors[] = "please enter search term";     } else if (strlen($keywords) < 3) {         $errors[] = "your search term must 3 or more character";     } else if (search_results($keywords === false)) {         $errors[] = 'your search ' . $keywords . 'returned no results';     }     if (empty($errors)) {         search_results($keywords);     } else {         foreach ($errors $error) {             echo $error;         }     } }?> </body> <html>

one thing notice putting single quotes around table , column names.

you have written word "where" twice in query.

i think you're trying is:

$results = "select investigator, projecttitle, institution, studies " . $where;

you should change line checks matching keywords from:

$where .= " 'keywords' '%$keyword%' ";

to:

$where .= " keywords '%$keyword%' ";

because again referring column name not string.

also, when try fetch result asking column 'othernotes', in query you're querying 'investigator', 'projecttitle' , 'institution' columns.

so query becomes:

$results = "select investigator, projecttitle, institution, othernotes studies " . $where

you should change line reads:

foreach($keywords $key=>$keyword)

to just:

foreach($keywords $keyword)

and use $keyword variable same way are.

you can change line checks if form has been posted to:

if (!(is_null($_post['keywords'])))

and make sure there 'keywords' column in studies table :)


Comments

Post a Comment

Popular posts from this blog

java - Run a .jar on Heroku -

-
i trying run .jar file on heroku, , can't find instructions anywhere on how this. have read wants me compile uploading heroku. possible, , if is, how this? if helps, trying run minecraft craftbukkit server, , don't have pom.xml file yet. you didn't provide details i'll try give , people reaches question way it. first of all, create heroku account , create heroku application (assumed have done that). second, need generate application jar , upload heroku. so, open terminal , install heroku cli (assuming unix terminal): $ sudo npm install -g heroku-cli you need have npm , nodejs installed, can check link: https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-16-04 once done that, can use npm update node version acceptable heroku-cli: $ sudo npm install -g n $ sudo n 7.10.0 and run: $ sudo npm install -g heroku-cli in order deploy jars, need install deploy plugin: $ sudo heroku plugins:install heroku-cli-deploy ...
Read more

java - Jtable duplicate Rows -

-
Image
when add new rows in jtable duplicate rows many times this method update jtable public final void tableaucomande(){ ((defaulttablemodel)tabcommande.getmodel()).getdatavector().clear(); session s=hibernateutil.getsessionfactory().opensession(); criteria cr1= s.createcriteria(commande.class); list <commande> lcs=cr1.list() ; criteria cr2= s.createcriteria(lignecommande.class); list <lignecommande> lck=cr2.list() ; if(lcs.size()!=0 && lck.size()!=0) { (commande lc:lcs) { for(lignecommande lig:lck){ ((defaulttablemodel)tabcommande.getmodel()).addrow(new object[]{ lc.getid_cmd(),lc.getnumcmd(),lc.getdate_cmd(),lc.getclient().getnomprenom(), lig.getproduit().getlib_prd(),lig.getquantite(),lig.getproduit().getid_prd() }); } } // tabcommande.setrowselectioninterval(tabcommande.getrowcount()-1,tabcommande.getrowcount()-1); } } this code add add data rows displaye...
Read more

validation - How to pass paramaters like unix into windows batch file -

-
i need pass various parameters .cmd file unix format file.cmd -configuration=value -source=value -flag but, try this: startlocal @echo off cls setlocal set cmdline=%* set configuration= set source= set badargs= set validation= goto main :splitargs echo splitargs(%*) if "%*" neq "" ( /f "tokens=1,2,* delims== " %%i in ("%*") call :assignkeyvalue %%i %%j & call :splitargs %%k ) goto :eof :assignkeyvalue echo assignkeyvalue(%1, %2) if /i %1==-configuration ( set configuration=%2 ) else if /i %1==-source ( set source=%2 ) else ( rem append unrecognised [key,value] badargs echo unknown key %1 set badargs=%badargs%[%1, %2] ) goto :eof :validate echo validating set validation=fail if defined configuration ( echo -configuration ok if defined source ( echo -source ok if not defined badargs ( set validation=success ) ) ) goto :eof :main cl...
Read more