PHP get_insert_sql Examples

Example #1

File: export_db.php Project: lee99/tpmaker

 function dump_table($table, $fp = null)
 {
     $need_close = false;
     if (is_null($fp)) {
         $fp = fopen($table . '.sql', 'w');
         $need_close = true;
     }
     fwrite($fp, "-- \n-- {$table}\n-- \n");
     $rs = mysql_query("SELECT * FROM `{$table}`");
     while ($row = mysql_fetch_row($rs)) {
         fwrite($fp, get_insert_sql($table, $row));
     }
     mysql_free_result($rs);
     if ($need_close) {
         fclose($fp);
     }
     fwrite($fp, "\n\n");
 }

Example #2

File: webftp.php Project: HY-ZHQ/daocloud

function dump_table($table, $fp = null)
{
    $need_close = false;
    if (is_null($fp)) {
        $fp = fopen($table . '.sql', 'w');
        $need_close = true;
    }
    $a = mysql_query("show create table `{$table}`");
    $row = mysql_fetch_assoc($a);
    fwrite($fp, $row['Create Table'] . ';');
    //导出表结构
    $rs = mysql_query("SELECT * FROM `{$table}`");
    while ($row = mysql_fetch_row($rs)) {
        fwrite($fp, get_insert_sql($table, $row));
    }
    mysql_free_result($rs);
    if ($need_close) {
        fclose($fp);
    }
}