mysql_query("الاستعلام هنا") or die(mysql_error());

دالة الاضافة

function dbRowInsert($table_name, $form_data)
{
    // retrieve the keys of the array (column titles)
    $fields = array_keys($form_data);

    // build the query
    $sql = "INSERT INTO ".$table_name."
    (`".implode('`,`', $fields)."`)
    VALUES('".implode("','", $form_data)."')";

    // run and return the query result resource
    return mysql_query($sql);
}

دالة الحذف

function dbRowDelete($table_name, $where_clause='')
{
    // check for optional where clause
    $whereSQL = '';
    if(!empty($where_clause))
    {
        // check to see if the 'where' keyword exists
        if(substr(strtoupper(trim($where_clause)), 0, 5) != 'WHERE')
        {
            // not found, add keyword
            $whereSQL = " WHERE ".$where_clause;
        } else
        {
            $whereSQL = " ".trim($where_clause);
        }
    }
    // build the query
    $sql = "DELETE FROM ".$table_name.$whereSQL;

    // run and return the query result resource
    return mysql_query($sql);
}

دالة التحديث

function dbRowUpdate($table_name, $form_data, $where_clause='')
{
    // check for optional where clause
    $whereSQL = '';
    if(!empty($where_clause))
    {
        // check to see if the 'where' keyword exists
        if(substr(strtoupper(trim($where_clause)), 0, 5) != 'WHERE')
        {
            // not found, add key word
            $whereSQL = " WHERE ".$where_clause;
        } else
        {
            $whereSQL = " ".trim($where_clause);
        }
    }
    // start the actual SQL statement
    $sql = "UPDATE ".$table_name." SET ";

    // loop and build the column /
    $sets = array();
    foreach($form_data as $column => $value)
    {
         $sets[] = "`".$column."` = '".$value."'";
    }
    $sql .= implode(', ', $sets);

    // append the where statement
    $sql .= $whereSQL;

    // run and return the query result
    return mysql_query($sql);
}

function insert($info, $table) {
    if (!is_array($info)) { 
        return false;
    }

    $sql = "INSERT INTO `{$table}` (";
    
    for ($i=0; $i<count($info); $i++) {
        $sql .= key($info);
        if ($i < (count($info)-1)) {
        $sql .= ", ";
        } else $sql .= ") ";
        next($info);
    }
     reset($info);
     $sql .= "VALUES (";
     for ($j=0; $j<count($info); $j++) {
        $sql .= "'".current($info)."'";
        if ($j < (count($info)-1)) {
           $sql .= ", ";
        } else $sql .= ") ";
        next($info);
     }
     mysql_query($sql) or die("query failed ".mysql_error());
         return mysql_insert_id();
}

$info = array("title" => $t, "text" => $cont, "catid" => $type, "catid" => $pre);
// سوف يدخل لك البيانات وترجع لك ايضا رقم المدخل
$id = insert($info, "news");

mysql_query("INSERT INTO news (title,text,catid,supcat) VALUES ('{$t}','{$cont}','{$type}','{$pre}')");