How To Add Image + Center + Protect [PHP]

[Squashy] · September 22, 2010

Hi,

I have the code below:

<?
/*
* 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)

{
    /* 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

taquitosensei · September 22, 2010

to secure it you can use a file to define them, set permissions on that file to read only for your web user and put that outside of the web root

<?php 
define("DB_PASSWORD","yourdbpassword"); 
define("DB_USER","yourdbuser"); 
?>

then in your connection script

require_once '/var/www/db.config.php'; 
mysql_pconnect("www.freesqldatabase.com",DB_USERNAME,DB_PASSWORD)

Sign In

How To Add Image + Center + Protect [PHP]

Recommended Posts

[Squashy]

Link to comment

Share on other sites

taquitosensei

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information