[FONT=Comic Sans MS][SIZE=3]Hi all and Happy New Year
Hope you all had a fantastic time
I have just joined so I’m hoping someone can help this novice
I was up till 6am this morning trying to get my search engine box to work.
I have followed a tutorial in putting a php search engine box on a webpage and have it work.
I created mysql database with 5 fields etc…, all went well
I made a search page (index.php) and I made the results page (results.php).
I uploaded both files into my website inside a folder called testengine ( I haven’t connected it to my site, the folder just stands alone for testing)
My problem is I know I’ve got it wrong for the results page to connect to the database but can’t figure it out.
I have on the results page the following php code:
mysql_connect("localhost", "root", "");
mysql_select_db("databasefirst");
I am getting the errors in my lines 36 and 37 which means it’s the two lines quoted above.
I have changed localhost to other names including ‘localhost8080’, ‘localhost:8080’, ‘www.mydomainname.co.uk’,
My username is ‘root’ and my password is blank just the usual.
I logged into ‘localhost/myphpadmin’ and made the database.
I watched the tutorial and made the pages but I also downloaded the files as the tutorial allowed me to look at the code.
There were a couple of corrections that I had to make but everything seems fine, it’s just connecting.
Below I will add the full PHP from my results page
and after that the results that occured.
p.s. the address I’ve put down as ‘domain’ as I’ve hidden my own address I’m not too sure if I would be allowed to show my own domain on forum post[/SIZE][/FONT]
## TEST PAGE CODE ## which includes php code is ##
<center>
<h1 style="color:#00F" font-size="36px">SearchEngine</h1>
<form action="http://www.DOMAIN.co.uk/testengine/results.php" method="get">
<input type="text" name="input" size="50" value='<?php echo $_GET['input']; ?>' class="search-field" />
<input type="submit" value="search" class="search-button" />
</form>
</center>
<hr />
<?php
$input = $_GET['input']; //Note to self $input in the name of the search field
$terms = explode(" ", $input);
$query = "SELECT * FROM search WHERE ";
foreach ($terms as $each){
$i++;
if ($i == 1)
$query .= "keywords LIKE '%$each%' ";
else
$query .= "OR keywords LIKE '%$each%' ";
}
// connecting to our mysql database
mysql_connect("http://www.DOMAIN.co.uk", "root", "");
mysql_select_db("databasefirst"); // database name is databasefirst
$query = mysql_query($query);
$numrows = mysql_num_rows($query);
if ($numrows > 0){
while ($row = mysql_fetch_assoc($query)){
$id = $row['id'];
$title = $row['title'];
$description = $row['description'];
$keywords = $row['keywords'];
$link = $row['link'];
echo "<h2><a href='$link'>$title</a></h2>
$description<br /><br />";
}
}
else
echo "No results found for \\"<b>$input</b>\\"";
// disconnect
mysql_close();
?>
## RESULTS AFTER RUNNING TEST ##
Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host ‘http’ (1) in /home/545/connery/www.conneryscottishwalks.co.uk/public_html/testengine/results.php on line 33
Warning: mysql_select_db() [function.mysql-select-db]: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /home/545/connery/www.conneryscottishwalks.co.uk/public_html/testengine/results.php on line 34
Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/545/connery/www.conneryscottishwalks.co.uk/public_html/testengine/results.php on line 34
Warning: mysql_query() [function.mysql-query]: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /home/545/connery/www.conneryscottishwalks.co.uk/public_html/testengine/results.php on line 36
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/545/connery/www.conneryscottishwalks.co.uk/public_html/testengine/results.php on line 36
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/545/connery/www.conneryscottishwalks.co.uk/public_html/testengine/results.php on line 37
No results found for “contact”
Warning: mysql_close(): no MySQL-Link resource supplied in /home/545/connery/www.conneryscottishwalks.co.uk/public_html/testengine/results.php on line 56
[FONT=Comic Sans MS]
Can anyone help, I am a novice but slowly getting there, I think !!!
Regards
Glasgow-Guy[/FONT]