PHP mysql_Result Exemples

Exemple #1

Fichier : del_pic.php Projet : BackupTheBerlios/pic2base-svn

if ($_COOKIE['login']) {
    list($c_username) = preg_split('#,#', $_COOKIE['login']);
    //echo $c_username;
}
include '../../share/global_config.php';
include $sr . '/bin/share/db_connect1.php';
echo "\n<div class='page'>\n\n\t<p id='kopf'>pic2base :: L&ouml;sche Duplikat (User: {$c_username})</p>\n\t\n\t<div class='navi' style='clear:right;'>\n\t\t<div class='menucontainer'>\n\t\t</div>\n\t</div>\n\t\n\t<div class='content'>";
echo "L&ouml;sche Bild " . $pic_id . "<BR>";
//Ermittlung aller zugeh&ouml;rigen Bild-Dateien (Vorschau, HQ-Preview, rotiertes Bild, Original-Bild):
$result1 = mysql_query("SELECT * FROM {$table2} WHERE pic_id = '{$pic_id}'");
$num1 = mysql_num_rows($result1);
if ($num1 == '1') {
    $filenameori = mysql_Result($result1, $i1, 'FileNameOri');
    $filename = mysql_Result($result1, $i1, 'FileName');
    $filenamehq = mysql_Result($result1, $i1, 'FileNameHQ');
    $filenamev = mysql_Result($result1, $i1, 'FileNameV');
    //loeschen der Bild-Dateien:
    if (@unlink($pic_path . '/' . $filename)) {
        echo "Originalbild wurde gel&ouml;scht.<BR>";
    } else {
        echo "ACHTUNG! Das Originalbild konnte nicht gel&ouml;scht werden!<BR>";
    }
    if (@unlink($pic_rot_path . '/' . $filename)) {
        echo "Das rotierte Originalbild wurde gel&ouml;scht.<BR>";
    } else {
        echo "ACHTUNG! Das rotierte Originalbild konnte nicht gel&ouml;scht werden!<BR>";
    }
    if (@unlink($pic_thumbs_path . '/' . $filenamev)) {
        echo "Vorschaubild wurde gel&ouml;scht.<BR>";
    } else {
        echo "ACHTUNG! Das Vorschaubild konnte nicht gel&ouml;scht werden!<BR>";

Exemple #2

Fichier : reply.php Projet : samchon/timetable

<?php 
include "../../ConDB.php";
include "dbName.php";
$query = "SELECT fid, depth FROM {$dbName} WHERE uid='{$uid}'";
$Result = mysql_query($query, $ConDB);
$fid = mysql_Result($Result, 0, 0);
$depth = mysql_Result($Result, 0, 1);
mysql_free_Result($Result);
$query = "SELECT depth,right(depth,1) FROM {$dbName} WHERE fid = {$fid} AND length(depth) = length('{$depth}')+1 AND locate('{$depth}',depth) = 1 ORDER BY depth DESC LIMIT 1";
$Result = mysql_query($query, $ConDB);
$rows = mysql_num_rows($Result);
if ($rows) {
    $row = mysql_fetch_row($Result);
    $depth_head = substr($row[0], 0, -1);
    $depth_foot = ++$row[1];
    $new_depth = $depth_head . $depth_foot;
} else {
    $new_depth = $depth . "A";
}
$id = addslashes($id);
$writer = addslashes($writer);
$subject = addslashes($subject);
$memo = addslashes($memo);
$query = "INSERT INTO {$dbName} VALUES ('', '{$fid}', '{$sort}', '{$id}', '{$writer}', '{$subject}', '{$memo}', '{$ip}', '{$signdate}', '0', '{$new_depth}')";
$Result = mysql_query($query, $ConDB);
if ($Result) {
    $res = "ok";
} else {
    $res = "fail";
}
echo "Dummy=1&res={$res}";