本文整理汇总了PHP中mysql_db_query函数的典型用法代码示例。如果您正苦于以下问题:PHP mysql_db_query函数的具体用法?PHP mysql_db_query怎么用?PHP mysql_db_query使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_db_query函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: dbQuery
** description : execute la requete et gere les cas d'erreur
*/
function dbQuery($requete)
{
global $db;
$res = mysql_db_query($db['name'], $requete);
if (!$res) {
print $requete;
die("problème d'acces à la base de données dbQuery " . $requete . " \n" . mysql_error());
}
开发者ID:BackupTheBerlios,项目名称:sitebe-svn,代码行数:10,代码来源:database.inc.php
示例2: getSolution
function getSolution($pid)
{
$ret = "";
require "../include/const.inc.php";
require "../include/db_info.inc.php";
$con = mysql_connect($DB_HOST, $DB_USER, $DB_PASS);
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_db_query($DB_NAME, "set names utf8", $con);
mysql_set_charset("utf8", $con);
mysql_select_db($DB_NAME, $con);
$sql = "select `solution_id`,`language` from solution where problem_id={$pid} and result=4 order by language";
// echo $sql;
$result = mysql_db_query($DB_NAME, $sql, $con);
if ($result && ($row = mysql_fetch_row($result))) {
$solution_id = $row[0];
$language = $language_name[$row[1]];
echo $language;
mysql_free_result($result);
$sql = "select source from source_code where solution_id={$solution_id}";
$result = mysql_query($sql) or die(mysql_error());
if ($row = mysql_fetch_object($result)) {
$ret = $row->source;
}
mysql_free_result($result);
}
mysql_close($con);
return $ret;
}
开发者ID:RX78NY1,项目名称:hustoj,代码行数:30,代码来源:problem_export_xml.php
示例3: __construct
public function __construct($dbname)
{
$this->mysqli = new mysqli($this->dblocation, 'root', '', $dbname);
if (!$this->mysqli) {
die('Error connection: ' . mysql_error());
} else {
//echo 'Suecces conection';
}
if (!mysqli_select_db($this->mysqli, $dbname)) {
if (mysql_query("CREATE DATABASE " . $dbname)) {
echo '<br> BD ' . $dbname . ' create success';
}
$sql = "CREATE TABLE MyGuests (\r\n id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\r\n title VARCHAR(100) NOT NULL,\r\n category INT(100),\r\n description VARCHAR(150),\r\n source VARCHAR(50),\r\n datetime TIMESTAMP\r\n )";
if (mysql_db_query($dbname, $sql)) {
echo '<br> BD MyGuests success create';
}
$sql = "CREATE TABLE category (\r\n id INT(6),\r\n name VARCHAR(100)\r\n )";
if (mysql_db_query($dbname, $sql)) {
echo '<br> BD category success create';
}
$sql = "INSERT INTO category(id, name)\r\n VALUES\r\n (1, 'Politics'),\r\n (2, 'Culture'),\r\n (3, 'Sport')";
if (mysql_db_query($dbname, $sql)) {
echo '<br> BD category insert success';
}
} else {
//echo '<br> БД существует';
}
}
开发者ID:Arxemond777,项目名称:News,代码行数:28,代码来源:NewsDB.class.php
示例4: get_content
function get_content($database, $table, $fp)
{
// get content of data
global $delimiter;
$result = mysql_db_query($database, "SELECT * FROM {$table}") or die("Cannot get content of table");
while ($row = mysql_fetch_row($result)) {
$insert = "INSERT INTO {$table} VALUES (";
// command for later SQL-restore
for ($j = 0; $j < mysql_num_fields($result); $j++) {
// content for later SQL-restore
if (!isset($row[$j])) {
$insert .= "NULL,";
} elseif (isset($row[$j])) {
$insert .= "'" . addslashes($row[$j]) . "',";
} else {
$insert .= "'',";
}
}
$insert = ereg_replace(",\$", "", $insert);
$insert .= "){$delimiter}\n";
// create row delimiter
gzwrite($fp, $insert);
// now write the complete content into backup file
}
gzwrite($fp, "\n\n");
mysql_free_result($result);
}
开发者ID:pwh,项目名称:scrutiny,代码行数:27,代码来源:db_backup.php
示例5: da_sql_query
function da_sql_query($link, $config, $query)
{
if ($config[sql_debug] == 'true') {
print "<b>DEBUG(SQL,MYSQL DRIVER): Query: <i>{$query}</i></b><br>\n";
}
return @mysql_db_query($config[sql_database], $query, $link);
}
开发者ID:greendev5,项目名称:freeradius-server-wasel,代码行数:7,代码来源:functions.php
示例6: dbQuery
public function dbQuery($sql)
{
//test sql
$this->sql = $sql;
$this->queryResult = mysql_db_query($this->db, $this->sql, $this->connection);
return $queryResult;
}
开发者ID:HollenMok,项目名称:pandoraf_v1.0,代码行数:7,代码来源:mysql.php
示例7: do_xml
function do_xml()
{
$_str = $_str_temp = '';
// коннектимся
f_mysql_connect();
// выбираем
$result = mysql_db_query($GLOBALS["dbname"], "SELECT * FROM news where status=1 order by id desc limit " . ___findpole("select zna from config where id=9", 'zna'));
// формируем все новости
$name_file = '/rss/all.xml';
for ($i = 0; $i < mysql_numrows($result); $i++) {
$find = mysql_fetch_array($result);
// елементы для замены
$mass_element_for_parsing = array("%zag%", "%link%", "%text%", "%date%");
// заменяеміе значения
$mass_result_for_parsing = array($find['zag'], MAIN_PATH . "/news/idnews/" . $find['id'] . '/type/' . $find['type'], strip_tags(htmlspecialchars(substr($find['text'], 0, 150))), $find['date']);
// парсим данные
$_str_temp = parsing_tpl($name_file, $mass_element_for_parsing, $mass_result_for_parsing, $_str_temp);
}
// основной шаблон
$name_file = '/rss/template.xml';
// елементы для замены
$mass_element_for_parsing = array("%zag%", "%www%", "%tegs%");
// заменяеміе значения
$mass_result_for_parsing = array(iconv('CP1251', 'UTF-8', 'Новости'), iconv('CP1251', 'UTF-8', ADRESS_SITE), iconv('CP1251', 'UTF-8', $_str_temp));
// парсим данные
$_str = parsing_tpl($name_file, $mass_element_for_parsing, $mass_result_for_parsing, $_str);
write_keh(HOST . '/rss/ru.xml', $_str);
}
开发者ID:AngelWayfarer,项目名称:prizvanie,代码行数:28,代码来源:xml.class.php
示例8: send_sql
function send_sql($db, $sql) {
if (! $res=mysql_db_query($db, $sql)) {
echo mysql_error();
exit;
}
return $res;
}
开发者ID:uChoh5fe,项目名称:myScripts,代码行数:7,代码来源:connect.php
示例9: get_table_content
function get_table_content($db, $table, $handler)
{
$result = mysql_db_query($db, "SELECT * FROM {$table}") or mysql_die();
$i = 0;
while ($row = mysql_fetch_row($result)) {
$table_list = "(";
for ($j = 0; $j < mysql_num_fields($result); $j++) {
$table_list .= mysql_field_name($result, $j) . ",";
}
$table_list = substr($table_list, 0, -2);
$table_list .= ")";
if (isset($GLOBALS["showcolumns"])) {
$schema_insert = "INSERT INTO {$table} {$table_list} VALUES (";
} else {
$schema_insert = "INSERT INTO {$table} VALUES (";
}
for ($j = 0; $j < mysql_num_fields($result); $j++) {
if (!isset($row[$j])) {
$schema_insert .= " NULL,";
} elseif ($row[$j] != "") {
$schema_insert .= " '" . addslashes($row[$j]) . "',";
} else {
$schema_insert .= " '',";
}
}
$schema_insert = ereg_replace(",\$", "", $schema_insert);
$schema_insert .= ")";
$handler(trim($schema_insert));
$i++;
}
return true;
}
开发者ID:philum,项目名称:cms,代码行数:32,代码来源:dump.php
示例10: BigIDtoBig
function BigIDtoBig($BigID, $table)
{
$sql = "select * from " . $table . " where id=" . $BigID . "";
global $dbname;
$result = mysql_db_query($dbname, $sql);
$rs = mysql_fetch_array($result);
return $rs["BigClass"];
}
开发者ID:jyyy410team,项目名称:hts,代码行数:8,代码来源:function.php
示例11: DB_QUERY
function DB_QUERY($SQL)
{
#echo $SQL. "<BR>";
mysql_connect($GLOBALS["SQL_HOST"], $GLOBALS["SQL_USER"], $GLOBALS["SQL_PASS"]) or die("<meta http-equiv='Content-Type' content='text/html; charset=utf-8' /><div align=center><h2>Server 忙錄中,請稍後再試;或請連絡管理人員</h2></div>");
mysql_query("SET NAMES UTF8");
$RES = mysql_db_query($GLOBALS["SQL_NAME"], $SQL) or die("<meta http-equiv='Content-Type' content='text/html; charset=utf-8' /><div align=center><h2>資料表錯誤,請連絡管理人員</h2></div>" . mysql_error());
return $RES;
}
开发者ID:a5216652166,项目名称:android-novel-reader,代码行数:8,代码来源:db.fun.php
示例12: getAllChild
function getAllChild($MemberID)
{
include "includes/config.php";
$sql = "SELECT COUNT(MemberID) as num FROM {$TMember} WHERE ParentID ='{$MemberID}' AND Status ='A' AND MemberType='S'";
$q = mysql_db_query($dbname, $sql) or die($sql);
$result = mysql_fetch_array($q);
return $result["num"];
}
开发者ID:kitikorn,项目名称:jrp168,代码行数:8,代码来源:getAll.php
示例13: getProvince
function getProvince($pid)
{
include "includes/config.php";
$sql = "SELECT PROVINCE_NAME FROM {$TProvince} WHERE PROVINCE_ID = '{$pid}'";
$q = mysql_db_query($dbname, $sql) or die($sql);
$result = mysql_fetch_array($q);
return $result["PROVINCE_NAME"];
}
开发者ID:kitikorn,项目名称:jrp168,代码行数:8,代码来源:address.php
示例14: DbSelectQuery
function DbSelectQuery($sql, $db_database, $conn)
{
if (@($result = mysql_db_query($db_database, $sql, $conn))) {
return $result;
} else {
$this->ErrorMsg(mysql_error());
exit;
}
}
开发者ID:qinquanxing,项目名称:huaxia,代码行数:9,代码来源:mysql2.class.php
示例15: unblock
public function unblock($fecha1, $hora1, $usuario, $basedatos)
{
$q = "UPDATE usuarios set\r\nfechaIngreso='" . $fecha1 . "',\r\nhoraIngreso='" . $hora1 . "',\r\nllave='',\r\nstatus='inactivo'\r\nWHERE\r\n\r\nusuario='" . $usuario . "' \r\n";
mysql_db_query($basedatos, $q);
echo mysql_error();
?>
<?php
}
开发者ID:rusli-nasir,项目名称:hospitalPhp,代码行数:9,代码来源:desbloquea.php
示例16: validaSubModulo
public function validaSubModulo($campo, $codModulo, $codSM, $usuario, $basedatos)
{
$checaModuloScript = "Select * From usuariosSubmodulos WHERE codModulo='" . $codModulo . "' \r\nand codSM = '" . $codSM . "' and \r\nusuario1 = '" . $usuario . "'";
$resScript = mysql_db_query($basedatos, $checaModuloScript);
$resulScripModulo = mysql_fetch_array($resScript);
echo mysql_error();
//return $resulScripModulo['usuario'];
return $campo = $resulScripModulo['usuario'];
}
开发者ID:rusli-nasir,项目名称:hospitalPhp,代码行数:9,代码来源:validaciones.php
示例17: generateTable
function generateTable($strsql)
{
$mysql_server_name = SERVER_NAME;
// mysql server name
$mysql_username = USER_NAME;
// mysql user name
$mysql_password = USER_PASSWORD;
// mysql user password
$mysql_database = DB_NAME;
// mysql database name
// connect to server
$conn = mysql_connect($mysql_server_name, $mysql_username, $mysql_password);
if (!$conn) {
die('Could not connect: ' . mysql_error());
}
// run sql command
$result = mysql_db_query($mysql_database, $strsql, $conn);
// fetch sql result
$row = mysql_fetch_row($result);
/* to print out the field name from sql result
echo "</b><tr></b>";
for ($i=0; $i<mysql_num_fields($result); $i++)
{
echo '<td><b>'.
mysql_field_name($result, $i);
echo "</b></td></b>";
}
echo "</tr></b>";
*/
mysql_data_seek($result, 0);
//
$tmp = 'tmp';
while ($row = mysql_fetch_row($result)) {
echo "<tr><b>";
for ($i = 0; $i < mysql_num_fields($result); $i++) {
echo '<td>';
if ($i == 0) {
if ($tmp == $row[$i]) {
echo '';
} else {
echo $row[$i];
$tmp = $row[$i];
}
} else {
echo $row[$i];
}
echo '</td>';
}
echo "</tr></b>";
}
echo "</table></b>";
// release
mysql_free_result($result);
// disconnection
mysql_close($conn);
}
开发者ID:hjchen2005,项目名称:consumerComplaintsAnalyzer,代码行数:56,代码来源:getProductTable.php
示例18: Login
function Login()
{
$username = $_POST['username'];
$password = $_POST['password'];
if ($username && $password) {
$conn = mysql_connect(HOST, USER, PASS) or die("Whoops");
// Connect to the database, or if connection fails print error message.
$password = md5($password);
// encode submited password with MD5 encryption and store it back in the same variable. If not on a windows box, I suggest you use crypt()
$sql = "select * from users where loginname='{$username}'";
// query statment that gets the username/password from 'login' where the username is the same as the one you submited
$r = mysql_db_query(DB, $sql);
// Execute Query
// if no rows for that database come up, redirect.
if (!mysql_num_rows($r)) {
mysql_close($conn);
header("Location: index.php");
// This is the redirection, notice it uses $SCRIPT_NAME which is a predefined variable with the name of the script in it.
} else {
$passed = @mysql_connect(HOST, USER, PASS);
}
mysql_select_db(DB);
if (!$passed) {
//echo 'Could not connect: ' . mysql_error();
echo "<center><font color=\"#FF0000\"><b>Invalid User Name or Password</b></font></center>";
$_SESSION["logged"] = 0;
$_SESSION["userid"] = "";
} else {
//$sql="select pass('$password') as pass, fname, sname from users";
$sql = "select pass, fname, sname, loginname, userid from users where loginname='{$username}'";
$password = mkr_query($sql, $passed);
$password = mysql_fetch_array($password);
$_SESSION["employee"] = $password['fname'] . " " . $password['sname'];
$_SESSION["loginname"] = $password['loginname'];
$_SESSION["userid"] = $password['userid'];
$password = $password['pass'];
//******************************************************************
//*Not the best option but produce the required results - unencrypted password saved to a cookie
//******************************************************************
setcookie("data_login", "{$username} {$password}", time() + 60 * 30);
// Set the cookie named 'candle_login' with the value of the username (in plain text) and the password (which has been encrypted and serialized.)
$_SESSION["logged"] = 1;
// set variable $msg with an HTML statement that basically says redirect to the next page. The reason we didn't use header() is that using setcookie() and header() at the sametime isn't 100% compatible with all browsers, this is more compatible.
$msg = "<meta http-equiv=\"Refresh\" content=\"0;url=./index.php\">";
//put index.php
}
} else {
echo "<center><font color=\"#FF0000\"><b>Enter your UserName and Password to login on to the system</b></font></center>";
$_SESSION["logged"] = 0;
}
if ($msg) {
echo $msg;
}
//if $msg is set echo it, resulting in a redirect to the next page.
//}
}
开发者ID:ankita1234,项目名称:hotel-management,代码行数:56,代码来源:index.php
示例19: statusEstudio
public function statusEstudio($numeroE, $nCuenta, $keyCAP, $basedatos)
{
$sql = "select statusEstudio \r\nFROM \r\ncargosCuentaPaciente \r\nWHERE numeroE = '" . $numeroE . "' AND nCuenta='" . $nCuenta . "' AND keyCAP='" . $keyCAP . "'";
$r = mysql_db_query($basedatos, $sql);
$row = mysql_fetch_array($r);
echo mysql_error();
if ($row['statusEstudio'] == 'standby') {
echo '<input name="modificar" type="submit" id="modificar" value="Aplicar" />';
}
}
开发者ID:rusli-nasir,项目名称:hospitalPhp,代码行数:10,代码来源:sql.php
示例20: mdl_update_query
/**
@brief update query
@ingroup mdl
@param $sql sql-query
*/
function mdl_update_query($sql)
{
$result = mysql_db_query($this->dbname, $sql, $this->conn);
if (mysql_errno() == 0) {
$error = "";
$lastId = mysql_insert_id($this->conn);
} else {
die('In den folgendem Sql-Statement ist ein Fehler aufgetreten: ' . $sql . '<BR><BR>Fehler:' . mysql_error());
}
}
开发者ID:BackupTheBerlios,项目名称:unisched-svn,代码行数:15,代码来源:model.php
注:本文中的mysql_db_query函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论