Php > Database Related

Insert data into mysql table

Insert data into mysql table

<?php 
function fixQuotes ($what = "") 
{ 
    $what = ereg_replace("'","''",$what); 
    $counter = 0; 
    while (eregi("\\\\'", $what) && $counter < 10) 
    { 
        $what = ereg_replace("\\\\'","'",$what); 
    #print "<p>counter=[$counter] what=[$what]</p>\n"; 
    } 

    return $what; 
}; 

function insertData($inputTable, $inputField, $inputValue) 
{ 
    $i = 1; 
    $fieldList = ""; 
    $valueList = ""; 
    $fieldCount = 0; 
     
    $fieldCount = count($inputField); 
    foreach ($inputField as $v) 
    { 
        $fieldList = $fieldList . $v; 
        $i++; 
        if ($i <= $fieldCount) 
        { 
            $fieldList = $fieldList  . ", "; 
        }; 
    }; 
    # reset local vars 
    $i = 1; 
    reset($inputField);     

    foreach ($inputValue as $v) 
    { 
        $v = fixQuotes($v); 
        $valueList = $valueList . chr(39) . $v . chr(39); 
        $i++; 
        if ($i <= $fieldCount) 
        { 
            $valueList = $valueList . ", "; 
        }; 
    }; 
     
     
    $query = "INSERT INTO " . $inputTable . " (" . $fieldList . ") VALUES (" . $valueList . ");"; 

    print "<br />"; 
    #print $query; 

    $result = mysql_query($query); 
    if (!$result) 
    { 
        print "<p>Insert failed, dammit.</p>\n"; 
    } 
    else 
    { 
        #print "<p>Inserted ok.</p>"; 
    }; 
}; 
?>