PHP - Search Code Not Reading Table

Hello   Is it possible to save data from saved htm table from other website in our mysql database system   as I have problem that there is one htm page where i can get data but i want to save it in mysql table. as data is large on htm page  it was hard to copy so i want access it direct from php and save it in mysql table   please guide   awaiting your valuable reply.   Thank in advance

Okay I don't mind telling you I am very perplexed on how to read a text file delimited with TAB into a HTML Table using PHP. I don't know where to begin, I have read about 12 examples and get more confused each time. I hope someone can help me. I am looking to read this delimited (TAB) file skipping the first line and reading array's 2,5,6,7,8,9, and 10, then displaying in a HTML Table. Corresponding Headers would be nice. The php file does not work at the present because I am trying to read the array sections by row.    Thank You in advance Attached Files  ParseText.php   852bytes   3 downloads  JimTest.txt   16.88KB   1 downloads

I wanted to develop a Wordpress plugin.

There's a few existing plugins for the subject I wanted to code.

I thought I would get some inspiration by looking at the code.

It's a gigantic mess of spaghetti!

The code I looked at, looks like it's been made using an IDE. There seems to be so many folders and files - it's crazy. Others I looked at seem to be similar.

It seems like an enterprise application.

I'm more than capable of writing a spec and coding myself.

The only thing I'm missing would be Wordpress practices - setting up tables and using hooks and other things.

Any advice?

Or do I just get dirty and sink my head into the code and untangle?

QUESTIONS:

- Do you use an IDE to code PHP?

- What are the most popular IDE's?

Thanks.

Hi   I come from a desktop (vb.net) background and have used oridinary text files for my databases. I use file locking to prevent other processes from writing to the same file simultaneously.   Now I am moving over the PHP/MySQL - what precautions should I take to stop a simultaneous processes from writing to a table at the same time.?   Do I need to lock the table before writing to it?   Does MySQL deal with this automatically and just block my process until the table becomes free?   (I am talking about a single table here, not multiple dependant tables - I know that is another issue)   Thanks     Nigel

Hello

I have three tables

User

diysmps

usergroup


usergroupid is common in the three tables.

diysmps is joined on usergroup, so running this sql



SELECT
diysmps.name,
diysmps.email,
diysmps.sumbit,
diysmps.message,
diysmps.ID,
usergroup.title
FROM diysmps
INNER JOIN usergroup ON diysmps.usergroupid = usergroup.usergroupid
ORDER BY diysmps.ID DESC

see results i get in picture attached. the result (PENDIN REGISTRATION) is what i need to be updated WHEN the user register to the forums.

when the user register to the forums, an account with his EMAIL will be created into the (USER) table.

So, I need to look out for the email FROM (diysmps TABLE) into the user table _search user table for email from diysmps table_ and if found to update the USERGROUPID in (diysmps TABLE) withe the USERGROUPID from (USER) table (related to the email searched)

so, when user registers, status from PENDING REGISTRATION to REGISTERED will be shown

I know it looks complex for me, but thats how i can describe

Thanks all

this is the creation table code.the database is testing.
Code: [Select]
CREATE TABLE users (fname VARCHAR(30), lname VARCHAR(30), info BLOB); INSERT INTO users VALUES ( "Jim", "Jones", "In his spare time Jim enjoys biking, eating pizza, and classical music" ), ( "Peggy", "Smith", "Peggy is a water sports enthusiast who also enjoys making soap and selling cheese" ),( "Maggie", "Martin", "Maggie loves to cook itallian food including spagetti and pizza" ),( "Tex", "Moncom", "Tex is the owner and operator of The Pizza Palace, a local hang out joint" )

the html code:
Code: [Select]
<h2>Search</h2>
<form name="search" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="fname">First Name</option>
<Option VALUE="lname">Last Name</option>
<Option VALUE="info">Profile</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>


the search code:
Code: [Select]
<?php
if ($searching =="yes") { 
echo "<h2>Results</h2><p>";
if ($find == "") { 
echo "<p>You forgot to enter a search term"; 
exit; 
} 
mysql_connect("localhost", "root", "123") or die(mysql_error()); 
mysql_select_db("database_name") or die(mysql_error()); 
$find = strtoupper($find); 
$find = strip_tags($find); 
$find = trim ($find); 
$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'"); 
while($result = mysql_fetch_array( $data )) { 
echo $result['fname']; 
echo " "; 
echo $result['lname']; 
echo "<br>"; 
echo $result['info']; 
echo "<br>"; 
echo "<br>"; 
} 
$anymatches=mysql_num_rows($data);
if ($anymatches == 0) { 
echo "Sorry, but we can not find an entry to match your query<br><br>"; 
} 
echo "<b>Searched For:</b> " .$find; 
} 
?>

I have this code I'm using for a search:

if ($xsearch)
{
$searchsql = mysql_escape_string($xsearch);
        if ($use_regex_search) {
            $whereA[] = "(a.adtitle RLIKE '[[:<:]]{$searchsql}[[:>:]]' OR a.addesc RLIKE '[[:<:]]{$searchsql}[[:>:]]')";
        } else {
            $whereA[] = "(a.adtitle LIKE '%$searchsql%' OR a.addesc LIKE '%$searchsql%')";
        }
}
So, what I want to do is to merge a.adtitle and a.addesc, so they become one value, let's say a.admerged or $admerged, I really don't know which one is possible, so the above code should look like this:

if ($xsearch)
{
$searchsql = mysql_escape_string($xsearch);
        if ($use_regex_search) {
            $whereA[] = "(a.merged RLIKE '[[:<:]]{$searchsql}[[:>:]]')";
        } else {
            $whereA[] = "(a.merged LIKE '%$searchsql%')";
        }
}

The DB structure, regarding those two values, is like this: In the same table, named ads, there are those two rows, named adtitle and addesc, from which the adtitle contains the Ad Title text of the ad, and the addesc contains the Ad Description text of the ad. So, my idea is to merge those two texts in some new variable, so the search function should see those two texts as a one whole text, not checking them one by one, like it does now with the first code above. Here is one example, just to simplify my explanation:

Ad Title: nokia phone on sale
Ad Description: brand new, unpacked, with 16gb memory card included.
Ad Merged: nokia phone on sale brand new, unpacked, with 16gb memory card included.

While merged, it should have empty spece between them.

I'm working to improve the search function, to search by phrase, by words, etc, and I need to solve this merging thing first, in order to continue. So, any help is appreciated. The original file with the above code is attached to this post. Thanks to all of you in advance.

This is my SEARCH code.

Code: [Select]
$like  = "SearchWord LIKE '%".implode("%' OR SearchWord LIKE '%", explode(' ', $Var))."%'";
$query = "SELECT * FROM db1 WHERE $like ORDER BY ToDate ASC";
$results = mysql_query($query);
Currently this code search every word in the MYSQL column. (e.g. If a user enter a 3 words and hit the search button, it still take the two words as individual words and outputs all records which has either of those 3 words.)

My need is to make the code find ALL the search words match in any sequence.

Example:
Wooden toy for 3 year old
Metal sward
Dora cotton pillow
Wooden sward

if the user search using "wooden toy" the code should show only "Wooden toy for 3 year old"
if the user search using "wooden" the code should show "Wooden sward" and  "Wooden toy for 3 year old"

Hi Everyone,

I have a script for a search box, it is not working as expected i need to know what to change in it safely.

The search is for UK postcodes, for testing it i'm using my postcode WS122SH.

The results are this:

Click here to try the search on google
You searched for: "ws122sh"
Results for ; ws122sh  ws122sh
 Next 10 >>
Showing results 1 to of
"ws122sh"

I know i have WS122SH in my DB, so that IS a result, so i know that if numrows == 0 isnt working right? but not sure how to change it? i deleted it before but it caused syntax errors, any one please help. Thanks you.

Code: [Select]
<?PHP
session_start();
include('php only scripts/db.php');
?>
<!DOCTYPE html>
  <head>
    <title>Removalspace.com</title>
 <style type="text/css">
<!--
body {
background-image: url(styles/downloaded%20styles/todo/todo/images/bg.png);

}
-->
 </style>
 <link href="styles/downloaded styles/todo/todo/css/style.css" rel="stylesheet" type="text/css" />
 <link rel="stylesheet" type="text/css" href="styles/downloaded styles/todo/todo/css/style9.css" />
    <link rel="stylesheet" type="text/css" href="styles/downloaded styles/todo/todo/css/demo.css" />   
        <link href='http://fonts.googleapis.com/css?family=Terminal+Dosis' rel='stylesheet' type='text/css' />
        <style type="text/css">
<!--
.Stile1 {color: #333333}
-->
        </style>
 </head>
 
<body>
<!--start container -->
<div id="container">
<header>
    <nav>   
      <div id="logo"><a href="index.php"><img src="images/header2.png" alt="Logo here" width="219" height="161" /></a>      </div>
     
      <div id="search-top">
   <form method="post" action="search.php">
  <input type="text" name="strSearch" onFocus="if(this.value=='Search')this.value='';" onBlur="if(this.value=='')this.value='Search';" value="Search"  id="search-field"/>
  <input type="submit" value="" id="search-btn"/>
  </form>
      </div> 
      <div id="nav_social"><a href="http://www.facebook.com/pages/Removalspace/181434181939226"><img src="styles/downloaded styles/todo/todo/images/facebook_32.png" alt="Become a fan" width="32" height="32" /></a><a href="#"><img src="styles/downloaded styles/todo/todo/images/twitter_32.png" alt="Follows on Twitter" /></a><a href="#"><img src="styles/downloaded styles/todo/todo/images/linkedin_32.png" alt="Linked in" /></a><a href="contact.php"><img src="styles/downloaded styles/todo/todo/images/email_32.png" alt="Contact" width="32" height="32" /></a> </div>
  </nav>
 
  </header>


<p><a href="removals.php">Search Removals</a></p>
<p><a href="storage.php">Search Storage</a></p>
<p><a href="about.php">About</a></p>
<p><a href="contact.php">Contact</a></p>
<div class="content">
<!--star main -->
   
    <main></main>
    <!--end main -->
    <!--start middle -->
    <middle>   
      <div class="section_slogan">
<?PHP
// validate postcode search
function is_valid_uk_postcode($postcode) {
    $pattern = "/^([A-PR-UWYZ0-9][A-HK-Y0-9][AEHMNPRTVXY0-9]?[ABEHMNPRVWXY0-9]? {1,2}[0-9][ABD-HJLN-UW-Z]{2}|GIR 0AA)$/";
 
    if (preg_match($pattern, $postcode)) {
        return TRUE;
    }
 
    $this->validation->set_message('is_valid_uk_postcode', 'That is not a valid %s.');
    return FALSE;
}

$error_message = "";
if((!isset($_POST['strSearch'])) || (strlen(trim($_POST['strSearch'])) <5) || (trim($_POST['strSearch']) != preg_replace("/[^a-zA-Z0-9\_]/", "", trim($_POST['strSearch'])))) {
$error_message = "You must enter a valid postcode<br>";
$error_message = $error_message . "Valid postcodes must not contain and spaces and consist of letters and numbers only.<br>";
$error_message = $error_message . 'Your invalid name was: <font color="red">' . $_POST['strSearch'] . "</font><hr>";
}else{
$postcode = mysql_real_escape_string(trim($_POST['strSearch']));
}






// Get the search variable from URL
  $postcode_results = $_POST['strSearch'];
  $trimmed = trim($postcode_results); //trim whitespace from the stored variable

// rows to return
$limit=10;

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

// check for a search parameter
if (!isset($postcode_results))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }

// Build SQL Query 
$query = "(SELECT postcode, company_name FROM companies
             WHERE postcode like '%$trimmed%')                 
  ORDER BY postcode"; // EDIT HERE and specify your table and field names for the SQL query
 
// If we have no results, offer a google search as an alternative

if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results</p>";

// google
 echo "<p><a href=\"http://www.google.com/search?q="
  . $trimmed . "\" target=\"_blank\" title=\"Look up
  " . $trimmed . " on Google\">Click here</a> to try the
  search on google</p>";
  }

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");
 

// display what the person searched for
echo "<p>You searched for: &quot;" . $postcode_results . "&quot;</p>";"<br>";
"<hr>";

// begin to show results set
echo "<a href=\"localarea.php?var=$postcode_results\">Results for $q;</a>";
$count = 1 + $s ;

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row['postcode'];
  $name = $row['company_name'];

  echo "&nbsp;$title" ;
  echo "&nbsp;$company_name" ;
  $count++ ;
  }

$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$postcode_results\">&lt;&lt;
  Prev 10</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$postcode_results\">Next 10 &gt;&gt;</a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p>Showing results $b to $a of $numrows</p>";
 
 
?>

<?php echo  "<a href=\"localarea.php?var=$var\">&quot;$postcode_results&quot;</a>";?>
</div>
    </middle>
</div>
<!--end middle -->
<!--start footer -->
<footer> 
  <div id="footer"></div>
</footer>
<!--end footer -->
</div>
<!--end container -->
<!-- Free template distributed by http://freehtml5templates.com -->
  </body>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js"></script>
</html>

Somewhat new with PHP but I think I'm on the right track. I'm trying to search for a serial number on a sql table. I want a response of the serial # and what column its in. There is 4 columns if that helps (id, 30, 32, 31). (serials 002062008002220 002062008002222 002062008002233 are in the table) When I enter in a serial # 002062008002220 (all serials are 16 digits long). I get a blank page to show up...  my form

<form action="search.php" method="get">
<input id="serials" type="text" name="serials" />
<input type="submit" />
</form>

my php

<?php

$con=mysqli_connect("localhost", "xxx", "xxx", "nsmserials");

if (mysqli_connect_errno ()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$search = mysql_real_escape_string($_REQUEST['serials']);
$query = "SELECT 30, 32, 31 FROM nsmtable WHERE 30 LIKE '%$search%' OR 32 LIKE '%$search%' OR 31 LIKE '%$search%'";

$result = mysql_query($query);

while ($row = mysql_fetch_array($result)){
    echo "<li><span class='name'><b>{$row['serials']}</b></span></li>";
}

mysqli_close($con);

?>

Hi all, a have a small problem with my search script. At the moment I am searching a field in my tabel called searchtags, now if I enter a one word search term of a string of characters it will return the results but if they are not in the same order it won't.

Example:

searchtags contains - Ford Mondeo 1999 2.0L petrol car

If I search "Ford Mondeo" the query returns results, whereas if I search "Mondeo Ford" the query returns no results?

I assume I have to expand the search in some way but I don;t know how, any ideas? Thanks in advance


Code: [Select]
<?php

  // Get the search variable from URL
  $var = @$_GET['q'] ;
  $field = @$_GET['field'] ;
  $trimmed = trim($var); //trim whitespace from the stored variable

if ($field == "") { //if search from homepage start here

$query = "select * from fleet where searchtags like \"%$trimmed%\"  
  order by fleetref"; // EDIT HERE and specify your table and field names for the SQL query

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);
 $limit=10000; 


if ($numrows == 0)
  {
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; motorhomes to hire returned zero results</p>";

  }

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for
echo "<h1>You searched for - " . $var . "cars</h1>";

// now you can display the results returned
  while ($row= mysql_fetch_array($result))
  { 
  $fleetref = $row['fleetref'];
  $fleetmake = $row['fleetmake'];
  $fleetmodel = $row['fleetmodel'];
  $fleetyear = $row['fleetyear'];
  $fleetchassis = $row['fleetchassis'];
  $fleetberth = $row['fleetberth'];
  $fleetlayout = $row['fleetlayout'];
  $fleetlength = $row['fleetlength'];
  $fleettype = $row['fleettype'];
  $fleetof = $row['fleetof'];
  $fleetimage1 = $row['fleetimage1'];
  $fleetimage2 = $row['fleetimage2'];
  $fleetimage3 = $row['fleetimage3'];
  $fleetimage4 = $row['fleetimage4'];
  $fleetadded = $row['fleetadded'];
  $fleetengine = $row['fleetengine'];
  $pricelow = $row['pricelow'];
  $pricemid = $row['pricemid'];
  $pricehigh = $row['pricehigh'];
  $fleetviews = $row['fleetviews'];
  
  $query = mysql_query("SELECT * FROM mhhire WHERE `ref` = '$fleetof'");
  
  if(mysql_num_rows($query)==0){

echo "<p>This company does not exsist</p>";

  }else{
  while($details = mysql_fetch_array($query)){
  $company = $details ['company'];
  $location = $details ['location'];
  
echo "<div class=\"fleet_vehicle\">";

if ($fleetimage1 == "fleet/") {
echo "<img src=\"images/no_image.jpg\" alt=\"$fleetmake $fleetmodel\" width=\"100\" height=\"75\" class=\"fleet_thumb\">";
}
else {
echo "<img src=\"$fleetimage1\" alt=\"$fleetmake $fleetmodel\" width=\"100\" height=\"75\" class=\"fleet_thumb\">";
}
echo "<div class=\"fleet_title\">$fleetmake $fleetmodel $fleetyear</div>";
echo "<div class=\"fleet_berth\"><img src=\"images/$fleetberth.gif\" alt=\"$fleetberth berth\"></div>";
echo "<div class=\"fleet_details_in\"><div class=\"fleet_details\">- $fleetberth berth<br />- $fleetlayout<br /></div></div>";
echo "<div class=\"fleet_details_in\"><div class=\"fleet_details\">- $fleetchassis<br />- $fleetengine<br /></div></div>";
echo "<div class=\"fleet_details_in\"><div class=\"fleet_details\">- $fleetlength meters<br />- $fleettype<br /></div></div>";
echo "<div class=\"fleet_options\">From <strong>$company</strong> in <strong>$location</strong> - <a href=\"view_motorhome_for_hire.php?ref=$fleetref\">More info >></a></div>";

echo "</div>";

}}
  }

} ?>

I got this code made for me to put on my google search code.

<?php

$click_value = '0.001'; //Amount in dollars that each click is worth

function increment_clicks() {
    //Get current click count
    if(file_exists('click_count.txt'))
        $clicks = file_get_contents('click_count.txt');
    else
        $clicks = 0;
   
    //Add current click to count
    $clicks++;
   
    //Save new value to file
    $file = fopen('click_count.txt', 'w');
    fwrite($file, $clicks);
    fclose($file);
}

function get_click_amount() {
    global $click_value;
   
    //Get current click count
    if(file_exists('click_count.txt'))
        $clicks = file_get_contents('click_count.txt');
    else
        $clicks = 0;
   
    //Return value of all clicks based on $click_value, formatted to 2 decimal places
    return number_format($clicks * $click_value, 3);
}

if (isset($_POST['search'])) {
    //Search button was clicked, increment count
    increment_clicks();
}

$click_amount = get_click_amount();

?>
<html>
<head>
</head>

<body>
<center>

<p id="click_amount">$<?php echo $click_amount; ?></p>
<form action="" method="POST">
    <input type="text" name="search" value="" />
    <input type="submit" value="Search" />
</form>

</center>
</body>
</html>

Now i do not know how to put it in my google code if you put it on a page by itself it works.

I do not know if i can list my google code here so if anyone can help i will pm them m google code.

THANKS

Hi there, new to the forum   Ok so i have a crm and i'm trying to add bits, been pretty succesful at most of it, however i've added a new field "status" and i want to be able to search this field, i've tried copying and changing the existing code, but it doesn't seem to be grabbing it.   So here's some exisiting code (that works and searches the field marked "Address"

            'address' => array(
                'title' => _l('Address:'),
                'field' => array(
                    'type' => 'text',
                    'name' => 'search[address]',
                    'value' => isset($search['address'])?$search['address']:'',
                    'size' => 15,
                )
            ),

            'status' => array(
                'title' => _l('Status:'),
                'field' => array(
                    'type' => 'text',
                    'name' => 'search[status]',
                    'value' => isset($search['status'])?$search['status']:'',
                    'size' => 15,
                )
            ),

I thought a simple name change like above would work, but it doesn't pull anything through, anyone got any ideas?