Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
function CreateRecord($class)
{
$sqlfields = '';
$sqlvalues = '';
foreach ($class->allfields as $fld => $val) {
$sqlfields .= "`$fld`,";
if (gettype($val) !== 'integer') {
$val = "'" . str_replace("'", "''", str_replace("\\", "\\\\", $val)) . "'";
}
$sqlvalues .= "$val,";
}
$sqlfields = rtrim($sqlfields, ',');
$sqlvalues = rtrim($sqlvalues, ',');
$runsql = "INSERT INTO portal_leads ($sqlfields) VALUES ($sqlvalues)";
ConsoleLog($runsql);
ConsoleLog("Creating new record");
$temp = callsql($class->portal_conn, $runsql);
}