ibase_backup ( resource service_handle , string source_db , string dest_file , int options , bool verbose )

<?php

function backupDatabase($link,$db_name,$structure,$donnees,$format,$insertComplet=""){

$format = strtoupper($format);

$filename = "backup_".$db_name."_".date("Y_m_d").".sql";
$fp = fopen($filename,"w");
if (!is_resource($fp))
return false;

// liste des tables
$res = mysql_list_tables($db_name);
$num_rows = mysql_num_rows($res);
$i = 0;
while ($i < $num_rows)
{
$tablename = mysql_tablename($res, $i);
if ($structure === true)
{
fwrite($fp,"DROP TABLE IF EXISTS `$tablename`;n");

// requete de creation de la table
$query = "SHOW CREATE TABLE $tablename";
$resCreate = mysql_query($query);
$row = mysql_fetch_array($resCreate);
$schema = $row[1].";";
fwrite($fp,"$schemann");
}
if ($donnees === true)
{
// les données de la table
$query = "SELECT * FROM $tablename";
$resData = mysql_query($query);
if (mysql_num_rows($resData) > 0)
{
$sFieldnames = "";
if ($insertComplet === true)
{
$num_fields = mysql_num_fields($resData);
for($j=0; $j < $num_fields; $j++)
{
$sFieldnames .= "`".mysql_field_name($resData, $j)."`,";
}
$sFieldnames = "(".substr($sFieldnames,0,-1).")";
}
$sInsert = "INSERT INTO `$tablename` $sFieldnames values ";

while($rowdata = mysql_fetch_assoc($resData))
{
$lesDonnees = "<guillemet>".implode("<guillemet>,<guillemet>",$rowdata)."<guillemet>";
$lesDonnees = str_replace("<guillemet>","'",addslashes($lesDonnees));

if ($format == "INSERT")
{
$lesDonnees = "$sInsert($lesDonnees);";
}
fwrite($fp,"$lesDonneesn");
}
}
}
$i++;
}
fclose($fp);
}

$db_name="mabase";
backupDatabase ($db_name,"true","true","INSERT","true");

?>