Web Developer Heed Help

[Spluskhn]

Ma ne Aak Website Design Kya Hai. Ab mje aak custum search chya jo mri website ma maujood items / Products k list be show krai.

Eg:> Aap Es Site Ko Visit Krai Awr Wha K Search Ma IPhone Type Krai Ko Appko Mri Bath Smje A Jyngi.

Click Here For Example

[CTWO]

ap ki site kis script me ha?

[Spluskhn]

Php

[Spluskhn]

In PHP

[Spluskhn]

Ye Script B Ma Ne Used K Hai Pr Error A Rha Hai

<form method="get" action="">
<label>Search For: </label><input type="text" name="query" />
<input type="submit" name="submit" value="Start Search" />
<input type="reset" value="Reset"
</form>

<?php
//PHP CODE STARTS HERE

if(isset($_GET['submit'])){

// Change the fields below as per the requirements
$db_host="Host Name";
$db_username="Username used to access database";
$db_password="Password to access database";
$db_name="Database u created for site";
$db_tb_name="Name of the table u created in site database";
$db_tb_atr_name="attribute(column name) of table in which search action is to be performed";

//Now we are going to write a script that will do search task
// leave the below fields as it is except while loop, which will display results on screen

mysql_connect("$db_host","$db_username","$db_passw ord");
mysql_select_db("$db_name");

$query=mysql_real_escape_string($_GET['query']);

$query_for_result=mysql_query("SELECT * FROM $db_tb_name WHERE

$db_tb_atr_name like '%".$query."%'");
echo "<h2>Search Results</h2><ol>";
while($data_fetch=mysql_fetch_array($query_for_res ult))
{
echo "<li>";
echo substr($data_fetch[$db_tb_atr_name], 0,160);
echo "</li><hr/>";
}
echo "</ol>";

mysql_close();
}
?>

[Spluskhn]

Any Bady

[N_HaDi]

Ye Script B Ma Ne Used K Hai Pr Error A Rha Hai

<form method="get" action="">
<label>Search For: </label><input type="text" name="query" />
<input type="submit" name="submit" value="Start Search" />
<input type="reset" value="Reset"
</form>

<?php
//PHP CODE STARTS HERE

if(isset($_GET['submit'])){

// Change the fields below as per the requirements
$db_host="Host Name";
$db_username="Username used to access database";
$db_password="Password to access database";
$db_name="Database u created for site";
$db_tb_name="Name of the table u created in site database";
$db_tb_atr_name="attribute(column name) of table in which search action is to be performed";

//Now we are going to write a script that will do search task
// leave the below fields as it is except while loop, which will display results on screen

mysql_connect("$db_host","$db_username","$db_passw ord");
mysql_select_db("$db_name");

$query=mysql_real_escape_string($_GET['query']);

$query_for_result=mysql_query("SELECT * FROM $db_tb_name WHERE

$db_tb_atr_name like '%".$query."%'");
echo "<h2>Search Results</h2><ol>";
while($data_fetch=mysql_fetch_array($query_for_res ult))
{
echo "<li>";
echo substr($data_fetch[$db_tb_atr_name], 0,160);
echo "</li><hr/>";
}
echo "</ol>";

mysql_close();
}
?>

aapne while wali line mai "$query_for_res ult" is mai space q di hai? yehi error hai dear
while($data_fetch=mysql_fetch_array($query_for_res ult))

[Spluskhn]

Wo b ma ne try kya hai pr nhi ho rha.

[JAL_PARI]

Error kia aa raha hy ?

[Urduadsense]

Dear Brother!

Ap is link ki madad se apna custom seach engine bna skte hen. Mostly sites me yehi use hota he. OK
http://www.google.com/cse

[Spluskhn]

Wo Msla tu ma ne hal kya hai pr ab database se data show nahi ho rha

[Spluskhn]

Kya Ye Database Teek Hai

`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`Image` VARCHAR( 30 ) NOT NULL ,
`product` VARCHAR( 32 ) NOT NULL ,
`condition` VARCHAR( 50 ) NOT NULL ,
`price` VARCHAR( 32 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM