14c04-2.php

来自「介绍PHP5的给类型函数应用」· PHP 代码 · 共 43 行

<?php
// Open the database connection
if (!($db = sybase_connect('servername', 'guest_user', 'secret'))) {
    // Handle errors
    die('SQL ERROR: Connection failed: ' . sybase_get_last_message());
}

// Now switch to the proper database:
if (!(sybase_select_db('dbname'))) {
    // Handle errors
    die('SQL ERROR: Database Selection failed: ' . 
        sybase_get_last_message());
}


// Prepare a SQL insert: assume we received the description from the user
$desc = 'Mortising Machine';
$escaped = str_replace("'", "''", $desc);
$sql = "insert into tools (desc, qty) values ('{$escaped}', 0)";

// Do the insertion:
if (!(sybase_query($sql))) {
    // Give an error statement:
    die('SQL INSERT ERROR: ' . sybase_get_last_message(). 
        " - Query was: {$sql}");
}

// Select data from the table:
$sql = 'select id, desc from tools order by id asc';
if (!($result = sybase_query($sql))) {
    // Give an error statement:
    die('SQL SELECT ERROR: ' . sybase_get_last_message(). 
        " - Query was: {$sql}");
}

// Read all the data back in as associative arrays
while ($row = sybase_fetch_assoc($result)) {
    echo "{$row['id']}. {$row['desc']}<br />\n";
}

// Now close the connection
sybase_close($db);
?>