PHP - Moved: Searching 2 Mysql Tables Simultaneously

Hi, does anybody know whether it is possible to search 2 tables from a database at once?

Hello

1) I am reading two good tutorials for building a search page with pagination:

http://www.phpfreaks.com/tutorial/basic-pagination
http://php.about.com/od/phpwithmysql/ss/php_pagination.htm
Before I ask the big question, I would like to know how does a query look like when searching multiple tables (e.g three) in the same time.
Table1/Table2/Table3.

May you kindly give me example?

2) The problem is that I have multiple tables with the same structure to search e.g. (title, body)
a) how I will know the ROWS NUMBER returned by the search query? it doesn't look a smart way to query each table and them count the results, and this basically takes much time right?
b) when displaying the result, how I will be able to set the correct hyperlink for each result?
you know, each table is a different subject, each one is located in different folder.

Thank you SO MUCH

Hi,   How can I select multiple columns from two tables and run a search through multiple fields?   My tables a   t_persons (holds information about persons) t_incidents (holds foreign keys from other tables including t_persons table)   What I want is to pull some columns from the two tables above and run a search with a LIKE criteria, something like below. The code originally worked well with only one table, but for two tables it generate errors:

$query = "SELECT
p.PersonID
,p.ImagePath
,p.FamilyName
,p.FirstName
,p.OtherNames
,p.Gender
,p.CountryID
,i.IncidentDate
,i.KeywordID
,i.IncidentCountryID
,i.StatusID

FROM t_incidents AS i
    LEFT JOIN t_persons AS p ON i.PersonID = p.PersonID
WHERE
    FamilyName LIKE '%" . $likes . "%' AND
    FirstName LIKE '%" . $likes . "%' AND
    OtherNames LIKE '%" . $likes . "%' AND
    Gender LIKE '%" . $likes . "%' AND
    IncidentDate LIKE '%" . $likes . "%' AND
    KeywordID LIKE '%" . $likes . "%' AND
    IncidentCountryID LIKE '%" . $likes . "%' AND
    StatusID LIKE '%" . $likes . "%'
ORDER BY PersonID DESC $pages->limit";

Errors a

Column 'IncidentDate' in where clause is ambiguous
Column 'KeywordID' in where clause is ambiguous
Column 'IncidentCountryID' in where clause is ambiguous
Column 'StatusID' in where clause is ambiguous

These columns are foreign keys on t_incidents table. I have also attached the table relationship diagram if it helps.   I will appreciate any better way to do this.   Thanx.   Joseph Attached Files  Model - 3.png   76.6KB   0 downloads

Dear All,

Greetings!

I am a student and have a final semester project of making a php based form to search a database.

Database is already created:
Username: test
password: test1
Details: DB Name: resume_bank, Table Name: Candidate
Table contents: Name, Phone, Address, DOB, Gender, Designation, experience_yrs, experience_months, Employment_Status

I need the code which would give the user an option to search using AND, OR, ALL functions.

Friends please help.

The form should look like: Enter the Designation you are looking for:
                                         Enter the experience: Yrs___ Months___
                                         Select Gender:

The result must come in another webpage which has numbered display results, like page-1, page-2, page3...

PLEASE HELP URGENTLY!!!!!!!
ANY BODY HAS READY MADE CODE PLEASE SEND IT!!!!!!

Thanks.

im trying to crete a page that will search mysql for entrys from ??? days previous.

ive not started on the php yet as i wanted to get the query done but im having a slight problem.

date is in dd/mm/yyyy format. if i run this query
SELECT * FROM `dsgi_serval` WHERE date >= '10/09/2010' 

it ONLY sorts by DD and not MM or YYYY, so anything greater than the 10th of the month shows regardless of what month.

when i get to the php ill either do a drop down box with a preset number or days or a text box where u enter the number of days or even a txt box u enter the actual day u want to search from. im undecided which would be best.

another problem i face with the php is how to tell the script to search from ? ?? when it says search from the past 3 days?


<?php

$date = date("d/m/y");    // todays date 04/12/2010
$_post= 3 days;           // search from 01/12/2010
$date - $_post = $search; // 01/12/2010;
$sql="SELECT * FROM $tbl_name" where date >= '$search';

echo the results


?>



i no the above is not proper php but i hope it saya what im trying to do.

Thanks

This portion is kind of stumping me. Basically, I have a two tables in this DB: users and users_access_level (Separated for DB normalization)

users: id / username / password / realname / access_level
users_access_level: access_level / access_name

What I'm trying to do, is echo the data onto an HTML table that displays users.username in one table data and then uses the users.access_level to find users_access_level.access_name and echo into the following table data, I would prefer not to use multiple queries if possible or nested queries.

Example row for users: 1234 / tmac / password / tmac / 99
Example row for users_access_level: 99 / Admin

Using the examples above, I would want the output to appear as such:

Username: Access Name: Tmac Admin
I am not 100% sure where to start with this, but I pick up quickly, I just need a nudge in the right direction.

The code I attempted to create just shows my lack of knowledge of joining tables, but I'll post it if you want to see that I did at least make an effort to code this myself.

Thanks for reading!

I have a form passing user's search term, ie name.
$pname = mysql_real_escape_string($pname;

Not sure on proper syntax to include this in my select statement.
I also want it to return for partial string matched, like 'mik' for 'mike':

$result = mysql_query(
  "SELECT * FROM guest WHERE name like '$pname'"
);

Hi there,    I'm a bit of a newbie and I have done a search online, but i'm still confused.    I need to search my MYSQL database in a filed named date_mod I need to search for todays date only $date=gmdate("Y-m-d");   But however the field is a datetime option so how can I search only todays date and not both date and time.    Thank you for reading. 

Hello, I am working on a project and I cant seem to get this to work. I have a database (Kingsbury) that stores a contact list. I am trying to make an page were a user can search the database by state. The code from the HTML site is:

Code: [Select]
<form action = "sqlllist.php" method="post"><br />
Please enter the state you would like to search:     <input type="text" name="state"  /><br />
<p><input type="submit" value="Enter" /></p>
</form>
And then from the .php file

Code: [Select]
<?php

$DBConnect = mysql_connect("*****", "*****", "********");


if ($DBConnect===FALSE) 
echo "<p>Connection Failed!.</p>\n";


else {

$State == $_POST['state'];
$Result = mysql_select_db("Kingsbury", $DBConnect);
$queryresult = @mysql_query("SELECT * FROM contacts  WHERE State = $State'", $DBConnect);
echo "<table width='100%' border='1'>\n";
echo "<tr><th>User ID</th>
<th>First Name</th>
<th>Last Name</th>
<th>Address</th>
<th>State</th>
<th>City</th>
<th>Zip Code</th>
<th>Area Code</th>
<th>Phone Number</th>\n";

While (($Row = mysql_fetch_row($queryresult)) !== FALSE) {
echo "<tr><td>{$Row[0]}</td>";
echo "<td>{$Row[1]}</td>";
echo "<td>{$Row[2]}</td>";
echo "<td>{$Row[3]}</td>";
echo "<td>{$Row[4]}</td>";
echo "<td>{$Row[5]}</td>";
echo "<td>{$Row[6]}</td>";
echo "<td>{$Row[7]}</td>";
echo "<td>{$Row[8]}</td>";

}
echo "</table>\n";
mysql_free_result($queryresult);
mysql_close($DBConnect);
}

?>

This, to me seems like it should be working, but it outputs the entire database.

Hey guys, im trying to select only certain rows that matchs the address in a array. Not sure how to do this

This is making the array
$siege_check3 = "SELECT address FROM planets WHERE siege='".mysql_real_escape_string($_SESSION['goauld'])."'"; 
$siege_check2 = mysql_query($siege_check3) or die(mysql_error());
$arr = array();
while($siege_check1 = mysql_fetch_array($siege_check2)) {

$siege_planets = $siege_check1['address'];

$arr[] = $siege_planets;
} 
Then I want to AND grab rows where defender_planet equals one of the address in the array above
tried using in_array but telling me its not a valid function

             $alert3 = "SELECT * FROM travel WHERE defender_id = '" .($_SESSION['user_id'])."' 
             AND stance = 2 AND stealth_tech < '".($stealth_tech)."' 
             AND address=  in_array(defender_planet,$arr) ORDER BY arrived_time DESC"; 

             $alert2 = mysql_query($alert3) or die(mysql_error());

while($alert1 = mysql_fetch_assoc($alert2)) {

}   

I'm trying to do something that I thought was very simple about 2 weeks ago :-(
I want to put a form on my site and link it to a database so when a user types a surname into the form they can search the db and the page will only display the surnames that match the search criteria. I got the db set up using phpmyadmin in about 2 minutes flat, but keep getting error messages when I write the php. I'm currently working with the below script, which keeps giving me the error 'unexpected T_string' on line 176

I've searched every forum and help site I can find, and the mysql and php manuals are just mind-boggling. I'm sure I'm making some really amateur mistake, but I'd really appreciate help with this!
thanks all!


<html>
<head>
<title>SEARCH RECORDS</title>
</head>
<body>

<FORM NAME ="Search" METHOD ="POST" ACTION = "test3">

<INPUT TYPE = "TEXT" VALUE ="surname" NAME = "surname">
<INPUT TYPE = "Submit" Name = "Search" VALUE = "Search">

</FORM>
</body>
</html>



<?

$user_name = "*****";
$password = "*****";
$database = "*****";
$server = "localhost";
$db_handle = mysql_connect($server, $user_name, $password);

$db_found = mysql_select_db($database, $db_handle);

if ($db_found) {

$SQL = "SELECT * FROM *****" WHERE surname=$_POST['surname'];
$result = mysql_query($SQL);

while ($db_field = mysql_fetch_assoc($result)) {
print $db_field['Grave'] . "<BR>";
print $db_field['Surname'] . "<BR>";
print $db_field['Forenames'] . "<BR>";
print $db_field['Death_Date'] . "<BR>";
print $db_field['Birth_Year'] . "<BR>";
}

mysql_close($db_handle);
}
else {
print "Database NOT Found ";
mysql_close($db_handle);
}

?>

I have a search where I want to be able to search a string of words. The search is going to be looking in 2 different table joined by a left outer join. The tables are "quotes" and "categories".

$sql="SELECT q.id, q.username, q.quote, q.by, q.voteup, q.votedown, q.servtime, c.quote_id, c.label FROM quotes q LEFT OUTER JOIN categories c ON q.id = c.quote_id WHERE ( q.username LIKE '$srch' OR q.quote LIKE '$srch' OR q.`by` LIKE '$srch' OR c.label LIKE '$srch')";
   
The above mysql statement works and returns values..BUT if say, I search "john" and "funny", and a quote is posted by the user "john", but has a category of "funny" it will output the same quote twice. I was wondering if there was a way to see if a quote has either 1 term or both terms, if so display that quote but only display it once. Below is what the query is outputting.


[100] => Array
        (
            [id] => 100
            [username] => John
            [quote] => new test quote blah blah
            [by] => John
            [voteup] => 0
            [votedown] => 0
            [servtime] => 2010-12-02 @ 16:27:03
            [label] => Array
                (
                    [0] => Historic
                    [1] => Serious
                    [2] => Funny
                )

        )


Here is the code in full.


////
$sword = explode(" ",$search);
foreach($sword as $sterm){
$srch="%".$sterm."%";
echo"$srch<br />";
$sql="SELECT q.id, q.username, q.quote, q.by, q.voteup, q.votedown, q.servtime, c.quote_id, c.label FROM quotes q LEFT OUTER JOIN categories c ON q.id = c.quote_id WHERE ( q.username LIKE '$srch' OR q.quote LIKE '$srch' OR q.`by` LIKE '$srch' OR c.label LIKE '$srch')";
$result=mysql_query($sql);
while($row=mysql_fetch_object($result)){
$quote[$row->id]['id'] = $row->id;
$quote[$row->id]['username'] = $row->username;
$quote[$row->id]['quote'] = $row->quote;
$quote[$row->id]['by'] = $row->by;
$quote[$row->id]['voteup'] = $row->voteup;
$quote[$row->id]['votedown'] = $row->votedown;
$quote[$row->id]['servtime'] = $row->servtime;
$quote[$row->id]['label'][] = $row->label;
}
echo"<pre>";
print_r($quote);
echo"</pre>";


I don't think this is the fastest way of doing this, as it loops for each item in the db, per each keyword that is search.

Any help would be great!!
-BaSk

Hello,

Greetings!

I have php application for restaurant, basically there are two types of orders Kitchen Items and Bar items. A cashier enters a order from customers from computer A (say). We have two computers in kitchen, Computer B and in Bar, Computer C.  When cashier from computer A clicks a button, depending upon the order type i need to print a chit on Computer B and/or Computer C. COmputer A, B, C are in same network.  All computers have laser printer which can print any type of content.

Well i tried to search the forum, i couldn't find anything that would be of my help. Can anyone tell me what would be the starting point for this??

Thanks
watsmyname

I'm trying to create a simple search engine bot and have found the biggest issue is that of performance, it takes several hours to index all the links and ideally I need to run it once a day, the bottleneck occurs when pulling the data from the remote urls in terms of network transfer time. This could obviously be reduced massively if I could read from several url's simultaneously. Does anyone know how I could do this. I'm aware that in PHP5 there is thread functionality which may solve the problem but this is only available from the CLI.  I heard that it could be done with CURL without having to go down the threaded route, does anyone know how nthis can be done or know of any examples on the net that I could look at?

As a cheeky follow up,   I was also thinking a potential problem could be the script getting out of hand and opening too many connections and I don't to cause a DOS attack! Is there a way that the number of connections could be limited to 10 for example. Is there a way of detecting when a CURL connection has finished reading a file so that a connection manager class could then start the next connection asap?

Thanks for any helpn people, I've been looking for this stuff for days!!

Ok so I have a form to submits to a .php file that creates an image.  This works fine, but I also want the info from the form to be sent to MySQL database.  The problem is that something in a script I "required" called core.inc.php is interfering and so no image is output.  Here is core.inc.php: Code: [Select]
<?php
ob_start();
session_start();
$current_file = $_SERVER['SCRIPT_NAME'];

if(isset($_SERVER['HTTP_REFERER'])&&!empty($_SERVER['HTTP_REFERER'])) {
$http_referer = $_SERVER['HTTP_REFERER'];
}

function loggedin() {
if(isset($_SESSION['user_id'])&&!empty($_SESSION['user_id'])) {
return true;
} else {
return false;
}
}

function getuserfield($field) {
$query="SELECT `$field` FROM `Users` WHERE `id`='".$_SESSION['user_id']."'";
if($query_run=mysql_query($query)) {
if($query_result = mysql_result($query_run, 0, $field)) {
return $query_result;
}
}
}

?>


Here is the code for the image creating .php file:
Code: [Select]
<?php
require 'connect.inc.php';
require 'core.inc.php';
$title = $_REQUEST['title'] ;
$user_id = getuserfield('id');
$query = "INSERT INTO `---` VALUES ('".mysql_real_escape_string($title)."','".mysql_real_escape_string($user_id)."')";
$query_run = mysql_query($query);
//There is some more code in here obviously, but it's irrelevant 
header('Content-type: image/png');
imagepng($image_f);
imagedestroy($image_f)


Can anybody give me some idea of what is conflicting or what I can do to fix it?