Page 1 of 1

Center + Add Image + Protect In PHP.

Posted: Wed Sep 22, 2010 10:19 am
by willevans1
Hi,

I have the code below:

Code: Select all

<?
/*
* search.php
*
* Script for searching a datbase populated with keywords by the
* populate.php-script.
*/
print "<html><head><title>[Squashy] Search! NOT MESSED UP.</title></head><body>\n";
if( $_POST['keyword'] )
{
    /* Connect to the database: */
    mysql_pconnect("www.freesqldatabase.com","sql01_44052","censored")
        or die("ERROR: Could not connect to database!");
    mysql_select_db("sql01_4405hahamo1");
    /* Get timestamp before executing the query: */
    $start_time = getmicrotime();
    /* Execute the query that performs the actual search in the DB: */
   $query = ' SELECT
   p.page_url AS url,
   COUNT(*) AS occurrences
   FROM
   page p,
   word w,
   occurrence o
   WHERE
   p.page_id = o.page_id AND
   w.word_id = o.word_id AND (false ';
$words = explode(' ', $_POST['keyword']);
foreach ($words as $word) {
    $query .= 'OR w.word_word = "' . $word . '" ';
}
$query .= ')
   GROUP BY
   p.page_id
   ORDER BY
   occurrences DESC
   LIMIT ' . $_POST['results'];
$result = mysql_query($query);

    /* Get timestamp when the query is finished: */
    $end_time = getmicrotime();
    /* Present the search-results: */
    print "<h2>[Squashy] Search Results For '".$_POST['keyword']."':</h2>\n";
    for( $i = 1; $row = mysql_fetch_array($result) or die(mysql_error()); $i++ )
    {
        print "$i. <a href='".$row['url']."'>".$row['url']."</a>\n";
        print "(occurrences: ".$row['occurrences'].")<br><br>\n";
    }
    /* Present how long it took the execute the query: */
    print "This search took: ".(substr($end_time-$start_time,0,5))." seconds.";
}
else
{
    /* If no keyword is defined, present the search-page instead: */
    print "<form method='post'>[Squashy Search] <input type='text' size='20' name='keyword'>\n";
    print "Results: <select name='results'><option value='5'>5</option>\n";
    print "<option value='10'>10</option><option value='15'>15</option>\n";
    print "<option value='20'>20</option></select>\n";
    print "<input type='submit' value='Search [Squashy]'></form>\n";
}
print "</body></html>\n";
/* Simple function for retrieving the currenct timestamp in microseconds: */
function getmicrotime()
{
    list($usec, $sec) = explode(" ",microtime());
    return ((float)$usec + (float)$sec);
}
?>

How do I:

a) Center the search box and title and add an image above it like in google, the code for the search box and title is (taken from the code above)

Code: Select all

{
    /* If no keyword is defined, present the search-page instead: */
    print "<form method='post'>[Squashy Search] <input type='text' size='20' name='keyword'>\n";
    print "Results: <select name='results'><option value='5'>5</option>\n";
    print "<option value='10'>10</option><option value='15'>15</option>\n";
    print "<option value='20'>20</option></select>\n";
    print "<input type='submit' value='Search [Squashy]'></form>\n";
}

b) How do I protect the code so that people can't see the database name and password?

Thanks,

Will