My php scripts!

PHPSESSID and GOOGLE

2005-11-27T14:27:00.000-08:00

PHPSESSID suck when PHP will add a unique PHPSESSID query pair to you links. It's all about session.use_trans_sid that must be off if you want Google to eat your site alive. And guess what! It's easy to set it off.
Just make a blank file with Notepad and rename it .htaccess! Open this file, paste this code:

< if module >
php_flag session.use_trans_sid off
< /if module >

Note: Remove all spaces inside < >!!!!!
... save file, upload it in your root directory.

Have fun :P

Source: Why You Should Disable PHP’s session use_trans_sid

Ah. As a bonus ... if you want .htm and .html files to execute your php scripts please add this code in the same .htaccess file:

AddType application/x-httpd-php .php .html .htm

Dont forget to upload it! :)

[PHP] Page Generation Time

2005-10-24T20:01:00.000-07:00

This is a cool script that will help you see the number of seconds needed to load your pages.

/* This part of the script goes at the top of your page */

$starttime = explode(' ', microtime());
$starttime = $starttime[1] + $starttime[0];

/* This part of the script goes where you want load time to be displayed */

$mtime = explode(' ', microtime());
$totaltime = $mtime[0] + $mtime[1] - $starttime;
printf('Page loaded in %.3f seconds.', $totaltime);

Credits:
evidence / http://www.sythe.org/image-vp175499.html

Connect to a MySQL database using PHP

2005-05-03T21:42:00.000-07:00

Create a file named for example cfg_db_connect.php with the following code:

function dbopen()
{
global $connect;
global $mydbuser;
global $mydbpassw;
global $mymaindb;

$connect = mysql_connect( "localhost", $mydbuser, $mydbpassw );
if ( ! $connect ) die( "Can't connect to database." );
mysql_select_db( $mymaindb, $connect) or die ( "Error:".mysql_error() );
return $connect;
}

function dbclose($connect)
{
mysql_close($connect);
return true;
}

// please change the values:

$dbuser="MY_USER";
$dbpassw="MY_PASSWORD";
$maindb="MY_DATABASE";

You can use this function in any other file that need mysql connection:

include ("cfg_db_connect.php");
$connect=dbopen();
$query="SELECT something FROM table WHERE condition";
$request=mysql_query($query,$connect);
dbclose($connect);

Non-alphanumeric characters in input fields!

2005-04-26T18:22:00.000-07:00

Let's say $mystring came from something like this:

file1.
Input text field inside a form named mystring. Used form method: POST.

file2.
$mystring=$_POST['mystring']; function rvs ($argument) { return ereg_replace("[^a-zA-Z0-9]", "", $argument); } $result= rvs ($mystring); $a_1 = strlen($mystring); $a_2 = strlen($result); if($a_1 != $a_2) { echo "Error: Your input used non-alphanumeric characters!"; exit; }

Look at this example for a better description of rvs() function:
function rvs ($argument) { return ereg_replace("[^a-zA-Z0-9]", "", $argument); } $example="Daniel - 20 years old - result 20%"; $result = rvs ($example); echo $result;

This will print:
Daniel20yearsoldresult20

Please post comments with a better way to do this ;).