PHP left_from示例

示例#1

文件： create_data.php 项目： ngduc/Thin-PHP-Framework

<?php
	include 'connect.php';
	$dbh = connect_DB() or die('Cannot connect to DB!');

	if ($arr = @file ('prepare_data.sql'))		// Do this if file exists
	{
		foreach ($arr as $line) $sql .= $line;
	}

	echo '<a href="create_tables.php">Recreate Tables</a><p/>';
	echo "<textarea cols=120 rows=20>$sql</textarea><p/>";
	
	$arr = explode (";", $sql);
	foreach ($arr as $query)
	{
		if (strlen($query) < 10) continue;
		
		$err = null;
		$cnt = $dbh->exec($query.';') or $err = $dbh->errorInfo();
		$queryName = left_from($query, '('); // ex: query = INSERT INTO `category` (...

		echo "$queryName - $cnt done! <span style='color: #f00'>$err[2]</span> <p/>";
	}
	$dbh = null;

示例#2

文件： create_tables.php 项目： renduples/alibtob

        $cnt++;
        if ($cnt == 1 && strpos($line, '# ') !== false) {
            continue;
        }
        // skip first line (UTF8 sign will break query)
        $sql .= $line;
    }
}
echo "<textarea cols=120 rows=20>{$sql}</textarea><p/>";
$arr = explode(";", $sql);
try {
    foreach ($arr as $query) {
        if (strlen($query) < 10) {
            continue;
        }
        $stmt = $dbh->prepare($query . ';');
        if (!$stmt) {
            $erri = $dbh->errorInfo();
        } else {
            $stmt->execute();
            //echo $stmt->debugDumpParams();
        }
        $queryName = left_from($query, '(') . ' - done!';
        // ex: query = CREATE TABLE `category` (...
        echo "{$queryName} <span style='color: #f00'>{$erri['2']}</span> <p/>";
    }
} catch (PDOException $e) {
    die('Error: ' . $e->getMessage());
}
$dbh = null;
echo "<br/>&nbsp;<br/><a href='create_data.php'>Create Data</a><p/>";

示例#3

文件： create_tables.php 项目： ngduc/Thin-PHP-Framework

			$sql .= $line;
		}
	}
	echo "<textarea cols=120 rows=20>$sql</textarea><p/>";

	$arr = explode (";", $sql);
	try {
		foreach ($arr as $query)
		{
			if (strlen($query) < 10) continue;

			$stmt = $dbh->prepare($query.';');
			if (!$stmt) {
			    $erri = $dbh->errorInfo();
			}
			else {
				$stmt->execute();
				//echo $stmt->debugDumpParams();
			}
			$queryName = left_from($query, '(').' - done!'; // ex: query = CREATE TABLE `category` (...	
			echo "$queryName <span style='color: #f00'>$erri[2]</span> <p/>";
		}
	}
	catch(PDOException $e)
	{
		die('Error: '.$e->getMessage());
	}
	$dbh = null;

	echo "<br/>&nbsp;<br/><a href='create_data.php'>Create Data</a><p/>";	

示例#4

文件： create_data.php 项目： renduples/alibtob

<?php

include 'connect.php';
$dbh = connect_DB() or die('Cannot connect to DB!');
if ($arr = @file('prepare_data.sql')) {
    foreach ($arr as $line) {
        $sql .= $line;
    }
}
echo '<a href="create_tables.php">Recreate Tables</a><p/>';
echo "<textarea cols=120 rows=20>{$sql}</textarea><p/>";
$arr = explode(";", $sql);
foreach ($arr as $query) {
    if (strlen($query) < 10) {
        continue;
    }
    $err = null;
    $cnt = $dbh->exec($query . ';') or $err = $dbh->errorInfo();
    $queryName = left_from($query, '(');
    // ex: query = INSERT INTO `category` (...
    echo "{$queryName} - {$cnt} done! <span style='color: #f00'>{$err['2']}</span> <p/>";
}
$dbh = null;