當前位置: 首頁>>代碼示例>>PHP>>正文


PHP MYSQL_FETCH_ARRAY函數代碼示例

本文整理匯總了PHP中MYSQL_FETCH_ARRAY函數的典型用法代碼示例。如果您正苦於以下問題:PHP MYSQL_FETCH_ARRAY函數的具體用法?PHP MYSQL_FETCH_ARRAY怎麽用?PHP MYSQL_FETCH_ARRAY使用的例子?那麽, 這裏精選的函數代碼示例或許可以為您提供幫助。


在下文中一共展示了MYSQL_FETCH_ARRAY函數的15個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。

示例1: sendLoginDetails

 function sendLoginDetails($email)
 {
     global $sitename;
     global $logo;
     $query = MYSQL_QUERY("SELECT `Username`,`Password` FROM `ChallengeMembers` WHERE `Email` = '" . $email . "' ") or die(MYSQL_ERROR());
     if ($query) {
         if (MYSQL_NUM_ROWS($query)) {
             while ($row = MYSQL_FETCH_ARRAY($query)) {
                 $userpassword = $row['Password'];
                 $username = $row['Username'];
             }
             /*send email*/
             include 'email_class.php';
             $em = new EmailTemplate();
             $subject = ucfirst($sitename) . " Login Details";
             $headers = "From: " . ucwords($sitename) . " <admin@domaindirectory.com> \r\n" . 'X-Mailer: PHP/' . phpversion();
             $headers .= 'MIME-Version: 1.0' . "\r\n";
             $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
             $email_message = $username . ",<br /><br /> Thank you for your interest in joining our challenges.\n\t\t\t\t\t\t\t\t\t<br /><br />\n\t\t\t\t\t\t\t\t\tThe following are your login data:\n\t\t\t\t\t\t\t\t\t<br>\n\t\t\t\t\t\t\t\t\tUsername : <b>" . $username . "</b><br />\n\t\t\t\t\t\t\t\t\tPassword : <b>" . $userpassword . "</b>\n\t\t\t\t\t\t\t\t\t<br /><br />\n\t\t\t\t\t\t\t\t\tThank you.<br />\n\t\t\t\t\t\t\t\t\t<b>" . $sitename . "</b>";
             $emailmessage = $em->get($logo, $sitename, $email_message);
             /*first send to guest */
             $sentmail = mail($email, $subject, $emailmessage, $headers);
             /*end of send email*/
             return "OK";
         } else {
             return $email . "not found in database.";
         }
     } else {
         return "Email not found in database.";
     }
 }
開發者ID:AleemDev,項目名稱:OpenSource,代碼行數:31,代碼來源:login_function.php

示例2: set_addition

 function set_addition($class, $classid, $column, $value)
 {
     $queryaddition = MYSQL_QUERY("SELECT classid FROM flobase_addition WHERE class='{$class}' AND classid='" . mysql_real_escape_string($classid) . "'");
     if (!($addition = MYSQL_FETCH_ARRAY($queryaddition))) {
         return MYSQL_QUERY("INSERT INTO flobase_addition (class, classid, {$column}) VALUES('{$class}', '" . mysql_real_escape_string($classid) . "', '" . mysql_real_escape_string($value) . "')");
     }
     return MYSQL_QUERY("UPDATE flobase_addition SET {$column}='" . mysql_real_escape_string($value) . "' WHERE class='{$class}' AND classid='" . mysql_real_escape_string($classid) . "'");
 }
開發者ID:Rellfy,項目名稱:florensia-base,代碼行數:8,代碼來源:class_addition.php

示例3: signencode

function signencode($sign)
{
    MYSQL_QUERY("CREATE TABLE IF NOT EXISTS `cache_languagesigns` (\n\t\t`id` int(11) NOT NULL auto_increment,\n\t\t`signs` text NOT NULL,\n\t\tPRIMARY KEY  (`id`)\n\t\t)");
    MYSQL_QUERY("INSERT INTO cache_languagesigns (signs) VALUES('" . mysql_real_escape_string($sign) . "')");
    $signs = MYSQL_FETCH_ARRAY(MYSQL_QUERY("SELECT signs FROM cache_languagesigns ORDER BY id DESC LIMIT 1"));
    MYSQL_QUERY("TRUNCATE TABLE cache_languagesigns");
    return $signs['signs'];
}
開發者ID:Rellfy,項目名稱:florensia-base,代碼行數:8,代碼來源:adminlang_backup.php

示例4: getTotalMonetarySponsorship

	function getTotalMonetarySponsorship($challenger_id){
		$total_sponsorship = 0;
		$query = MYSQL_QUERY("SELECT SUM(Amount) AS total_sponsorship FROM SponsorContact WHERE SponsorId = '".$challenger_id."'");
			if($row = MYSQL_FETCH_ARRAY($query)){
				$total_sponsorship = $row['total_sponsorship'];
			}
		return $total_sponsorship;
	}
開發者ID:AleemDev,項目名稱:OpenSource,代碼行數:8,代碼來源:profile_function.php

示例5: get_valid_languages

 function get_valid_languages()
 {
     global $florensia;
     $queryquesttexttables = MYSQL_QUERY("SHOW TABLES FROM {$florensia->dbname} LIKE 'server_questtext_%'");
     while ($questtexttables = MYSQL_FETCH_ARRAY($queryquesttexttables)) {
         //if (strtr($questtexttables[0], array('server_questtext_'=>''))=="TR") continue;
         $this->languagearray[strtr($questtexttables[0], array('server_questtext_' => ''))] = strtr($questtexttables[0], array('server_questtext_' => ''));
     }
 }
開發者ID:Rellfy,項目名稱:florensia-base,代碼行數:9,代碼來源:class_questtext.php

示例6: displayCollapseListKeyed

function displayCollapseListKeyed($id = '0', $idFull = '0', $note = null, $pageName = 'main', $key = null, $htmlXtra = null)
{
    // Find this $key object
    $sql = "SELECT *, objects.id AS objectsId FROM wires, objects ";
    $sql .= "WHERE wires.fromid = {$id} AND wires.toid = objects.id ";
    $sql .= "AND objects.name1 LIKE '{$key}' ";
    $sql .= "AND wires.active=1 AND objects.active=1 ";
    $sql .= "LIMIT 1";
    $result = MYSQL_QUERY($sql);
    // Find connected objects
    if ($myrow = MYSQL_FETCH_ARRAY($result)) {
        $foundObjectId = $myrow['objectsId'];
        $sql = "SELECT *, objects.id AS objectsId FROM wires, objects ";
        $sql .= "WHERE wires.fromid = {$foundObjectId} AND wires.toid = objects.id ";
        $sql .= "AND wires.active=1 AND objects.active=1 ";
        $sql .= "ORDER BY rank ASC";
        $result = MYSQL_QUERY($sql);
        // Output collapseList
        $i = 0;
        $notes = explode(",", $note);
        echo "\n\t<!-- collapseList -->";
        echo "\n\n\t<ul class = 'ieFix'>";
        while ($myrow = MYSQL_FETCH_ARRAY($result)) {
            $name = $myrow["name1"];
            if (substr($name, 0, 1) != "." && substr($name, 0, 1) != "_") {
                for ($ii = 0; $ii < count($notes); $ii++) {
                    if ($notes[$ii] == $myrow['objectsId']) {
                        $notesOut[$ii] = null;
                    } else {
                        $notesOut[$ii] = $notes[$ii];
                    }
                }
                $notesOutFiltered = array_filter($notesOut);
                $noteOut = implode(",", $notesOutFiltered);
                $noteOutStub = $noteOut ? $noteOut . "," : "";
                echo in_array($myrow['objectsId'], $notes) ? "\n\t\t<li class = 'collapseListOpen'>\n\t\t\t\t\t\t\t- <a href='" . $pageName . ".html?id=" . $idFull . "&amp;note=" . $noteOut . "'>" . $myrow["name1"] . "</a>" : "\n\t\t<li class = 'collapseListClosed'>\n\t\t\t\t\t\t\t+ <a href='" . $pageName . ".html?id=" . $idFull . "&amp;note=" . $noteOutStub . $myrow['objectsId'] . "'>" . $myrow["name1"] . "</a>";
                if ($htmlXtra) {
                    // Hack for Objectif
                    // $htmlXtra  = "Download the complete <a href='MEDIA/PDF/Deball.pdf' target='_new'>PDF here</a>.<br/>";
                    $htmlXtra = "Download the <a href=\"javascript: windowPop('" . $myrow['url'] . "','poppdf', '450', '550')\">PDF</a>.<br/>";
                    $htmlXtra .= "View the <a href=\"javascript: windowPop('popimage.html?id=" . $myrow['objectsId'] . "','popimage', '800', '533')\">installation images</a>.<br/>";
                    $htmlXtra .= "Read the <a href=\"javascript: windowPop('poptext.html?id=" . $myrow['objectsId'] . "','poptext', '450', '800')\">exhibition text</a>.<br/><br/>";
                    //echo "\n	<br /><br />".$myrow["deck"]."<br/>" . $htmlXtra . "</li>";
                    echo nl2br("\n\t<br />" . $myrow["deck"] . "<br/><br />" . $htmlXtra . "</li>");
                    // End hack
                } else {
                    echo nl2br("\n\t<br />" . $myrow["deck"] . "<br/><br /></li>");
                }
                $i++;
            }
        }
        echo "\n\t</ul>";
    }
}
開發者ID:reinfurt,項目名稱:MOLLYS,代碼行數:54,代碼來源:displayCollapseListKeyed.php

示例7: CheckIfVerified

 function CheckIfVerified($code)
 {
     $query = MYSQL_QUERY("SELECT `ChallengeMemberId` FROM `ChallengeMembers` WHERE VerificationCode = '" . $code . "' ") or die(MYSQL_ERROR());
     if (MYSQL_NUM_ROWS($query) > 0) {
         while ($row = MYSQL_FETCH_ARRAY($query)) {
             $member_id = $row['ChallengeMemberId'];
             $result = MYSQL_QUERY("UPDATE `ChallengeMembers` SET `Verified` = '1' WHERE `ChallengeMemberId` = '" . $member_id . "' ") or die(MYSQL_ERROR());
         }
         return true;
     } else {
         return false;
     }
 }
開發者ID:AleemDev,項目名稱:OpenSource,代碼行數:13,代碼來源:register_function.php

示例8: systemCommand

function systemCommand()
{
    //  Get ".System" object
    $sql = "SELECT objects.id AS objectsId FROM wires, objects ";
    $sql .= "WHERE wires.fromid = 0 AND wires.toid = objects.id AND objects.name1 LIKE '.System' ";
    $sql .= "AND wires.active = 1 AND objects.active = 1 ";
    $sql .= "ORDER BY objects.modified DESC LIMIT 1";
    $res = MYSQL_QUERY($sql);
    $row = MYSQL_FETCH_ARRAY($res);
    global $systemObjectId;
    $systemObjectId = $row["objectsId"];
    //  Get "documentBase"
    $sql = "SELECT * FROM wires, objects ";
    $sql .= "WHERE wires.fromid = {$systemObjectId} AND wires.toid = objects.id AND objects.name1 LIKE 'documentBase' ";
    $sql .= "AND wires.active = 1 AND objects.active = 1 ";
    $sql .= "ORDER BY objects.modified DESC LIMIT 1";
    $res = MYSQL_QUERY($sql);
    $row = MYSQL_FETCH_ARRAY($res);
    global $documentBase;
    $documentBase = $row['body'];
    // echo $documentBase;
    //  Establish page
    global $pageName;
    $pageName = basename($PHP_SELF, ".html");
    if (!$pageName) {
        $pageName = "index";
    }
    //  Set document title
    global $documentTitle;
    $documentTitle = $documentTitle ? $documentBase . " | " . $documentTitle : $documentBase;
    //  Parse object commands
    global $objects;
    global $object;
    global $id;
    $objects = explode(",", $id);
    $object = $objects[sizeof($objects) - 1];
    if (!$object) {
        $object = 0;
    }
    if (sizeof($objects) == 1 && empty($objects[sizeof($objects) - 1])) {
        unset($objects);
    }
}
開發者ID:reinfurt,項目名稱:MOLLYS,代碼行數:43,代碼來源:systemCommand.php

示例9: exportfile

 function exportfile($filename, $langid)
 {
     global $florensia;
     $langfile = $florensia->language_abs . "/{$langid}/{$filename}.lang.php";
     if (!rename($langfile, $langfile . '_backup_' . date("Y.m.d-H.i.s"))) {
         $florensia->notice("Cannot rename old file for backup. Please verify your chmod settings!", "warning");
         return false;
     }
     if (!($newfile = fopen($langfile, 'a'))) {
         $florensia->notice("Cannot create new file. Please verify your chmod settings!", "warning");
         return false;
     }
     $newlangfile = new SimpleXMLElement("<{$filename} createdate=\"" . date("Y-m-d H:i:s / U") . "\"></{$filename}>");
     $querylangvar = MYSQL_QUERY("SELECT varname, lang_{$langid} FROM flobase_languagefiles WHERE filename='" . mysql_real_escape_string($filename) . "'");
     while ($langvar = MYSQL_FETCH_ARRAY($querylangvar)) {
         $newlangfile->{$langvar}['varname'] = $langvar['lang_' . $langid];
     }
     $newlangfile->asXML($langfile);
     $florensia->notice("Language file and backup for {$langid}/{$filename} successfully created", "successful");
     return true;
 }
開發者ID:Rellfy,項目名稱:florensia-base,代碼行數:21,代碼來源:class_lang.php

示例10: displayCollapseList

function displayCollapseList($id = '0', $idFull = '0', $note = null, $pageName = 'main')
{
    // Find this .Notes object
    $sql = "SELECT *, objects.id AS objectsId FROM wires, objects ";
    $sql .= "WHERE wires.fromid = {$id} AND wires.toid = objects.id ";
    $sql .= "AND objects.name1 LIKE '.Notes' ";
    $sql .= "AND wires.active=1 AND objects.active=1 ";
    $sql .= "LIMIT 1";
    $result = MYSQL_QUERY($sql);
    // Find connected objects
    if ($myrow = MYSQL_FETCH_ARRAY($result)) {
        $foundObjectId = $myrow['objectsId'];
        $sql = "SELECT *, objects.id AS objectsId FROM wires, objects ";
        $sql .= "WHERE wires.fromid = {$foundObjectId} AND wires.toid = objects.id ";
        $sql .= "AND wires.active=1 AND objects.active=1 ";
        $sql .= "ORDER BY rank ASC";
        $result = MYSQL_QUERY($sql);
        // Output collapseList
        $i = 0;
        $notes = explode(",", $note);
        echo "\n\t<!-- collapseList -->";
        echo "\n\n\t<ul class = 'ieFix'>";
        while ($myrow = MYSQL_FETCH_ARRAY($result)) {
            for ($ii = 0; $ii < count($notes); $ii++) {
                if ($notes[$ii] == $myrow['objectsId']) {
                    $notesOut[$ii] = null;
                } else {
                    $notesOut[$ii] = $notes[$ii];
                }
            }
            $notesOutFiltered = array_filter($notesOut);
            $noteOut = implode(",", $notesOutFiltered);
            $noteOutStub = $noteOut ? $noteOut . "," : "";
            echo in_array($myrow['objectsId'], $notes) ? "\n\t\t<li class = 'collapseListOpen'>\n\t\t\t\t\t\t- <a href='" . $pageName . ".html?id=" . $idFull . "&amp;note=" . $noteOut . "'>" . $myrow["name1"] . "</a>" : "\n\t\t<li class = 'collapseListClosed'>\n\t\t\t\t\t\t+ <a href='" . $pageName . ".html?id=" . $idFull . "&amp;note=" . $noteOutStub . $myrow['objectsId'] . "'>" . $myrow["name1"] . "</a>";
            echo "\n\t<br /><br />" . $myrow["body"] . "<br/></li>";
            $i++;
        }
        echo "\n\t</ul>";
    }
}
開發者ID:reinfurt,項目名稱:MOLLYS,代碼行數:40,代碼來源:displayCollapseList.php

示例11: get_maplist_source

 function get_maplist_source($parentmap = "init", $substring = FALSE)
 {
     global $flocache;
     if ($parentmap == "init") {
         $parentmapquery = MYSQL_QUERY("SELECT mappicture, LTWH, mapid FROM server_map WHERE parentmap=''");
     } else {
         $parentmapquery = MYSQL_QUERY("SELECT mappicture, LTWH, mapid FROM server_map WHERE parentmap='{$parentmap}'");
     }
     while ($map = MYSQL_FETCH_ARRAY($parentmapquery)) {
         if ($map['mapid'] == "BARRACK_000" or $map['mapid'] == "XC0_DK_000" or $map['mapid'] == "DOCK_000" or $map['mapid'] == "LOGIN_000") {
             continue;
         }
         if (!$substring) {
             $cachesubstring = $map['mapid'];
         } else {
             $cachesubstring = "{$substring},submaps,{$map['mapid']}";
         }
         $flocache->write_cache("maplist,{$cachesubstring},mapid", $map['mapid']);
         $flocache->write_cache("maplist,{$cachesubstring},mappicture", $map['mappicture']);
         $flocache->write_cache("maplist,{$cachesubstring},LTWH", $map['LTWH']);
         $trashvar = $this->get_maplist_source($map['mapid'], $cachesubstring);
     }
 }
開發者ID:Rellfy,項目名稱:florensia-base,代碼行數:23,代碼來源:class_misc.php

示例12: unset

     $tabbar['droplist']['desc'] = $classdroplist->get_tabdesc($item->data[$florensia->get_columnname("itemid", "item")], "item");
 } else {
     unset($tabbar['droplist']);
 }
 //usernotes
 $usernotes = $classusernote->display($item->data[$florensia->get_columnname("itemid", "item")], "item");
 $tabbar['usernotes']['desc'] = $classusernote->get_tabdesc($item->data[$florensia->get_columnname("itemid", "item")], "item");
 //market
 //set var first because add/delete is performed while functions run. so it need to runs first
 $marketquickform = $classusermarket->quickform($item->data[$florensia->get_columnname("itemid", "item")]);
 $sellers = 0;
 $buyers = 0;
 $querytradelist = MYSQL_QUERY("SELECT userid, createtime, charname, timeout, itemid, itemamount, server, exchangetype, exchange, exchangegelt, marketlanguage FROM flobase_usermarket as m, flobase_character as c WHERE itemid='" . mysql_real_escape_string($item->data[$florensia->get_columnname("itemid", "item")]) . "' AND m.characterid=c.characterid ORDER BY createtime");
 while ($tradelist = MYSQL_FETCH_ARRAY($querytradelist)) {
     $queryforumuser = MYSQL_QUERY("SELECT username FROM forum_users WHERE uid='" . $tradelist['userid'] . "'");
     if (!($forumuser = MYSQL_FETCH_ARRAY($queryforumuser))) {
         continue;
     }
     unset($marketlanguage);
     $marketlanguagelist = explode(",", $tradelist['marketlanguage']);
     foreach ($marketlanguagelist as $languageid) {
         $marketlanguage .= "<img src='{$florensia->layer_rel}/flags/png/" . $flolang->lang[$languageid]->flagid . ".png' alt='" . $flolang->lang[$languageid]->languagename . "' title='" . $flolang->lang[$languageid]->languagename . "' border='0'> ";
     }
     if ($tradelist['exchange'] != "") {
         $tradelist['exchange'] = "<tr><td>{$flolang->market_details_info_exchange}</td><td>" . $parser->parse_message($tradelist['exchange'], array("allow_mycode" => 1, "filter_badwords" => 1)) . "</td></tr>";
     } else {
         unset($tradelist['exchange']);
     }
     if ($tradelist['exchangegelt']) {
         $tradelist['exchangegelt'] = "<tr><td>Gelt:</td><td>" . get_geltstring($tradelist['exchangegelt'], $tradelist['itemamount']) . " Gelt</td></tr>";
     } else {
開發者ID:Rellfy,項目名稱:florensia-base,代碼行數:31,代碼來源:items.php

示例13: write

                    $details[$columns['code_korean']] = $details[$columns['code_korean']] * 100;
                    $write = write($columns['name_' . $flolang->language], $details[$columns['code_korean']] . $columns['endvalue'], $columns['code_english']);
                    break;
                default:
                    $write = write($columns['name_' . $flolang->language], $details[$columns['code_korean']] . $columns['endvalue'], $columns['code_english']);
                    break;
            }
        }
    }
    //Additional infos for skillbooks
    if (isset($itemtable['tableid']) && $itemtable['tableid'] == "skillbookitem") {
        //for ($i=1; $i<3; $i++) {
        //	if ($i==1) $querydescription = MYSQL_QUERY("SELECT * FROM server_skill WHERE ".$florensia->get_columnname("bookid", "skill")."='".$details[$florensia->get_columnname("description", "item")]."' ORDER BY ".$florensia->get_columnname("skillid", "skill")."");
        //	else $querydescription = MYSQL_QUERY("SELECT * FROM server_spell WHERE ".$florensia->get_columnname("bookid", "skill")."='".$details[$florensia->get_columnname("description", "item")]."' ORDER BY ".$florensia->get_columnname("skillid", "skill")."");
        $querydescription = MYSQL_QUERY("SELECT " . $florensia->get_columnname("masterlevel", "skill") . "," . $florensia->get_columnname("classid", "skill") . " FROM server_skill WHERE " . $florensia->get_columnname("bookid", "skill") . "='" . $details[$florensia->get_columnname("description", "item")] . "' ORDER BY " . $florensia->get_columnname("skillid", "skill") . "");
        if ($description = MYSQL_FETCH_ARRAY($querydescription)) {
            foreach ($florensia->get_classname($description[$florensia->get_columnname("classid", "skill")], "land") as $key => $classid) {
                $write = write("Class", $classid, "skillclass");
            }
            foreach ($florensia->get_classname($description[$florensia->get_columnname("classid", "skill")], "sea") as $key => $classid) {
                $write = write("Class", $classid, "skillclass");
            }
            $write = write("Max. Level", $description[$florensia->get_columnname("masterlevel", "skill")], "skillmasterlevel");
            //break;
        }
        //}
    }
} else {
    $columnall_y += $steps;
    $column['Error'] = "Error: No details were found.";
}
開發者ID:Rellfy,項目名稱:florensia-base,代碼行數:31,代碼來源:detailsprotection.php

示例14: MYSQL_QUERY

    } else {
        // No, retrieve discreet information
        $sql = "SELECT * \n\t\t\t\tFROM objects \n\t\t\t\tWHERE \n\t\t\t\t\tobjects.id = {$object} AND \n\t\t\t\t\tobjects.active = 1 \n\t\t\t\tLIMIT 1;";
        $result = MYSQL_QUERY($sql);
    }
    // Display table format
    $html = "<table cellpadding='10' border='1' width='900px'>";
    // Column headers
    $html .= "<tr style='background-color:#CCCCCC;'>";
    $html .= "<td width='200px'>NAME</td>";
    $html .= "<td width='300px'>ADDRESS</td>";
    $html .= "<td width='300px'>EMAIL</td>";
    $html .= "<td width='100px'>BEGIN / END</td>";
    $html .= "</tr>";
    // Data
    while ($myrow = MYSQL_FETCH_ARRAY($result)) {
        $html .= "<tr style='background-color:#" . ($rowcolor % 2 ? "E9E9E9" : "EFEFEF") . ";'>";
        $html .= "<td>" . $myrow['name1'] . " " . $myrow['name2'] . "</td>";
        $html .= "<td>" . $myrow['address1'] . "<br />" . $myrow['city'] . " " . $myrow['state'] . " " . $myrow['zip'] . "<br />" . $myrow['country'] . "</td>";
        $html .= "<td>" . $myrow['email'] . "</td>";
        $html .= "<td>" . date("Y M j", strToTime($myrow['begin'])) . "<br />" . date("Y M j", strToTime($myrow['end'])) . "</td>";
        $html .= "</tr>";
        $rowcolor++;
        $rownumber++;
    }
    $html .= "</table>";
    $html .= "<br />{$rownumber} total results found.";
    echo $html;
}
echo "<br /><br />";
if ($report) {
開發者ID:O-R-G,項目名稱:o-r-g.com,代碼行數:31,代碼來源:report_.php

示例15: mktime

}
if (!$flouser->get_permission("access_admincp") or !$flouser->get_permission("mod_changelog")) {
    $florensia->output_page($flouser->noaccess());
}
$florensia->sitetitle("AdminCP");
$florensia->sitetitle("Version History");
$historylimit = 5;
if ($_POST['create_history']) {
    $createtime = mktime(0, 0, 0, $_POST['new_create_month'], $_POST['new_create_day'], $_POST['new_create_year']);
    MYSQL_QUERY("INSERT INTO flobase_versionhistory (date, changes) VALUES('{$createtime}', '" . mysql_real_escape_string($_POST['new_changes']) . "')");
} elseif ($_POST['update_history']) {
    $queryhistory = MYSQL_QUERY("SELECT id FROM flobase_versionhistory ORDER BY date DESC, id DESC LIMIT {$historylimit}");
    while ($history = MYSQL_FETCH_ARRAY($queryhistory)) {
        $updatetime = mktime(0, 0, 0, $_POST[$history['id'] . '_create_month'], $_POST[$history['id'] . '_create_day'], $_POST[$history['id'] . '_create_year']);
        MYSQL_QUERY("UPDATE flobase_versionhistory SET date='{$updatetime}', changes='" . mysql_real_escape_string($_POST[$history['id'] . '_changes']) . "' WHERE id='" . $history['id'] . "'");
    }
} elseif ($_POST['delete_history']) {
    $queryhistory = MYSQL_QUERY("SELECT id FROM flobase_versionhistory ORDER BY date DESC, id DESC LIMIT {$historylimit}");
    while ($history = MYSQL_FETCH_ARRAY($queryhistory)) {
        if ($_POST[$history['id'] . '_delete'] != 1) {
            continue;
        }
        MYSQL_QUERY("DELETE FROM flobase_versionhistory WHERE id='" . $history['id'] . "'");
    }
}
$queryhistory = MYSQL_QUERY("SELECT id, date, changes FROM flobase_versionhistory ORDER BY date DESC, id DESC LIMIT {$historylimit}");
while ($history = MYSQL_FETCH_ARRAY($queryhistory)) {
    $historylist .= "\n\t\t<div class='shortinfo_" . $florensia->change() . "' style='margin-bottom:15px;'>\n\t\t\t<table style='width:100%;'>\n\t\t\t\t<tr><td style='font-weight:bold; border-bottom:1px solid;'><input type='text' name='{$history['id']}_create_month' value='" . date("m", $history['date']) . "' maxlength='2' style='width:20px'>.<input type='text' name='{$history['id']}_create_day' value='" . date("d", $history['date']) . "' maxlength='2' style='width:20px'>.<input type='text' name='{$history['id']}_create_year' value='" . date("Y", $history['date']) . "' maxlength='4' style='width:30px'></td><td style='text-align:right; border-bottom:1px solid;'><input type='checkbox' name='{$history['id']}_delete' value='1'><input type='submit' name='delete_history' value='Delete selected versions'><input type='submit' name='update_history' value='Update all versions'></td></tr>\n\t\t\t\t<tr><td style='height:7px' colspan='2'></td></tr>\n\t\t\t\t<tr><td class='small' colspan='2'><textarea name='{$history['id']}_changes' style='width:100%; height:200px;'>" . $florensia->escape($history['changes']) . "</textarea></td></tr>\n\t\t\t</table>\n\t\t</div>\n\t";
}
$content = "\n<form action='{$florensia->root}/adminhistory.php' method='post'>\n\t\t<div class='subtitle' style='margin-bottom:15px;'>\n\t\t\t<table style='width:100%;'>\n\t\t\t\t<tr><td style='font-weight:bold; border-bottom:1px solid;'><input type='text' name='new_create_month' value='" . date("m") . "' maxlength='2' style='width:20px'>.<input type='text' name='new_create_day' maxlength='2' value='" . date("d") . "' style='width:20px'>.<input type='text' name='new_create_year' value='" . date("Y") . "' maxlength='4' style='width:30px'></td><td style='text-align:right; border-bottom:1px solid;'><input type='submit' name='create_history' value='Create new version'></td></tr>\n\t\t\t\t<tr><td style='height:7px' colspan='2'></td></tr>\n\t\t\t\t<tr><td class='small' colspan='2'><textarea name='new_changes' style='width:100%; height:200px;'></textarea></td></tr>\n\t\t\t</table>\n\t\t</div>\n{$historylist}\n</form>\n";
$florensia->output_page($content);
開發者ID:Rellfy,項目名稱:florensia-base,代碼行數:31,代碼來源:adminhistory.php


注:本文中的MYSQL_FETCH_ARRAY函數示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台,相關代碼片段篩選自各路編程大神貢獻的開源項目,源碼版權歸原作者所有,傳播和使用請參考對應項目的License;未經允許,請勿轉載。