PHP - Radio Buttion/text Box Mysql Search

I want to let user to choose the checked box, so they will type in the words in the box, and select the radio button to limit their search. How should I approach it?

$search_words = mysql_real_escape_string($_POST['search_words']);
      
      $query =
      "SELECT name,login_id,password,email
      FROM User
      WHERE name LIKE '".$search_words."%'
      ORDER BY name ASC";
      // my query to display the necessary fields
      $result = mysql_query($query, $conn);//get results
      $result2 = mysql_query($query, $conn);//get results
      $resultCheck = mysql_result($result2,0,0);
      ?>
       
<p align="center" class="passwordsummary_header"> User's Password Summary
<table width="302" border="1" align="center">
  <tr>
    <td width="229">
    <form method="post" action="search.php" id="searchform">
<div align="center" class="label">
  <p>Search:
    <input name="search_words" type="text" id="search_words" size="30" maxlength="20" />
    <input type="submit" name="GO" id="GO" value="Go" />
  </p>
  <p>
  <input type = "radio" name = "namesearch" id = "namesearch"
value = "AM" <?php if($name == 'namesearch') {echo "checked";}?> >
name search</input>
   <input name = "loginidsearch" type = "radio" id = "loginidsearch" value = "loginidsearch" <?php if($login_id == 'loginidsearch') {echo 'checked';}?>>loginid search<br />
   <input type = "radio" id = "emailsearch" name = "emailsearch" value = "emailsearch" <?php if($email == 'emailsearch') {echo 'checked';}?>>
     email search </input>
   </div>
</form>
    </td>
  </tr>
</table>

</p>

   <?php   
      if ($search_words != "" && $resultCheck != "")
      {
      
      
      echo "<table width='650' border='1' align='center' cellspacing='1'>
 
     <tr><tr>
    <td class='passwordsummary_label'>No</td>
    <td class='passwordsummary_label'>Name</td>
    <td class='passwordsummary_label'>Login ID</td>
    <td class='passwordsummary_label'>Password</td>
    <td class='passwordsummary_label'>Email</td>
     </tr>";
      
      $i = 1;
         while ($row = mysql_fetch_row($result)) //use loop to get the results
         {
            $name = $row['0'];
            $login_id = $row['1'];
            $password = $row['2'];
            $email = $row['3'];
            ?>
<td class="passwordsummary_info"><?php echo $i;?></td>
            <td class="passwordsummary_info"><?php echo $name;?></td>
            <td class="passwordsummary_info"><?php echo $login_id;?></td>
            <td class="passwordsummary_info"><?php echo $password;?></td>
            <td class="passwordsummary_info"><?php echo $email;?></td>
            </tr>
            <?php $i++;
         }
         echo "</table>";
      }
      else
      {
      echo '<p class="results">No search results</p>';
      }

Hey Everybody,

I am new to PHP coding and have searched tons of forums and still looking...

Please help me with the following:

I have a MySQL database. There are several fields in the table, among them are Amount_paid and Amount_returned fields. And there are two radio buttons Amount paid and Amount returned and one textBox where I will be entering an amount. What I need is to assign an entered amount to one of those radio buttons (depending which one is selected) and insert the textBox value into the correct field (amount_paid or amount_returned) of the table.

I have all other fields coded ok and they work, but have no idea how to make the above stuff work.

The code is attached, please let me know if you need more info. Thanks a lot!

EDIT: Sorry, now the file is attached

Hello!

I am designing a user registration form which has some radio buttons for people to select. I am confused as to how I should store the value selected by the user into the database.

Here is my code, just in case.
<li id="li_2" >
<label class="description" for="element_2">I am a  </label>
<span>
<input id="element_2_1" name="element_2" class="element radio" type="radio" value="1" />
<label class="choice" for="element_2_1">Student</label>
<input id="element_2_2" name="element_2" class="element radio" type="radio" value="2" />
<label class="choice" for="element_2_2">Staff</label>
<input id="element_2_3" name="element_2" class="element radio" type="radio" value="3" />
<label class="choice" for="element_2_3">Member</label>
<input id="element_2_4" name="element_2" class="element radio" type="radio" value="4" />
<label class="choice" for="element_2_4">Other</label>
</span>
</li>   

I'm in the process of making a network for investors and entrepreneurs. When they access their profile page, select edit and go to editprofile.php a problem arises with the data base submission. I have the data they have previously inputted being echoed back out to the user. This lets the user see what they have inputted so that they can make changes to their profile. Unfortunately, with my radio buttons, if no changes are made and the user hits submit, the radio buttons return a value of 'unchecked'. I need them to maintain the value previously submitted to the database if the radio button isn't 'checked'. I'm not sure exactly how to do this.

You can test it out yourself by going to http://network.jasonbiondo.com

Code is below:

Code: [Select]
?php

session_start();

require ('connect.php');

include ('header.php');

$savechanges = $_POST['savechanges'];

$firstname = strip_tags($_POST['firstname']);
$lastname = strip_tags($_POST['lastname']);
$username = strtolower(strip_tags($_POST['username']));
$email = strip_tags($_POST['email']);
$password = strip_tags($_POST['password']);
$repeatpassword = strip_tags($_POST['repeatpassword']);
$entrepreneur = 'unchecked';
$investor = 'unchecked';
$date = date("Y-m-d");
$companyname = strip_tags($_POST['companyname']);
$companywebsite = strip_tags($_POST['companywebsite']);
$founder = strip_tags($_POST['founder']);
$phone = strip_tags($_POST['phone']);
$address = strip_tags($_POST['address']);
$city = strip_tags($_POST['city']);
$state = strip_tags($_POST['state']);
$zipcode = strip_tags($_POST['zipcode']);
$country = strip_tags($_POST['country']);
$development = strip_tags($_POST['development']);
$capitalamount = strip_tags($_POST['capitalamount']);
$companydo = strip_tags($_POST['companydo']);
$founderbuilt = strip_tags($_POST['founderbuilt']);
$whatsnew = strip_tags($_POST['whatsnew']);
$understand = strip_tags($_POST['understand']);
$competition = strip_tags($_POST['competition']);
$money = strip_tags($_POST['money']);
$demo = strip_tags($_POST['demo']);
$incorporation = strip_tags($_POST['incorporation']);
$companynameinv = strip_tags($_POST['companynameinv']);
$phoneinv = strip_tags($_POST['phoneinv']);
$addressinv = strip_tags($_POST['addressinv']);
$cityinv = strip_tags($_POST['cityinv']);
$stateinv = strip_tags($_POST['stateinv']);
$zipcodeinv = strip_tags($_POST['zipcodeinv']);
$countryinv = strip_tags($_POST['countryinv']);
$angel = strip_tags($_POST['angel']);
$vc = strip_tags($_POST['vc']);
$capital = strip_tags($_POST['capital']);

if ($savechanges)

{

$queryreg = mysql_query("UPDATE users SET

   `firstname` = '$firstname',
   `lastname` = '$lastname',
   `email` = '$email',
   `entrepreneur` = '$entrepreneur',
   `investor` = '$investor',
   `companyname` = '$companyname',
   `companywebsite` = '$companywebsite',
   `founder` = '$founder',
   `phone` = '$phone',
   `address` = '$address',
   `city` = '$city',
   `state` = '$state',
   `zipcode` = '$zipcode',
   `country` = '$country',
   `development` = '$development',
   `capitalamount` = '$capitalamount',
   `companydo` ='$companydo',
   `founderbuilt` = '$founderbuilt',
   `whatsnew` = '$whatsnew',
   `understand` = '$understand',
   `competition` = '$competition',
   `money` = '$money',
   `demo` = '$demo',
   `incorporation` = '$incorporation',
   `companynameinv` = '$companynameinv',
   `phoneinv` = '$phoneinv',
   `addressinv` = '$addressinv',
   `cityinv` = '$cityinv',
   `stateinv` = '$stateinv',
   `zipcodeinv` = '$zipcodeinv',
   `countryinv` = '$countryinv',
   `angel` = '$angel',
   `vc` = '$vc',
   `capital` = '$capital'
   
   WHERE username=  '" . $_SESSION['username'] . "'
   
   ");
   
   $selected_radio_selector = $_POST['selector'];
    $selected_radio_invtype = $_POST['invtype'];
     
   if ($selected_radio_selector == 'entrepreneur')
      {
         $entrepreneur = 'checked';
         
      }
      else if ($selected_radio_selector == 'investor')
      {
         $investor = 'checked';
         
         if ($selected_radio_invtype == 'angel')
         {
            $angel = 'checked';
            $vc = 'unchecked';
         
         }
         else if ($selected_radio_invtype == 'vc')
         {
            $vc = 'checked';
            $angel = 'unchecked';
         }
         else
         {
         die("Please select what type of investor you are!");
         }
      }
   
}

$q = mysql_query("SELECT `firstname`, `lastname`, `firstname`, `lastname`, `email`, `entrepreneur`, `investor`, `companyname`, `companywebsite`, `founder`, `phone`, `address`, `city`, `state`, `zipcode`, `country`, `development`, `capitalamount`, `companydo`, `founderbuilt`, `whatsnew`, `understand`, `competition`, `money`, `demo`, `incorporation`, `companynameinv`, `phoneinv`, `addressinv`, `cityinv`, `stateinv`, `zipcodeinv`, `countryinv`, `angel`, `vc`, `capital` FROM `users` WHERE username=  '" . $_SESSION['username'] . "'");

$r = mysql_fetch_assoc($q);

?>

<script type="text/javascript" src="../assets/js/editprofile.js"></script>

<form action='editprofile.php' method="POST" id="form">

   <fieldset>

      <p id="required"> * Required Fields</p>

      <p class="fieldSpacing">

         <label for="firstname" class="leftcolalign">First Name *</label>

         <input id="firstname" class="rightcolalign" name="firstname" value='<?php echo $r['firstname']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="lastname" class="leftcolalign">Last Name *</label>

         <input id="lastname" class="rightcolalign" name="lastname" value='<?php echo $r['lastname'];?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="username" class="leftcolalign">User Name *</label>

         <?php echo $_SESSION['username']; ?>

      </p>

      <p class="fieldSpacing">

         <label for="email" class="leftcolalign">Email *</label>

         <input id="email" class="rightcolalign" name="email" value='<?php echo $r['email']; ?>''/>

      </p>

      <p class="fieldSpacing">

         <label for="selector" class="leftcolalign">What am I? *</label>

         <input id="entButton" class="radioalign" type="radio" name="selector" value="entrepreneur"<?php echo $r['entrepreneur']; ?>/>

         <label for="entrepreneur" id="entrepreneur">Entrepreneur</label>

         <input id="invButton" class="radioalign" type="radio" name="selector" value="investor"<?php echo $r['investor']; ?>/>

         <label for="investor" id="investor">Investor</label>

      </p>

   </fieldset>

   <fieldset id="entForm">

      <p class="fieldSpacing">

         <label for="companyname" class="leftcolalign">Company Name: *</label>

         <input id="companyname" class="rightcolalign" name="companyname" value='<?php echo $r['companyname']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="companywebsite" class="leftcolalign">Company Website:</label>

         <input id="companywebsite" class="rightcolalign" name="companywebsite" value='<?php echo $r['companywebsite']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="founder" class="leftcolalign">Founder(s): *</label>

         <input id="founder" class="rightcolalign" name="founder" value='<?php echo $r['founder']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="phone" class="leftcolalign">Phone Number(s): *</label>

         <input id="phone" class="rightcolalign" name="phone" value='<?php echo $r['phone']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="address" class="leftcolalign">Address: *</label>

         <input id="address" class="rightcolalign" name="address" value='<?php echo $r['address']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="city" class="leftcolalign">City: *</label>

         <input id="city" class="rightcolalign" name="city" value='<?php echo $r['city']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="state" class="leftcolalign">State:</label>

         <input id="state" class="rightcolalign" name="state" value='<?php echo $r['state']; ?>'/>

      </p>

      <p class="fieldSpacing">

         <label for="zipcode" class="leftcolalign">Zip Code:</label>

         <input id="zipcode" class="rightcolalign" name="zipcode" value='<?php echo $r['zipcode']; ?>'/>

      </p>

Hi,

I need to analyze a string and get the text between, before, and after the forward slashes..

The string will always look something like this, but will vary:

$str = "I will go to the store with <# one/two/three #> people."

Then I need to create a form with radio buttons for each choice. In this case (one, two, or three).

The text between the <# ... #> could be different every time, and with uknown amount of forward slashes.

Here is what I have so far but it doesn't work.

Code to find if there are slashes:

Code: [Select]
preg_match_all( '/([/]+)/',$str,$matches);
Code to create html form ..

Code: [Select]

$i = 0;
$html  = '<form>';

foreach ($matches[0] as $match){

     if ($pos = strpos( $str,$match ) ) === false )
          continue;
     }

     $html .= '<input type="radio" name="place-' . $i . '" value=". $match . '" />&nbsp;&nbsp;';

}

$html .= '</form>';


Its not working as needed. I'm not sure how to create radio button choices for the words (one, two, three).

Thanks

Hey in my edit page i have 2 radio buttons in my form and i need to make sure the same value is still selected how can i do that?

thanks

hello friend,

I use these code for update my database with radio button checked or unchecked through array but my code could not update the server data please help me :::

my code is :::

<?php
                            //include configuration file for connection
                            include_once('config.php');
                            $sql = "select * from ATTENDANCE";
                            $result=mysql_query($sql);
                            $count=mysql_num_rows($result);
                         ?>
                         <form name="form1" method="post" action="<? echo $_SERVER['REQUEST_URI']; ?>">
                            <table style="text-align: left; padding: 5px;" cellpadding="0px" cellspacing="0px">
                           <tbody>
                              <tr>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student ID</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Name</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Present</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Student Absent</th>
                                 <th style="text-align: center; padding: 5px; border: 1px #000000 solid;">Comment</th>
                              </tr>
                              <?php
                                 while($rows=mysql_fetch_array($result))
                                 {
                              ?>                                                   
                              <tr>
                                 <td class="table1">
                                    <? $id[] = $rows['STUDENT_ID']; ?><? echo $rows['STUDENT_ID']; ?>
                                 </td>
                                 <td class="table1">
                                    <? echo $rows['STUDENT_NAME']; ?>
                                 </td>                                                      
                                 <td id="present">
                                    <input type="radio" name="present<? echo $rows['STUDENT_ID']; ?>" checked="checked" value="PRESENT">Present            
                                 </td>
                                 <td id="absent">                                    
                                    <input type="radio" name="present<? echo $rows['STUDENT_ID']; ?>" value="ABSENT">Absent
                                 </td>                              
                                 <td style="text-align: left; padding: 5px; border: 1px #000000 solid; height: 33px;">
                                    <? echo $rows['COMMENT']; ?>
                                 </td>                                                   
                              </tr>
                              <?php }?>
                              <tr>
                                 <td colspan="5" style="vertical-align:middle; text-align: center;"><br><br>
                                    <input id="Submit" type="submit" name="Submit" value="Submit" style="text-align: center; background-color: #000000; color: #ffffff; border: 1px #000000 solid;">
                                 </td>
                              </tr>                                                                                 
                           </tbody>
                        </table>
                     </form>   
                     <?php
                        if($_POST['$Submit'])
                        {
                           foreach($_POST['STUDENT_ID'] as $id)
                           {                               
                              $sql = "UPDATE ATTENDANCE SET STUDENT_PRESENT = '".$_POST["present".$id]."' WHERE STUDENT_ID = '".$id."' ";
                              $result = mysql_query($sql);
                           }
                        }
                        if($result)
                        {    print_r ($_POST);                        
                           header("location:report.php");                           
                        }
                        else
                        {
                           echo "Your entry is not completed at this time.............";
                        }
                     ?>

Hey!

I have it so users can submit info to my site. They have to check some check boxes and radio buttons. I want them to be able to edit this information, so I want to have the data pulled from the MySQL database and have the correct radio button selected (and the text bolded). So I'm thinking some sort of array to check for each value in the database... but I don't really know.

There are a few groups of radio boxes and check boxes but here is an example of one.

Code: [Select]
<input type="radio" name="stage" value="Stage 1" /> Stage 1
 <input type="radio" name="stage" value="Stage 2" /> Stage 2
 <input type="radio" name="stage" value="Stage 3" /> Stage 3

The information is pulled from the database like this:

Code: [Select]
$res=mysql_query("SELECT * FROM ACTIVE WHERE INDEX_ID=$id");
if(mysql_num_rows($res)==0) echo "There is no data in the table <br /> <br />";
else
{
 for($i=0;$i<mysql_num_rows($res);$i++)
 {
  $row=mysql_fetch_assoc($res);
 }
}

So when I pull information (lets say I want to echo it) it'd look like this:

Code: [Select]
$row[STAGE]
The value for the stage selection can only be Stage 1, Stage 2 or Stage 3 so I need it to be selected when the page loads.

Thanks!

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=357414.0

Hello, I'm working on a site search which I've never done from scratch before and I've run into a couple road blocks along the way.

The first problem is that in my search form it seems that there is no minimum amount of characters that can be searched. For example I enter no value into the text box and hit enter or click submit and all my database items are displayed.

My second issue is simply with the criteria of the search. say I were to search for something like 48 x 12 I would get nothing when in fact there is an item in my database with those characters in the description however they are seperated in this fashion 48 in X 12 in.

Lastly is the problem where when I search for results that should produce a message stating that my search returned no results instead I get my blank results table.

I'm sure that there are some easy solution and minor tweaks that can be made to my code to rectify some or all of these issues and would appreciate those willing to help to share their knowledge with me.

Here is my code:

<?php require_once('Connections/price_db.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$colname_Recordset1 = "-1";
if (isset($_GET['title'])) {
  $colname_Recordset1 = $_GET['title'];
}
mysql_select_db($database_price_db, $price_db);
$query_Recordset1 = sprintf("SELECT * FROM price_db WHERE tb_name LIKE %s OR tb_desc LIKE %s", GetSQLValueString("%" . $colname_Recordset1 . "%", "text"),GetSQLValueString("%" . $colname_Recordset1 . "%", "text"));
$Recordset1 = mysql_query($query_Recordset1, $price_db) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

and the html is as follows:

    <div id="search_results">
  <?php do { ?>
      <table width="208" border="0" align="left" style="margin-right:20px;">
        <tr>
          <td width="220"><img width="175px" height="175px" src="<?php echo $row_Recordset1['tb_img']; ?>" /></td>
        </tr>
        <tr>
          <td height="45"><h2><?php echo $row_Recordset1['tb_name']; ?></h2>
            <div id="search_desc"><?php echo $row_Recordset1['tb_desc']; ?></div></td>
        </tr>
        <tr>
          <td height="37"><div id="search_price">$ <?php echo $row_Recordset1['tb_price']; ?>
            <form action="/save_to_cart.php" method="get" style="padding-top:15px;">
              <input type="text" name="quantity" size="10" value="Quantity" style="margin-right:12px; color:#666" onfocus="this.value=''"/>
              <input type="button" name="Add" value="Select" onclick="this.form.submit()"/>
            </form>
          </div></td>
        </tr>
      </table>
      <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

</body>
</html>
<?php
mysql_free_result($Recordset1);

?>

Thanksagain for all help

 

Hello friends, I am a novice in php. Though I create 2 scripts:   1. students registration form 2. search students by Registration Number   Our students' Registration Numbers are as follows: nifeA001, nifeA002 & so on...   But when someone enter just "nife" or "n" or "A" etc all the students's data is showing.   I want that students can search data by entering only Full Registration Number not a Part.   I am placing the search.php code below. Please help me out....   ----------------- Search.php ------------------ <?php mysql_connect("localhost", "root", "") or die("could not connect"); mysql_select_db("student") or die("could not connect");   //collect if(isset($_POST['search'])) {     $searchq = $_POST['search'];     $searchq = preg_replace("#[^0-9a-z]#i", "", $searchq);   //here $query = mysql_query("SELECT * FROM user WHERE registration LIKE '%$searchq%'") or die("could not search!");     $count = mysql_num_rows($query);     if($count == 0){         $output = 'There was no search results!';     }else{         while($row = mysql_fetch_array($query)) {             $fname = $row['firstname'];             $lname = $row['surname'];             $id = $row['registration'];               $output .= '<div> '.$id.' '.$fname.' '.$lname.'</div>';                }         } }   ?>   <html> <head> </head> <body> <form action="form.php" method="post">     <input type="text" name="search" placeholder="search for students.."     <input type="submit" value=">>" /> </form>   <?php print("$output");?> </body> </html>
Edited by NasimUddinAhmmad, 13 January 2015 - 05:43 AM.

I found an article on how to implement a mysql search (http://www.iamcal.com/publish/articles/php/search/) and it seemed like a good way to go, but I can't get it up and running.

Here is my code:
Code: [Select]
<?php
$db_host = 'localhost';
$db_user = 'username';
$db_pwd = 'password';

$database = 'dbname';
$table = 'Principals';

if (!mysql_connect($db_host, $db_user, $db_pwd))
die("Can't connect to database");

if (!mysql_select_db($database))
die("Can't select database");




$searchterms = 'dorr oliver';


function search_split_terms($terms){

$terms = preg_replace("/\"(.*?)\"/e", "search_transform_term('\$1')", $terms);
$terms = preg_split("/\s+|,/", $terms);

$out = array();

foreach($terms as $term){

$term = preg_replace("/\{WHITESPACE-([0-9]+)\}/e", "chr(\$1)", $term);
$term = preg_replace("/\{COMMA\}/", ",", $term);

$out[] = $term;
}

return $out;
}

function search_transform_term($term){
$term = preg_replace("/(\s)/e", "'{WHITESPACE-'.ord('\$1').'}'", $term);
$term = preg_replace("/,/", "{COMMA}", $term);
return $term;
}

function search_escape_rlike($string){
return preg_replace("/([.\[\]*^\$])/", '\\\$1', $string);
}

function search_db_escape_terms($terms){
$out = array();
foreach($terms as $term){
$out[] = '[[:<:]]'.AddSlashes(search_escape_rlike($term)).'[[:>:]]';
}
return $out;
}

function search_perform($terms){

$terms = search_split_terms($terms);
$terms_db = search_db_escape_terms($terms);
$terms_rx = search_rx_escape_terms($terms);

$parts = array();
foreach($terms_db as $term_db){
$parts[] = "Principals RLIKE '$term_db'";
}
$parts = implode(' OR ', $parts);

$sql = "SELECT * FROM Principal WHERE $parts";

$rows = array();

$result = mysql_query($sql);
while($row = mysql_fetch_array($result, MYSQL_ASSOC)){

$row[score] = 0;

foreach($terms_rx as $term_rx){
$row[score] += preg_match_all("/$term_rx/i", $row[Principals], $null);
}

$rows[] = $row;
}

uasort($rows, 'search_sort_results');

return $rows;
}

function search_rx_escape_terms($terms){
$out = array();
foreach($terms as $term){
$out[] = '\b'.preg_quote($term, '/').'\b';
}
return $out;
}

function search_sort_results($a, $b){

$ax = $a[score];
$bx = $b[score];

if ($ax == $bx){ return 0; }
return ($ax > $bx) ? -1 : 1;
}

function search_html_escape_terms($terms){
$out = array();

foreach($terms as $term){
if (preg_match("/\s|,/", $term)){
$out[] = '"'.HtmlSpecialChars($term).'"';
}else{
$out[] = HtmlSpecialChars($term);
}
}

return $out;
}

function search_pretty_terms($terms_html){

if (count($terms_html) == 1){
return array_pop($terms_html);
}

$last = array_pop($terms_html);

return implode(', ', $terms_html)." and $last";
}


#
# do the search here...
#

$results = search_perform($searchterms);
$term_list = search_pretty_terms(search_html_escape_terms(search_split_terms($searchterms)));
The table name is 'Principals' and the field name I am trying to search is 'Principal'.  I am getting an error on the line:

while($row = mysql_fetch_array($result, MYSQL_ASSOC)){

The error is:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Can anyone shed some light on this for me?

Hey guys, I'm a newbie to PHP and MySql, and I need some help!

For the record, I am a web developer and designer, who always put off learning  , due to fear, but realized I had to do it.

Anyways, my problem is this. I am creating a website, where there has to be a seach box where people can lookup names, and or keywords, that are stored into my db.


I've googled it a billion times, and got everything to almost work. I know how to set-up a database, tables, insert info, and all the real basics of mysql.


I am running my site on MAMP right now, and here is the code that I am trying to use.



<?php
/* DON'T DISPLAY ANY PHP ERRORS OR WARNINGS
   (optional) comment out in development
-----------------------------------------------*/
error_reporting(0);

/*DATABASE INFO
--------------------------*/
$hostname_logon = 'localhost';         //Database server LOCATION
$database_logon = '';               //Database NAME
$username_logon = '';               //Database USERNAME
$password_logon = '';               //Database PASSWORD


/*MYSQL TABLE TO SEARCH
--------------------------*/
//update these values to table you want to search
$db_table       = '';               //TABLE NAME
$row_id       = '';               //TABLE ROW ID
$title_field    = '';               //FIELD CONTAINING ITEM TITLE
$content_field    = '';               //FIELD CONTAINING ITEM CONTENT
$link_field    = '';               //FIELD CONTAINING ITEM URL
$limit         = 10;               //NUMBER OF RESULTS PER PAGE

/*SEARCH SCRIPT FILENAME
--------------------------*/
//get the name of this file,so you can name this file whatever you want. This is used in the action parameter of the search form
$currentFile = $_SERVER["SCRIPT_NAME"];
$parts = explode('/', $currentFile);
$currentFile = $parts[count($parts) - 1];

/*CONNECT TO THE DATABASE
--------------------------*/
//open database connection
$connections = mysql_connect($hostname_logon, $username_logon, $password_logon) or die ( "Unabale to connect to the database" );
//select database
mysql_select_db($database_logon) or die ( "Unable to select database!" );

/*GET SEARCH PARAMETERS
--------------------------*/
//get the search parameter from URL
$var = mysql_real_escape_string(@$_REQUEST['q']);

//get pagination
$s = mysql_real_escape_string(@$_REQUEST['s']);

//set keyword character limit
if(strlen($var) < 3){
   $resultmsg =  "<p>Search Error</p><p>Keywords with less then three characters are omitted...</p>" ; 
}
//trim whitespace from the stored variable
$trimmed = trim($var);
$trimmed1 = trim($var);
//separate key-phrases into keywords
$trimmed_array = explode(" ",$trimmed);
$trimmed_array1 = explode(" ",$trimmed1);

// check for an empty string and display a message.
if ($trimmed == "") {
   $resulterror =  "<p>Search Error</p><p>Please enter a search...</p>" ;
}

// check for a search parameter
if (!isset($var)){
   $resulterror =  "<p>Search Error</p><p>We don't seem to have a search parameter! </p>" ;
}

//make sure search keyword is at least 2 characters. (buggy if not)
if(strlen($trimmed) < 2){
   $resulterror =  "<p>Search Error</p><p>Your keyword has to be at least two characters long! </p>" ;
}

/*CREATE SEARCH FORM
--------------------------*/
$search_form = '<form class="search-form" action="'.$currentFile.'" method="GET">
      <div>
      <input name="q" type="text" value="'.$q.'"><input name="search" type="submit" value="Search">
      </div>
</form>';


/*DISPLAY QUERY ERRORS OR DO THE SEARCH
--------------------------------------------*/
if($resulterror){
   $resultmsg = $resulterror;
}else{

// Build SQL Query for each keyword entered
foreach ($trimmed_array as $trimm){
   
   // MySQL "MATCH" is used for full-text searching. Please visit mysql for details.
   $query = "SELECT *, MATCH (".$title_field.",".$content_field.") AGAINST ('".$trimm."') AS score FROM ".$db_table." WHERE MATCH (".$title_field.",".$content_field.") AGAINST ('+".$trimm."' IN BOOLEAN MODE) HAVING score > 0.01 ORDER BY score DESC";
   // Execute the query to  get number of rows that contain search kewords
   $numresults=mysql_query ($query)  or die ("Error in query: $query. " . mysql_error());
   $row_num_links_main =mysql_num_rows ($numresults);
   
   //If MATCH query doesn't return any results due to how it works do a search using LIKE
   if($row_num_links_main < 1){
      $query = "SELECT * FROM ".$db_table." WHERE ".$title_field." LIKE '%".$trimm."%' OR ".$content_field." LIKE '%".$trimm."%' ORDER BY ".$row_id." DESC" ;
      $numresults=mysql_query ($query);
      $row_num_links_main =mysql_num_rows ($numresults);   
   }
   // next determine if 's' has been passed to script, if not use 0.
   // 's' is a variable that gets set as we navigate the search result pages.
   if (empty($s)) {
    $s=0;
   }
   
   // now let's get results.
   $query .= " LIMIT $s,$limit" ;
   $numresults = mysql_query ($query) or die ("Error in query: $query. " . mysql_error());
   $row= mysql_fetch_array ($numresults);
   
   
   //store record id of every item that contains the keyword in the array we need to do this to avoid display of duplicate search result.
   do{
     $adid_array[] = $row[ 'news_id' ];
   }while( $row= mysql_fetch_array($numresults));
} //end foreach



/*Display a message if no results found
--------------------------*/
if($row_num_links_main == 0 && $row_num_links_main1 == 0){
   $resultmsg = "<p>Search results for: ". $trimmed."</p><p>Sorry, your search returned zero results</p>" ;
}


//delete duplicate record id's from the array. To do this we will use array_unique function
$tmparr = array_unique($adid_array);
$i=0;
foreach ($tmparr as $v) {
   $newarr[$i] = $v;
   $i++;
}


//total number of results
$row_num_links_main = $row_num_links_main + $row_num_links_main1;


   if($resultmsg != ""){
      $resultmsg = "<p>Search results for: <strong>" . $var."</strong></p>";
   }
   
   /* FETCH RESULTS BASED ON THE ID
   --------------------------------------------*/
   foreach($newarr as $value){

   // EDIT HERE and specify your table and field unique ID for the SQL query
   $query_value = "SELECT * FROM ".$db_table." WHERE ".$row_id." = '".$value."'";
   $num_value=mysql_query ($query_value);
   $row_linkcat= mysql_fetch_array ($num_value);
   $row_num_links= mysql_num_rows ($num_value);
   
   //create summary of the long text. For example if the field2 is your full text grab only first 130 characters of it for the result
   $introcontent = strip_tags($row_linkcat[$content_field]);
   $introcontent = substr($introcontent, 0, 130)."...";
   
   //now let's make the keywods bold. To do that we will use preg_replace function.
   //Replace field
     $title = preg_replace ( "'($var)'si" , "<strong>\\1</strong>" , $row_linkcat[ $title_field] );
     $desc = preg_replace ( "'($var)'si" , "<strong>\\1</strong>" , $introcontent);
    
     //COMMENT OUT THIS LINE: If using database ID field to drive links
     $link = preg_replace ( "'($var)'si" , "<strong>\\1</strong>" ,  $row_linkcat[$link_field]  );
    
     //UNCOMMENT and EDIT THIS LINE: If using database ID field to drive links
     //$link = 'http://yourdomain.com/pageid='. $row_linkcat[$link_field];
   
      foreach($trimmed_array as $trimm){
         if($trimm != 'b' ){
            $title = preg_replace( "'($trimm)'si" ,  "<strong>\\1</strong>" , $title);
            $desc = preg_replace( "'($trimm)'si" , "<strong>\\1</strong>" , $desc);
            $link = preg_replace( "'($trimm)'si" ,  "<strong>\\1</strong>" , $link);
          }//end highlight
      }//end foreach $trimmed_array
      //format and display search results
         $resultmsg.= '<div class="search-result">';
            $resultmsg.= '<div class="search-title"><a href="'.$link.'">'.$title.'</a></div>';
            $resultmsg.= '<div class="search-text">';
               $resultmsg.= $desc;
            $resultmsg.= '</div>';
            $resultmsg.= '<a href="'.$link.'" class="search-link">';
            $resultmsg.= $link;
            $resultmsg.= '</a>';
         $resultmsg.= '</div>';
   
   }  //end foreach $newarr

   /* CREATE PAGINATION
   --------------------------------------------*/
   if($row_num_links_main > $limit){
   // next we need to do the links to other search result pages
      if ($s >=1) { // do not display previous link if 's' is '0'
         $prevs=($s-$limit);
         $resultmsg.= '<div class="search-previous"><a href="'.$PHP_SELF.'?s='.$prevs.'&q='.$var.'">Previous</a></div>';
      }
   // check to see if last page
      $slimit =$s+$limit;
      if (!($slimit >= $row_num_links_main) && $row_num_links_main!=1) {
         // not last page so display next link
         $n=$s+$limit;
         $resultmsg.= '<div  class="search-next"><a href="'.$PHP_SELF.'?s='.$n.'&q='.$var.'">Next</a></div>';
      }
   }//end if $row_num_links_main > $limit
}//end if no errors
?>
<?php

//display form
echo $search_form;

//display results
echo $resultmsg;
?>


I know that this might be asking a lot, but can someone who is smarter than me please give me instructions on how to set this up.

I am at a complete loss. I've tried everything. I can connect to the db, and all, but it returns errors, and or blank screens.

I will owe everyone. Thank you.

I wonder whether someone may be able to help me please.

I'm trying to put together php code and an html form that allows an administrator to search for a user via the email address, retrieving the 'first' and 'surname' from the pertinent record in a mySQL database.

What I would like to happen is for the retrieved 'first' and surname' values to be automatically populated into the 'first' and 'surname' text boxes on the same search form.

I can perform the search and retrieval of the correct record without any problem, but I can't work out how to populate the 'first' and 'surname' values into my search form. I am quote a novice with PHP so apologies if this is a really daft question, but I just windered whether somone could take a look at my code below and let me know where I've gone wrong?

Many thanks

PHP CODE
Code: [Select]
<?php 
require("phpfile.php"); 

// Opens a connection to a MySQL server 

$connection=mysql_connect ("hostname", $username, $password); 
if (!$connection) { die('Not connected : ' . mysql_error());} 

// Set the active MySQL database 

$db_selected = mysql_select_db($database, $connection); 
if (!$db_selected) { 
die ('Can\'t use db : ' . mysql_error()); 
} 


$email = $_POST['email']; 
$result = mysql_query("SELECT * FROM userdetails WHERE emailaddress like '%$email%'"); 

while($row = mysql_fetch_array($result)) 
{ 
echo $row['forename']; 
echo $row['surname']; 
echo "<br />"; 
} 
?>

HTML FORM
Code: [Select]
!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
    <head>
        <title>Maptitle>
        <script src="js/gen_validatorv4.js" type="text/javascript"></script>
    </head>
    <h1><span class="blue">Sign Up</span> For Map My Finds</h1>
    <form name="userpasswordreset" id="userpasswordreset" method="post" action="search.php">
        <h2>Your Details </h2>
    </div>
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr>
                <td width="26%" height="25"><strong>Email Address</strong></td>
                <td width="4%">&nbsp;</td>
                <td width="70%"><input name="email" type="email" id="email" size="50" /></td>
            </tr>
            <tr>
                <td height="25"><strong>Confirm Email</strong></td>
                <td>&nbsp;</td>
                <td><input name="conf_email" type="email" id="conf_email" size="50" /></td>
            </tr>
           
            <tr>
                <td height="25"><label>
                    <input type="submit" name="Submit" value="Search" />
                    </label></td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td height="25"><strong> First Name </strong></td>
                <td>&nbsp;</td>
                <td><input name="fname" type="text" id="fname" size="30" value="<?php echo $forename; ?>" /></td>
            </tr>
            <tr>
                <td height="25"><strong> Address Last Name </strong></td>
                <td>&nbsp;</td>
                <td><input name="lname" type="text" id="lname" size="30"  value="<?php echo $surname; ?>" /></td>
            </tr>
            <tr>
                <td height="25">&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td height="25">&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td height="25"><strong>Password</strong></td>
                <td>&nbsp;</td>
                <td><input name="pass" type="password" id="pass" size="30" /></td>
            </tr>
            <tr>
                <td height="25"><strong>Confirm Password </strong></td>
                <td>&nbsp;</td>
                <td><input name="conf_pass" type="password" id="conf_pass" size="30" /></td>
            </tr>
            <tr>
                <td height="25">&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td height="25"><strong>Password Hint </strong></td>
                <td>&nbsp;</td>
                <td><input name="hint" type="text" id="hint" size="30" /></td>
            </tr>
            <tr>
                <td height="25">&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
            <tr>
                <td height="25">&nbsp;</td>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
            </tr>
        </table>
    </form>
    <script language="JavaScript" type="text/javascript">
        // Code for validating the form
        // Visit http://www.javascript-coder.com/html-form/javascript-form-validation.phtml
        // for details
        var frmvalidator = new Validator("userpasswordreset");
        frmvalidator.addValidation("email","req","Please provide your email address");
        frmvalidator.addValidation("email","email","Please enter a valid email address");
        frmvalidator.addValidation("conf_email","eqelmnt=email", "The confirmed email address is not the same as the email address");
    </body>
    </html>