problem with php for searching mysql database

Resoum

I tried to develop a search interface to retrieve relevant information from mysql database to achieve this I created phpform but this does not work

I would be very grateful if you help to fix this problem.

Thank you
Resoum

Here is the begining of the php coding

<?php

  require_once("login.php");

  ?>



  <?php

  if ($authorized) {



  // set database access

  $host="myhost"; // Host name

  $username="username"; // Mysql username

  $password="password12345"; // Mysql password

  $db_name="dbname"; // Database name

  $tbl_name="bzs"; // Table name

  // Connect to server and select databse.


  $select = $_POST['contact_name'];

  $searchdb = $_POST['searchdb'];


  // make the query

  $query = "SELECT contact_name, category, organisation, country, city, website , phone, email"

  FROM bzs

  WHERE $select LIKE '%$searchdb%'";

  $result = @mysql_query($query); // run query



  $num = @mysql_num_rows($result);



  if ($num > 0) {

  echo "<p style=\"text-align: center\"><strong>There are currently $num of results.</strong></p>";

  } else {

  echo "<p style=\"text-align: center\"><strong>There are no matches in the database.</strong></p>";

  }



  // if ($result) { // If it ran OK, display the records.



  // Table header.

  echo '<table align="center" cellspacing="10" cellpadding="15">

  <tr>

  <td align="left"><b>contact name</b></td>

  <td align="left"><b>category</b></td>

  <td align="left"><b>organisation</b></td>

  <td align="left"><b>country</b></td>

  <td align="left"><b>city</b></td>

  <td align="left"><b>website</b></td>

  <td align="left"><b>phone</b></td>

  <td align="left"><b>email</b></td></tr>';





  // Fetch and print all the records.

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

  echo '<tr><td align="left">' . $row['contact_name'] . '</td>

  <td align="left">' . $row['category'] . '</td>

  <td align="left">' . $row['organisation'] . '</td>

  <td align="left">' . $row['country'] . '</td>

  <td align="left">' . $row['city'] . '</td>

  <td align="left">' . $row['website']

  <td align="left">' . $row['phone'] . '</td>

  <td align="left">' . $row['email'] . '</td></tr>';

  }



  echo '</table>';





  // Closing connection

  // Closing query

  //mysql_close($query);



  } else {

  echo "<p> You must provide a valid username and password to use this</p>";

  echo "<a href=\"index.php\">Back</a>";

  }



  ?>



  </body>

This is the end

Please use [noparse]

tags around php code.
Also don't post passwords.

Resoum

Dear PHPBUILDING COMMUNITY

Thank you for help me. I followed you advice and I took of the extra quotation mark, but the problem is still not solved.

Thanks
Resoum

      <?php

  require_once("login.php");

  ?>



  <?php

  if ($authorized) {



  // set database access

  $host="host"; // Host name

  $username="user"; // Mysql username

  $password="pass"; // Mysql password

  $db_name="user_bzstable"; // Database name

  $tbl_name="bzs"; // Table name

  // Connect to server and select databse.


  $select = $_POST['contact_name'];

  $searchdb = $_POST['searchdb'];


  // make the query

  $query = "SELECT contact_name, category, organisation, country, city, website , phone, email

  FROM bzs

  WHERE $select LIKE '%$searchdb%'";

  $result = @mysql_query($query); // run query



  $num = @mysql_num_rows($result);



  if ($num > 0) {

  echo "<p style=\"text-align: center\"><strong>There are currently $num of results.</strong></p>";

  } else {

  echo "<p style=\"text-align: center\"><strong>There are no matches in the database.</strong></p>";

  }



  // if ($result) { // If it ran OK, display the records.



  // Table header.

  echo '<table align="center" cellspacing="10" cellpadding="15">

  <tr>

  <td align="left"><b>contact name</b></td>

  <td align="left"><b>category</b></td>

  <td align="left"><b>organisation</b></td>

  <td align="left"><b>country</b></td>

  <td align="left"><b>city</b></td>

  <td align="left"><b>website</b></td>

  <td align="left"><b>phone</b></td>

  <td align="left"><b>email</b></td></tr>';





  // Fetch and print all the records.

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

  echo '<tr><td align="left">' . $row['contact_name'] . '</td>

  <td align="left">' . $row['category'] . '</td>

  <td align="left">' . $row['organisation'] . '</td>

  <td align="left">' . $row['country'] . '</td>

  <td align="left">' . $row['city'] . '</td>

  <td align="left">' . $row['website']

  <td align="left">' . $row['phone'] . '</td>

  <td align="left">' . $row['email'] . '</td></tr>';

  }



  echo '</table>';





  // Closing connection

  // Closing query

  //mysql_close($query);



  } else {

  echo "<p> You must provide a valid username and password to use this</p>";

  echo "<a href=\"index.php\">Back</a>";

  }



  ?>



  </body>

devinemke

you are never connecting to your database. you need to run [man]mysql_connect[/man] and [man]mysql_select_db[/man]

Resoum

Dear PHPbuilder community

Thank you very much for all you help. I found it all your help very useful

I added the following coding

 $link = mysql_connect('host', 'user', 'pass');
       if (!$link) {
       die('Not connected : ' . mysql_error());
        }

     $db_selected = mysql_select_db('bzstable', $link);
  if (!$db_selected) {
   die ('Can\'t use foo : ' . mysql_error());
   }

But there is still problem.
Would you help me to fix this problems
Thanks

Coding begin here

<?php

  require_once("login.php");

  ?>



  <?php

  if ($authorized) {



  // set database access

  $host="host"; // Host name

  $username="user"; // Mysql username

  $password="pass"; // Mysql password

  $db_name="user_bzstable"; // Database name

  $tbl_name="bzs"; // Table name

  // Connect to server and select databse.


   $link = mysql_connect('sql200.byethost8.com', 'b8_2391616', 'RHODES');
   if (!$link) {
   die('Not connected : ' . mysql_error());
    }

     $db_selected = mysql_select_db('bzstable', $link);
  if (!$db_selected) {
   die ('Can\'t use foo : ' . mysql_error());
   }


  $select = $_POST['contact_name'];

  $searchdb = $_POST['searchdb'];


  // make the query

  $query = "SELECT contact_name, category, organisation, country, city, website , phone, email

  FROM bzs

  WHERE $select LIKE '%$searchdb%'";

  $result = @mysql_query($query); // run query



  $num = @mysql_num_rows($result);



  if ($num > 0) {

  echo "<p style=\"text-align: center\"><strong>There are currently $num of results.</strong></p>";

  } else {

  echo "<p style=\"text-align: center\"><strong>There are no matches in the database.</strong></p>";

  }



  // if ($result) { // If it ran OK, display the records.



  // Table header.

  echo '<table align="center" cellspacing="10" cellpadding="15">

  <tr>

  <td align="left"><b>contact name</b></td>

  <td align="left"><b>category</b></td>

  <td align="left"><b>organisation</b></td>

  <td align="left"><b>country</b></td>

  <td align="left"><b>city</b></td>

  <td align="left"><b>website</b></td>

  <td align="left"><b>phone</b></td>

  <td align="left"><b>email</b></td></tr>';





  // Fetch and print all the records.

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

  echo '<tr><td align="left">' . $row['contact_name'] . '</td>

  <td align="left">' . $row['category'] . '</td>

  <td align="left">' . $row['organisation'] . '</td>

  <td align="left">' . $row['country'] . '</td>

  <td align="left">' . $row['city'] . '</td>

  <td align="left">' . $row['website']

  <td align="left">' . $row['phone'] . '</td>

  <td align="left">' . $row['email'] . '</td></tr>';

  }



  echo '</table>';





  // Closing connection

  // Closing query

  //mysql_close($query);



  } else {

  echo "<p> You must provide a valid username and password to use this</p>";

  echo "<a href=\"index.php\">Back</a>";

  }



  ?>



  </body>

dagon

and the problem is ?

Resoum

dagon replyed this "and the problem is ?" for what I posted regarding the php searching problem.
Would you please dagom and other phpbuilder subscriber help me to fix the problem I mentioned.

Thanks
Resoum
ps please check my previous post of 22/04/09 time 05:56 PM
Resoum Dear PHPbuilder community

dagon

if the problem is listed in another post why post again?

bpat1434

Looks like you have a syntax error in there with an extra double-quote in your SQL.

Weedpacket

Threads merged.

_electro_static

What is the problem that you are facing in this query? That would make the answering process more accurate and specific....

"$query = "SELECT contact_name, category, organisation, country, city, website , phone, email

FROM bzs

WHERE $select LIKE '%$searchdb%'";
"

This might not work....as far as i think...where is a conditional clause on which the data would be retrived. Hence you have to write WHERE contact_name=$select