本文整理汇总了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.';