PHP find_by_key示例

示例#1

文件： add_script.php 项目： xexys/first

    $_SESSION['add_form']['ShortName'] = $ShortName;
    $_SESSION['add_form']['FullName'] = $FullName;
    $_SESSION['add_form']['Email'] = $Email;
    $_SESSION['add_form']['WWW'] = $WWW;
    $_SESSION['add_form']['Object_ID'] = $Object_ID;
    $_SESSION['add_form']['Factory_ID'] = $Factory_ID;
    $_SESSION['add_form']['Area'] = $Area;
    $_SESSION['add_form']['Wokers'] = $Wokers;
    $_SESSION['add_form']['Production'] = $Production;
    $_SESSION['add_form']['Error'] = $Error;
    header("Location: add_form.php");
    die;
}
unset($_SESSION['add_form']);
// Поиск введенного значения в базе
$result = find_by_key($id_key);
if (mssql_num_rows($result) != 1) {
    echo "<h2>Неизвестная ошибка!!!</h2>";
    die;
}
echo "<h1>Запись добавлена!!!</h1>";
// Получаем данные из базы в массив $data.
for ($data = array(); $row = mssql_fetch_assoc($result); $data[] = $row) {
}
// Вывод карточки на экран в виде таблицы
view(trim($data[0]['shortname']), trim($data[0]['fullname']), trim($data[0]['email']), trim($data[0]['web']), trim($data[0]['object_value']), trim($data[0]['factory_value']), $data[0]['area'], $data[0]['wokers'], trim($data[0]['production']));
echo '<br>';
echo '<table width="550" border="0">';
echo '<tr>';
echo '   <td><form action="main.php"><input type=submit value="На главную"></form></td>';
echo '   <td><form action="edit_form.php"><input type=submit value="Изменить"></form></td>';

示例#2

文件： functions.php 项目： xexys/first

function convert2xml($id_key)
{
    $result = find_by_key($id_key);
    // Получаем данные из базы в массив $data.
    for ($data = array(); $row = mssql_fetch_assoc($result); $data[] = $row) {
    }
    $xml = '<?xml version="1.0" encoding="windows-1251" ?>' . "\r\n";
    $xml .= "<root>\r\n";
    for ($i = 0; $i < count($data); $i++) {
        $xml .= "  <row>\r\n";
        foreach ($data[0] as $key => $value) {
            $xml .= "    <{$key}>" . trim($value) . "</{$key}>\r\n";
        }
        $xml .= "  </row>\r\n";
    }
    $xml .= "</root>\r\n";
    return $xml;
}