本文整理匯總了PHP中sql_db::sql_open方法的典型用法代碼示例。如果您正苦於以下問題：PHP sql_db::sql_open方法的具體用法？PHP sql_db::sql_open怎麽用？PHP sql_db::sql_open使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類sql_db的用法示例。
在下文中一共展示了sql_db::sql_open方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: define
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
// We enter the detail in the database
if (isset($_POST['id']) == true) {
define('IN_APP', true);
include_once 'mysql.php';
$db = new sql_db();
$db->sql_open('localhost', 'db_user', 'db_password', 'db_name', true, '');
// Escape everything
foreach ($_POST as $key => $value) {
if (is_array($_POST[$key]) == false) {
$_POST[$key] = mysql_real_escape_string($value);
}
}
$data = 0;
// Enter the details in database
for ($i = 0; $i < count($_POST['time']); $i++) {
$db->sql_insert('markers', 'user_id, phone_id, locked, time, lat, lon, acc, spd', "'1', '{$_POST['id']}', '{$_POST['lock']}', '{$_POST['time'][$i]}', '{$_POST['lat'][$i]}', '{$_POST['lon'][$i]}', '{$_POST['acc'][$i]}', '{$_POST['spd'][$i]}'");
$data++;
}
echo 'Data received (' . $data . ') ' . time();
} else {
?>示例2:
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
define('IN_APP', true);
include_once 'mysql.php';
$db = new sql_db();
$db->sql_open('localhost', 'db_user', 'db_pass', 'db_name', true, 'db_table_prefix');
if ($_GET['reset'] == 'true') {
$db->sql_truncate('markers');
}
if ($_GET['fullscreen'] == 'true') {
$canvas = 'map_canvas_full';
} else {
$canvas = 'map_canvas';
}
if ($_GET['all'] == 'true') {
$markers = $db->sql_select('markers', '1 ORDER BY TIME DESC');
} else {
$markers = $db->sql_select('markers', '1 ORDER BY time DESC LIMIT 1');
}
if (count($markers) == 0) {
echo 'No data availible to display.';