本文整理汇总了PHP中sql_db::sql_fetchrow方法的典型用法代码示例。如果您正苦于以下问题：PHP sql_db::sql_fetchrow方法的具体用法？PHP sql_db::sql_fetchrow怎么用？PHP sql_db::sql_fetchrow使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类sql_db的用法示例。
在下文中一共展示了sql_db::sql_fetchrow方法的13个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: die
echo("<body>\n");
echo("<div style=\"font-family: 'Lucida Grande', 'Trebuchet MS', Verdana, Helvetica, Arial, sans-serif; font-size: 10px;\">\n");
echo("<b style=\"color: #dd2222;\">DB Conversion to UTF-8 in progress, please do not stop the browser until the whole process is finished...</b><br />\n<br />\n<br />\n");
// HTML HEADER - END
flush();
$sql = "ALTER DATABASE {$db->sql_escape($dbname)}
CHARACTER SET utf8
DEFAULT CHARACTER SET utf8
COLLATE utf8_bin
DEFAULT COLLATE utf8_bin";
$db->sql_query($sql) or die($db->sql_error());
$sql = "SHOW TABLES";
$result = $db->sql_query($sql) or die($db->sql_error());
while ($row = $db->sql_fetchrow($result))
{
// This assignment doesn't work...
//$table = $row[0];
$current_item = each($row);
$table = $current_item['value'];
reset($row);
if (strpos($table, $table_prefix) === 0)
{
$sql = "ALTER TABLE {$db->sql_escape($table)}
DEFAULT CHARACTER SET utf8
COLLATE utf8_bin";
//ENGINE=MYISAM";
$db->sql_query($sql) or die($db->sql_error());示例2: time
}
$sql = "UPDATE " . $table_prefix . "users\n SET user_regdate = " . time();
if (!$db->sql_query($sql)) {
$error .= "Could not update user_regdate :: " . $sql . " :: " . __LINE__ . " :: " . __FILE__ . "<br /><br />";
}
// Prillian - START
$user_success = 0;
$user_total = 0;
$err_msg = '';
$err_ids = array();
$sql = 'SELECT user_id, user_style FROM ' . $table_prefix . 'users WHERE user_id <> ' . ANONYMOUS;
if (!($result = $db->sql_query($sql))) {
$error = true;
$error .= '<span class="err_msg">Failed to get list of user_ids for inserting<br /><br /></span>';
}
while ($row = $db->sql_fetchrow($result)) {
$user_total++;
$sql = 'INSERT INTO ' . $table_prefix . 'im_prefs (user_id, themes_id) VALUES (' . $row['user_id'] . ', ' . $row['user_style'] . ')';
if (!$db->sql_query($sql)) {
$error = true;
$err_msg .= (!empty($err_msg) ? ', ' : '') . $row['user_id'];
$err_ids[] = $row['user_id'];
} else {
$user_success++;
}
}
if ($err_msg) {
$error .= '<br /><br /><span class="err_msg">These users were not copied: ' . $err_msg . '.</span><br /><br />Those users may already exist in the table or the copy may have simply failed. In the latter case, you may need to add the users manually. To do this, you will need to run the SQL queries below through phpMyAdmin or a similar utility. If you do not have such a utility, try going to the Utilities section of phpBBHacks.com and check out the db_generator page there.<br /><br /><span class="query_msg">';
//foreach($err_ids as $id)
//{
// $message .= 'INSERT INTO ' . $table_prefix . 'im_prefs (user_id, themes_id) VALUES (' . $id . ', ' . $board_config['default_style'] . ');<br />';示例3: substr
if (strlen($valore) > 0) {
$sqlinsertfield .= "{$campo},";
$sqlinsertvalues .= "{$valore},";
}
}
$sqlinsertfield = substr($sqlinsertfield, 0, strlen($sqlinsertfield) - 1);
$sqlinsertvalues = substr($sqlinsertvalues, 0, strlen($sqlinsertvalues) - 1);
$sqlinsert = "insert into {$tabelladb} ({$sqlinsertfield}) values ({$sqlinsertvalues})";
$sql = $sqlinsert;
}
//echo "<p>$sql</p>";
print_debug($sql, null, 'savedata');
$result = $db->sql_query($sql);
$retval = "";
$elenco = $db->sql_fetchrowset();
$nrighe = $db->sql_numrows();
if (!$result) {
echo "ERRORE NEL SALVATAGGIO<p>{$sql}</p>";
return;
}
//se ho inserito un nuovo valore ricavo l'ultimo id
if ($_POST["mode"] == "new") {
$sql = $tb->table_list ? "SELECT max(id) FROM {$tabelladb}" : "select currval ('" . trim($tabelladb) . "_id_seq')";
//echo "<p>$sql</p>";
$db->sql_query($sql);
$row = $db->sql_fetchrow();
$lastid = $row[0];
$_SESSION["ADD_NEW"] = $lastid;
//print_debug("sessione ho $lastid");
}
}示例4: die
require_once "login.php";
$db = new sql_db(DB_HOST, DB_USER, DB_PWD, DB_NAME, false);
if (!$db->db_connect_id) {
die("Impossibile connettersi al database");
}
$oggi = date("d-m-Y");
$dataoneri = date("d/m/Y");
$pratica = $_REQUEST['pratica'];
$sql = "SELECT numero,coalesce(data_prot,data_presentazione) as data from pe.avvioproc where pratica={$pratica}";
$db->sql_query($sql);
$numero = $db->sql_fetchfield('numero');
//$dataoneri=$db->sql_fetchfield('data');
$query = "SELECT * FROM oneri.parametri where '{$dataoneri}'::date BETWEEN datein AND coalesce(dateed,CURRENT_DATE);";
$result = $db->sql_query($query);
//if(!$result){echo "SQL Error - ".mysql_error()."<br>".$query;return;}
$row = $db->sql_fetchrow($result);
$costo_base = $row['costo_base'];
$qbase = $row['quota_base'];
$classe = $row['classe_comune'];
$quota = $row['corrispettivo'];
$delibera = $row['delibera'];
$sql = "SELECT case when (not coalesce(piva,'')='') then coalesce(ragsoc,'') else coalesce(cognome,'')||' '||coalesce(nome,'') end as nominativo FROM pe.soggetti WHERE richiedente=1 and pratica={$pratica};";
$db->sql_query($sql);
$ris = $db->sql_fetchlist('nominativo');
$nominativi = implode('; ', $ris);
$sql = "SELECT coalesce(via,'')||' '||coalesce(civico,'') as indirizzi FROM pe.indirizzi WHERE pratica={$pratica};";
$db->sql_query($sql);
$ris = $db->sql_fetchlist('indirizzi');
$indirizzi = implode('; ', $ris);
$sql = "SELECT valore,codice FROM pe.parametri_prog X inner join pe.e_parametri Y on(X.parametro=Y.id) WHERE pratica={$pratica} and codice in ('slot','ve','vp')";
//echo $sql;示例5: while
break;
case 'postgresql':
break;
}
$db->sql_query($sql);
$sql = "UPDATE {$table_prefix}topics SET topic_poster = 1 WHERE topic_poster = 0 OR topic_poster IS NULL";
$db->sql_query($sql);
$sql = "UPDATE {$table_prefix}topics SET topic_last_poster_id = 1 WHERE topic_last_poster_id = 0 OR topic_last_poster_id IS NULL";
$db->sql_query($sql);
$sql = "UPDATE {$table_prefix}posts SET poster_id = 1 WHERE poster_id = 0 OR poster_id IS NULL";
$db->sql_query($sql);
$sql = "UPDATE {$table_prefix}users SET user_id = 1 WHERE user_id = 0";
$db->sql_query($sql);
$sql = "SELECT t.topic_id \n\tFROM {$table_prefix}topics t \n\tLEFT JOIN {$table_prefix}posts p ON p.topic_id = t.topic_id \n\tWHERE p.topic_id IS NULL";
$result = $db->sql_query($sql);
if ($row = $db->sql_fetchrow($result)) {
$del_sql = '';
do {
$del_sql .= ($del_sql != '' ? ', ' : '') . $row['topic_id'];
} while ($row = $db->sql_fetchrow($result));
$sql = "DELETE FROM {$table_prefix}topics \n\t\tWHERE topic_id IN ({$del_sql})";
$db->sql_query($sql);
}
$db->sql_freeresult($result);
$del_sql = '';
$sql = "SELECT topic_id, MIN(post_id) AS first_post_id, MAX(post_id) AS last_post_id, COUNT(post_id) AS total_posts \n\tFROM {$table_prefix}posts \n\tGROUP BY topic_id";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$del_sql .= ($del_sql != '' ? ', ' : '') . $row['topic_id'];
$sql = "UPDATE {$table_prefix}topics \n\t\tSET topic_first_post_id = " . $row['first_post_id'] . ", topic_last_post_id = " . $row['last_post_id'] . ", topic_replies = " . ($row['total_posts'] - 1) . "\n\t\tWHERE topic_id = " . $row['topic_id'];
$db->sql_query($sql);示例6: die
// DATABASE
$coddb = new sql_db($db_host, $db_user, $db_pass, $db_db, false);
if (!$coddb->db_connect_id) {
die("Could not connect to the database");
}
/*$query = "SELECT *
FROM ${t['players']}, ${t['b3_clients']}
WHERE ${t['b3_clients']}.id = ${t['players']}.client_id
AND ${t['players']}.id = '" . addslashes_gpc($player_id) . "'
AND ((${t['players']}.kills > $minkills)
OR (${t['players']}.rounds > $minrounds))
AND (${t['players']}.hide = 0)
AND ($current_time - ${t['b3_clients']}.time_edit < $timelimit)";*/
$query = "SELECT * \n FROM {$t['players']}, {$t['b3_clients']} \n WHERE {$t['b3_clients']}.id = {$t['players']}.client_id \n AND {$t['players']}.id = '" . addslashes_gpc($player_id) . "'";
$result = $coddb->sql_query($query);
$player = $coddb->sql_fetchrow($result);
$coddb->sql_query("START TRANSACTION");
$coddb->sql_query("BEGIN");
$coddb->sql_query("SET @place = 0");
$query2 = "select * from (\n SELECT @place := @place + 1 AS place, {$t['players']}.id\n FROM {$t['players']}, {$t['b3_clients']}\n WHERE {$t['b3_clients']}.id = {$t['players']}.client_id\n AND (({$t['players']}.kills > {$minkills})\n OR ({$t['players']}.rounds > {$minrounds}))\n AND ({$t['players']}.hide = 0)\n AND ({$current_time} - {$t['b3_clients']}.time_edit < {$timelimit})";
if ($exclude_ban) {
$query2 .= "AND {$t['b3_clients']}.id NOT IN (\n SELECT distinct(target.id)\n FROM {$t['b3_penalties']} as penalties, {$t['b3_clients']} as target\n WHERE (penalties.type = 'Ban' OR penalties.type = 'TempBan')\n AND inactive = 0\n AND penalties.client_id = target.id\n AND ( penalties.time_expire = -1 OR penalties.time_expire > UNIX_TIMESTAMP(NOW()) )\n )";
}
$query2 .= " ORDER BY {$t['players']}.skill DESC\n ) derivated_table\n where id = {$player_id}";
$result2 = $coddb->sql_query($query2);
$row2 = $coddb->sql_fetchrow($result2);
$coddb->sql_query("ROLLBACK");
if ($player['hide'] == 1) {
$advertising = 1;
}
if ($advertising != 0) {示例7: unset
$db->sql_query($sql);
$nrec = $db->sql_numrows();
$indirizzi = $db->sql_fetchrowset();
for ($j = 0; $j < $nrec; $j++) {
if ($ubicazione) {
$ubicazione .= " - ";
}
$ubicazione = $indirizzi[$j]["via"] . " " . $indirizzi[$j]["civico"];
if ($indirizzi[$j]["interno"]) {
$ubicazione .= "/" . $indirizzi[$j]["interno"];
}
}
//Cerco info sulla pratica
$sql = "select * from pe.avvioproc where pratica={$idpratica}";
$db->sql_query($sql);
$dati_pratica = $db->sql_fetchrow();
$titolo = "Pratica n° " . $dati_pratica["numero"] . " del " . $dati_pratica["data_presentazione"];
//Scrivo i dati sulla pratica
print "\n<H2><input type=\"checkbox\" value=\"{$idpratica}\" name=\"idpratica[]\"><a href=\"#\" onclick=\"javascript:NewWindow('praticaweb.php?pratica={$idpratica}','PraticaWeb',0,0,'yes');\">{$titolo}</a></H2>";
print "\n<input name=\"numero[]\" type=\"hidden\" value=\"" . $dati_pratica["numero"] . "\">";
print "\n<p>Oggetto:" . $dati_pratica["oggetto"] . "<br>";
print "\nRichiedenti: {$nomi_richiedenti}<br>";
print "\nUbicazione: {$ubicazione}";
print "<img src=\"images/gray_light.gif\" height=\"2\" width=\"90%\">";
unset($nomi_richiedenti);
unset($indrizzi);
}
$modo = "view";
if ($totrec === 0) {
// Ricerca senza risultato
$azione = "<br>\n\t\t<center><input name=\"azione\" type=\"button\" class=\"hexfield\" tabindex=\"14\" value=\"Indietro\" onclick=\"javascript:document.location='{$active_form}?{$commissione}=1&pratica={$idcomm}&mode=edit&ricerca=0'\"></center>";示例8: values
include( 'mysql4.php' );
include( '../config.php' );
//first we need to retrieve the list of all active companies that might have imported data
$db_support = new sql_db( $supportdb, $dbuser, $dbpasswd, 'nizex_support', false );
if ( $db_support->db_connect_id )
{
$query = "select CompanyID, DBName, DBHost, TableVersion from optUserCompany where Active=1 ";
if ( !( $result = $db_support->sql_query( $query ) ) )
{
$lbl_error = $dblang[ "ErrorInSQL" ]."<br>".$db_support->sql_error();
}
while ( $row = $db_support->sql_fetchrow( $result ))
{
$db = new sql_db( $dbhost, $dbuser, $dbpasswd, $row[ 'DBName' ], true );
$query = "select * from conLeadSources where LeadName='Other'";
if ( !( $result2 = $db->sql_query( $query ) ) )
echo "Problem with: ".$query;
if ( $db->sql_numrows( $result2 ) == 0 )
{
$query = "insert into conLeadSources values ( null, 'Other', 1 )";
if ( !( $result2 = $db->sql_query( $query ) ) )
echo "Problem with: ".$query;
}
} //end while looping through companies
}示例9: getDBHost
function getDBHost( $databasename = '' )
{
global $supportdb, $dbuser, $dbpasswd;
$dbsupport = new sql_db( $supportdb, $dbuser, $dbpasswd, 'nizex_support', false, true );
$query = "select DBHost from optUserCompany where DBName = '".$databasename."'";
if ( !$result = $dbsupport->sql_query( $query ) )
{
LogError( 9369, $query ."<br>".$dbsupport->sql_error(), false );
return false;
}
$row = $dbsupport->sql_fetchrow( $result );
return $row[ "DBHost" ];
}示例10: die
include_once "login.php";
$db = new sql_db(DB_HOST, DB_USER, DB_PWD, DB_NAME, false);
if (!$db->db_connect_id) {
die("Impossibile connettersi al database");
}
if (isset($_GET["mapkey"])) {
$mapkey = explode('@', $_GET["mapkey"]);
}
//print_r ($mapkey);
$tipo = $mapkey[0];
$mappale = $mapkey[1];
$foglio = $mapkey[2];
$sql = "select oid,extent(buffer(the_geom," . BUFFER_SIZE . ")) from map.ct_particelle where foglio ilike('{$foglio}') and mappale ilike ('{$mappale}') group by oid;";
$result = $db->sql_query($sql);
$extent = $db->sql_fetchrow();
$ext = $extent["extent"];
$objid = $extent["oid"];
if ($ext) {
$p1 = strpos($ext, "(") + 1;
$p2 = strpos($ext, ")");
$ext = substr($ext, $p1, $p2 - $p1);
$ext = str_replace(",", "+", $ext);
$ext = str_replace(" ", "+", $ext);
$ext2 = str_replace("+", ";", $ext);
include "http://localhost/cgi-bin/mapserv.exe?map=C:\\[pmapper]\\projects\\ceriale\\map\\catasto.map&mapext={$ext}";
?>
<SCRIPT LANGUAGE="JavaScript1.2">
function openPmapper(winwidth, winheight, gLanguage, startParameters){
//CASO FULLSCREEN DA AGGIUNGERE ALLE POSSIBILITA
//se il browser non riconosce la dimensione della finestra potrei passare un 800x600 示例11: die
function get_list($idpratica)
{
if (isset($_SESSION["MENU_" . $this->tipo . "_{$idpratica}"])) {
$menu_pratica = $_SESSION["MENU_" . $this->tipo . "_{$idpratica}"];
} else {
$db = new sql_db(DB_HOST, DB_USER, DB_PWD, DB_NAME, false);
if (!$db->db_connect_id) {
die("Impossibile connettersi al dadabase");
}
if ($this->tipo == "commissione") {
// menu per la commissione
$menu_settings = @file(MENU . "commissione.mnu");
foreach ($menu_settings as $riga) {
$menu_pratica[] = explode(",", $riga);
}
$mnu = "commissione";
} elseif ($this->tipo == "commissione_paesaggio") {
// menu per la commissione del paesaggio
$menu_settings = @file(MENU . "commissione_paesaggio.mnu");
foreach ($menu_settings as $riga) {
$menu_pratica[] = explode(",", $riga);
}
$mnu = "commissione_paesaggio";
} elseif ($this->tipo == "cdu") {
// menu per la commissione
$menu_settings = @file(MENU . "cdu.mnu");
foreach ($menu_settings as $riga) {
$menu_pratica[] = explode(",", $riga);
}
$mnu = "cdu";
} elseif ($this->tipo == "condono") {
$menu_settings = @file(MENU . "condono.mnu");
foreach ($menu_settings as $riga) {
$menu_pratica[] = explode(",", $riga);
}
$mnu = "condono";
} elseif ($this->tipo == "vigilanza") {
// menu per la commissione
$menu_settings = @file(MENU . "vigilanza.mnu");
foreach ($menu_settings as $riga) {
$menu_pratica[] = explode(",", $riga);
}
$mnu = "vigilanza";
} elseif ($this->tipo == "ambiente") {
// menu per l'ambiente
$menu_settings = @file(MENU . "ambiente.mnu");
foreach ($menu_settings as $riga) {
$menu_pratica[] = explode(",", $riga);
}
$mnu = "ambiente";
} elseif ($this->tipo == "pratica") {
//menu per le pratiche
$sql = "select menu_list,menu_file from pe.menu where pratica={$idpratica};";
$result = $db->sql_query($sql);
if (!$result) {
echo "<p><b>ERRORE:</b><br>Configurazione dei menù errata</p>";
exit;
}
$row = $db->sql_fetchrow();
$menu_list = str_replace('#', '', $row["menu_list"]);
$menu_list = explode(",", $menu_list);
$menu_file = $row["menu_file"];
$menu_settings = @file(MENU . "{$menu_file}" . ".mnu");
if (!$menu_settings) {
echo "<p><b>ERRORE:</b><br>File di configurazione dei menù mancante o errato</p>";
exit;
}
$cont_separatore = 0;
foreach ($menu_settings as $riga) {
$menu = explode(",", $riga);
$idmenu = $menu[0];
if (count($menu) == 1) {
//riga di separazione
if ($cont_separatore == 0) {
//una sola volta
$menu_pratica[] = "separatore";
$cont_separatore++;
}
} elseif (in_array($idmenu, $menu_list)) {
$menu_pratica[] = $menu;
$cont_separatore = 0;
}
}
$mnu = "pratica";
}
$_SESSION["MENU_" . $this->tipo . "_{$idpratica}"] = $menu_pratica;
}
$width = '150px';
print "<DIV id='nav-buttons' style='font-size:0px;'>";
foreach ($menu_pratica as $menu) {
if (is_array($menu)) {
/*print("<A tabIndex=\"0\" href=\"javascript:pagina('".$menu[2]."',$idpratica)\">".$menu[1]."</A>\n
<IMG height=\"1 px\" alt=\"\" src=\"images/white.gif\" width=\"$width\" align=\"bottom\" border=\"0\">");*/
print "<A tabIndex=\"0\" href=\"javascript:pagina('" . $menu[2] . "',{$idpratica})\">" . $menu[1] . "</A>\n";
} else {
print "<IMG style=\"height:1px;width:{$width};border:0px;padding:1px;margin:0px;\" src=\"images/gray_light.gif\">";
}
}
print "\n\t\t</DIV>";
if ($this->tipo == "pratica" or $this->tipo == "condono" or $this->tipo == "cdu" or $this->tipo = "commissione" or $this->tipo == "ambiente") {
//.........这里部分代码省略.........
示例12: foreach
$module_name = "";
require_once NV_ROOTDIR . '/includes/sqldata.php';
$modules_exit = nv_scandir(NV_ROOTDIR . "/modules", $global_config['check_module']);
$modules_exit[] = 'global';
//cai dat du lieu cho ngon ngu
$sql_create_table = nv_create_table_sys(NV_LANG_DATA);
foreach ($sql_create_table as $query) {
if (!$db->sql_query($query)) {
$nv_Request->set_Session('maxstep', 1);
$db_config['error'] = !empty($db->error['user_message']) ? $db->error['user_message'] : $db->error['message'];
break;
}
}
$sql = "SELECT * FROM `" . $db_config['prefix'] . "_" . NV_LANG_DATA . "_modules` ORDER BY `weight` ASC";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$setmodule = $row['title'];
if (in_array($row['module_file'], $modules_exit)) {
$sm = nv_setup_data_module(NV_LANG_DATA, $setmodule);
if ($sm != "OK_" . $setmodule) {
die("error set module: " . $setmodule);
}
} else {
$sql = "DELETE FROM `" . $db_config['prefix'] . "_" . NV_LANG_DATA . "_modules` WHERE `title`=" . $db->dbescape($setmodule);
$db->sql_query($sql);
}
}
//cai dat du lieu mau
$filesavedata = NV_LANG_DATA;
$lang_data = NV_LANG_DATA;
if (!file_exists(NV_ROOTDIR . "/install/data_" . $lang_data . ".php")) {示例13: die
if (!$db->db_connect_id) {
die("Impossibile connettersi al database");
}
switch ($_GET["funz"]) {
case "crea_elenco":
$obj = $_GET["elenco"];
$tab = $_GET["tabella"];
$filtro = $_GET["filtro"];
$val_filtro = $_GET["val_filtro"];
$pratica = $_GET["pratica"];
$oggetto = $_GET["oggetto"];
/**/
$sql = "SELECT data_presentazione,destuso1 FROM pe.avvioproc LEFT JOIN pe.progetto ON avvioproc.pratica=progetto.pratica WHERE avvioproc.pratica={$pratica};";
//if($_SESSION["USER_ID"]<=3) echo "<p>$sql</p>";
$db->sql_query($sql);
$ris = $db->sql_fetchrow();
$data = $ris["data_presentazione"];
$destuso = $ris["destuso1"];
$sql = "SELECT tipoxoneri FROM pe.vincoli LEFT JOIN pe.e_vincoli_zone ON vincoli.vincolo=e_vincoli_zone.vincolo AND vincoli.zona=e_vincoli_zone.zona WHERE pratica={$pratica};";
//if($_SESSION["USER_ID"]<=3) echo "<p>$sql</p>";
$db->sql_query($sql);
$ris = $db->sql_fetchlist("tipoxoneri");
if ($ris) {
foreach ($ris as $val) {
$sql = "SELECT DISTINCT opzione FROM oneri.elenco_d2 WHERE zona LIKE '%{$val};%'";
if ($db->sql_query($sql)) {
$opt = $db->sql_fetchrow();
}
if ($opt) {
break;
}