Php Pan
A set of php scripts-performance !
Hallo , today is 04/02/2012

Auto
( Force Register )
  ↑
Insert		 Read
↓		 Diverse :
User = nick
Pass = name
nick@name.it
Delete
[ common to all ads ]
Real ads demo life are :
Diverse weeks 1, 2, 3 = 10, 15, 25 minutes respectively
. . . Auto / Bread & Breakfast [weeks 1, 2, 3, 4 = All 15 Minutes]
Wherein stated 180 seconds in all forms that's really 3 minutes :-)
This application is surfable and testable in Authentication performances as Usernames & Passwords for testing are pre inserted ( obviously this is just a presentation and not a site where to place real ads , the program shows only its performance and a panoramic of php great flexibility ).
In the section Auto the user is forced to register , while in the section Bed & Breakfast is contained the basic program-code , but no tracking on User surfing.
The section Diverse check if the Visitor is registered , invites to registration , and allows to insert in any case one free ad, without obliging to register and moreover if the Visitor is registered , the program sets and check the limits ( no more than 3 ads per subscription ).
...Please delete program's cookies before passing to test the section Diverse using the link that will appear
here




DataBase Search
Content of file selezAuto.php ( update & show )
<?
$id_conness = mysql_connect() or die("Impossible to connect to Database");
mysql_select_db("test",$id_conness);
@mysql_query("delete from auto where (now() > time_stamp)");
$query= "SELECT * FROM auto WHERE (builder = '$builder') AND (model LIKE '%$model%') AND (fuel_type = '$fuel_type') AND (year > $year) AND (time_stamp > now()) AND (price < $max_price) ORDER BY price";
$id_result = mysql_query ($query,$id_conness);
if(!$id_result) {echo "Impossible to read, error n° ",mysql_errno(),". ",mysql_error(),".";}
$_rows= mysql_num_rows($id_result); // Read of rows'database results
echo "<h3>Results: there are $_rows autos for sale in this selection</h3>";
// Displays results in a an html - table
while($tabauto = mysql_fetch_array($id_result,MYSQL_ASSOC)) {
echo "<table width=\"400\" border=\"5\">"; echo"<tr><td><h2>{$tabauto[builder]} {$tabauto[model]}
{$tabauto[year]}: {$tabauto[price]} euro</h2>
{$tabauto[ad_text]}</td></tr>";
echo"<br/>"; }
mysql_close($id_conness);
?>
Top