PHP insert_in_db示例

示例#1

文件： insert_db.php 项目： marczych/hack-hhvm-docs

        }
        $sql .= "REPLACE INTO last_seen_values (name, defaultval, permissions) VALUES ('{$key}', '" . sqlite_escape_string(expand_macros($data[0])) . "', '{$data['1']}');";
    }
    if ($sql) {
        sqlite_query($idx, $sql);
    }
}
$db_open = isset($idx) ? true : false;
if (!$db_open && !($idx = sqlite_open('ini_changelog.sqlite', 0666, $error))) {
    die("Couldn't create the DB: {$error}");
}
// process PHP sources
foreach ($tags as $tag) {
    $array = $replace = array();
    recurse("./sources/{$tag}", true);
    insert_in_db($tag);
    echo "{$tag}\n";
}
// process PECL sources
foreach (get_pecl_releases_local() as $release) {
    preg_match('/^(.+)-(\\d+(?:\\.\\d+)+)$/S', $release, $m);
    $pkg = $m[1];
    $version = $m[2];
    // if it has an entry already, just skip it
    if (sqlite_single_query($idx, "SELECT COUNT(*) FROM pecl_changelog WHERE package='" . sqlite_escape_string($pkg) . "' AND version='{$version}'") > 0) {
        continue;
    }
    $array = $replace = array();
    recurse("./sources/{$release}", true);
    $sql = '';
    foreach ($array as $key => $data) {

示例#2

文件： funciones_cron.php 项目： ACSAUruguay/helpdesk

function operar($funcion, $json_decode, $id_cron, $fecha_cron, $errores)
{
    switch (trim($funcion)) {
        case 'crearTramite':
            try {
                insert_in_db($json_decode, $id_cron, $fecha_cron, $errores);
            } catch (syncCronException $e) {
                cambiar_estado($json_decode, $id_cron, 0, $e->getMessage());
            }
            break;
        default:
            break;
    }
}