How to use same code in many programs

[Anon]

Hello!...
How to use same code in many programs?
If I use same database but I usenew table in other program for example :
$host="localhost";
$user="root";
$password="xxxx';
$db='myDB";
mysql_pconnect($host,$user,$password);
$sql="drop table labreport";
$rn=mysql_db_query($db,$sql);

Create Table

$sql = "CREATE TABLE labreport (month varchar(20), ";
$sql .= "product_code varchar(20), ";
$sql .= "factory_code varchar(5), ";
$sql .= "factory_name varchar(20), ";
$sql .= "total_code int(4), ";
$sql .= "no_samp int(4), ";
$sql .= "item_code varchar(10), ";
$sql .= "item_name varchar(50), ";
$sql .= "item_type varchar(5), ";
$sql .= "amount int(4))";
$rn = mysql_db_query($db,$sql);

If I will use this myDB but change table to create
I will coding by any way...:function ..or include()
or any code to suitable
thank you for your instuction..
^--

[Anon]

hi Why,

you can definately use an function which you can use in different pages.

 it is very simple

create an filename.inc file:

<?php

$host="localhost";
$user="root";
$password="xxxx';
$db='myDB";
mysql_pconnect($host,$user,$password);

?>

 now you can use this file every time you have to connect to database, just by including it above your database function i.e.

<?php

include ( "filename.inc" );

// your sql statements here;

?>

hope this helps you.

piyush

[Anon]

This is perfectly good solution.

But remember that the include file needs to be parsed by PHP,
so if you think of making a huge library of usefull functions,
it will slow down the startup of your script.