function mail_users($subject, $body)
{
$query = msql_query("SELECT `email`, `first_name` FROM `users` WHERE `allow_email` = 1");
while ($row = mysql_fetch_assoc($query) !== false) {
email($row['email'], $subject, "Hello" . $row['first_name'] . ",\n\n" . $body);
}
}
function simpleQuery($query)
{
$this->last_query = $query;
$query = $this->modifyQuery($query);
$result = @msql_query($query, $this->connection);
if (!$result) {
return $this->raiseError();
}
// Determine which queries that should return data, and which
// should return an error code only.
return DB::isManip($query) ? DB_OK : $result;
}
function Query($query)
{
$this->Debug("Query: {$query}");
$first = $this->first_selected_row;
$limit = $this->selected_row_limit;
$this->first_selected_row = $this->selected_row_limit = 0;
if (!$this->SelectDatabase()) {
return 0;
}
if ($result = msql_query($query, $this->connection)) {
if (substr(strtolower(ltrim($query)), 0, strlen("select")) == "select") {
if ($limit > 0) {
$this->limits[$result] = array($first, $limit);
}
$this->highest_fetched_row[$result] = -1;
}
$this->affected_rows = msql_affected_rows($result);
} else {
return $this->SetError("Query", msql_error());
}
return $result;
}
/**
* Returns information about a table or a result set
*
* @param object|string $result DB_result object from a query or a
* string containing the name of a table.
* While this also accepts a query result
* resource identifier, this behavior is
* deprecated.
* @param int $mode a valid tableInfo mode
*
* @return array an associative array with the information requested.
* A DB_Error object on failure.
*
* @see DB_common::setOption()
*/
function tableInfo($result, $mode = null)
{
if (is_string($result)) {
/*
* Probably received a table name.
* Create a result resource identifier.
*/
$id = @msql_query("SELECT * FROM {$result}", $this->connection);
$got_string = true;
} elseif (isset($result->result)) {
/*
* Probably received a result object.
* Extract the result resource identifier.
*/
$id = $result->result;
$got_string = false;
} else {
/*
* Probably received a result resource identifier.
* Copy it.
* Deprecated. Here for compatibility only.
*/
$id = $result;
$got_string = false;
}
if (!is_resource($id)) {
return $this->raiseError(DB_ERROR_NEED_MORE_DATA);
}
if ($this->options['portability'] & DB_PORTABILITY_LOWERCASE) {
$case_func = 'strtolower';
} else {
$case_func = 'strval';
}
$count = @msql_num_fields($id);
$res = array();
if ($mode) {
$res['num_fields'] = $count;
}
for ($i = 0; $i < $count; $i++) {
$tmp = @msql_fetch_field($id);
$flags = '';
if ($tmp->not_null) {
$flags .= 'not_null ';
}
if ($tmp->unique) {
$flags .= 'unique_key ';
}
$flags = trim($flags);
$res[$i] = array('table' => $case_func($tmp->table), 'name' => $case_func($tmp->name), 'type' => $tmp->type, 'len' => msql_field_len($id, $i), 'flags' => $flags);
if ($mode & DB_TABLEINFO_ORDER) {
$res['order'][$res[$i]['name']] = $i;
}
if ($mode & DB_TABLEINFO_ORDERTABLE) {
$res['ordertable'][$res[$i]['table']][$res[$i]['name']] = $i;
}
}
// free the result only if we were called on a table
if ($got_string) {
@msql_free_result($id);
}
return $res;
}
function sql_query($query, $id)
{
global $dbtype;
global $sql_debug;
$sql_debug = 0;
if ($sql_debug) {
echo "SQL query: " . str_replace(",", ", ", $query) . "<BR>";
}
switch ($dbtype) {
case "MySQL":
$res = @mysql_query($query, $id);
return $res;
break;
case "mSQL":
$res = @msql_query($query, $id);
return $res;
break;
case "postgres":
case "postgres_local":
$res = pg_exec($id, $query);
$result_set = new ResultSet();
$result_set->set_result($res);
$result_set->set_total_rows(sql_num_rows($result_set));
$result_set->set_fetched_rows(0);
return $result_set;
break;
case "ODBC":
case "ODBC_Adabas":
$res = @odbc_exec($id, $query);
return $res;
break;
case "Interbase":
$res = @ibase_query($id, $query);
return $res;
break;
case "Sybase":
$res = @sybase_query($query, $id);
return $res;
break;
default:
break;
}
}
function query_msql($query)
{
if (!$this->msql_link) {
return false;
}
$this->query_result = msql_query($query, $this->msql_link);
if ($this->query_result) {
return $this->query_result;
} else {
print nl2br("Error query. \n");
return false;
}
}
function GetAllWikiPageNames($dbi_)
{
$res = msql_query("select pagename from wiki", $dbi['dbc']);
$rows = msql_num_rows($res);
for ($i = 0; $i < $rows; $i++) {
$pages[$i] = msql_result($res, $i, 'pagename');
}
return $pages;
}
<input type="submit" name="submit" value="上传" />
</form>
<?php
$email = $_SESSION['p_email'];
$ret = mysql_query("SELECT * FROM Images WHERE email = '{$email}'");
if ($row = mysql_fetch_array($ret)) {
?>
<div style='width:170px;'>
<img src="image.php?" width="500" height="500" border="0">
</div>
<?php
} else {
$_SESSION['p_email'] = 'default';
$ret = msql_query("SELECT * FROM Images WHERE email='default'");
while ($row = mysql_fetch_array($ret)) {
?>
<div style='width:170px;'>
<img src="image.php?" width="500" height="500" border="0">
</div>
<?php
}
}
?>
</div>
<div id="username"></div>
Password:<input type=password name='pass'><br/>
<input type=submit value='Go!' name='submit'>
</form>
<?php
if (isset($_POST['submit'])) {
//mysql_real_escape_string() escapes special characters in a string for use in an SQL statement
$user = mysql_real_escape_string($_POST['user']);
$pass = mysql_real_escape_string($_POST['pass']);
$con = mysql_connect('localhost', 'root', '') or die(mysql_error());
mysql_select_db('user') or die("cannot select DB");
$query = mysql_query("SELECT * FROM login WHERE user='******'");
$numrows = mysql_num_rows($query);
if ($numrows == 0) {
//md5() calculates the MD5 hash of a string
$encrypt_password = md5($pass);
$sql - "INSERT INTO login(user,pass) VALUES ('{$user}','{$encrypt_password}')";
$result = msql_query($sql);
if ($result != 1) {
echo "Failure!";
} else {
echo "Account succefully created";
}
} else {
echo "That username already exists! please try again with another name.";
}
}
?>
<p><a herf="register.php"><Register</a> | <a href="../../../Users/VANZ/AppData/Roaming/Macromedia/Dreamweaver 8/Configuration/Temp/FlashElements/ImageViewer/login.php">Login</a></p>
</body>
</html>
