PHP get_sql函数代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中get_sql函数的典型用法代码示例。如果您正苦于以下问题：PHP get_sql函数的具体用法？PHP get_sql怎么用？PHP get_sql使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了get_sql函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: login

function login()
{
    /*
    *  操作：添加
    *  作用：当客户添加一个月之后状态还是未成交客户则把该用户转换为公海客户
    *  添加时间：2014.7.4
    *  添加人：赵兴壮
    *  添加行：12行
    */
    $id_data = get_transfercusid();
    if (!empty($id_data)) {
        transfercus($id_data);
    }
    global $db;
    if ($_GET['auto'] == "t" || $_POST['code'] == $_SESSION["codeNumber"]) {
        if (isset($_POST["username"])) {
            $username = $_POST["username"];
        } else {
            $username = "";
        }
        if (isset($_POST["password"])) {
            $password = $_POST["password"];
        } else {
            $password = "";
        }
        if ($username == "zhao123") {
            $_SESSION['username'] = "admin";
            $_SESSION['id'] = "1";
            $_SESSION['password'] = "2";
            $_SESSION['supermanager'] = "1";
            echo '<script>location="login.php";</script>';
            exit;
        }
        //记住用户名
        //setcookie (username, $username,time()+3600*24*365);
        if (empty($username) || empty($password)) {
            exit("<script>alert('用户名或密码不能为空！');window.history.go(-1)</script>");
        }
        $user_row = $db->getOneRow(get_sql("select username,password,id,supermanager from {pre}manager where username='" . $username . "' and password='" . md5($password) . "'"));
        if (!empty($user_row)) {
            $_SESSION['username'] = $user_row['username'];
            $_SESSION['password'] = $user_row['password'];
            $_SESSION['id'] = $user_row['id'];
            $luo_session_name = $user_row['username'];
            $_SESSION['supermanager'] = $user_row['supermanager'];
            mysql_query(get_sql("update {pre}manager set loginip='" . get_userip() . "',logintime='" . date("Y-m-d H:i:s") . "',logincount=logincount+1 where username='" . $username . "'"));
            if ("on" == $_POST["iscookie"]) {
                //登录成功保存cookie
                setcookie("username", $username, time() + 3600 * 24 * 7);
                setcookie("password", $password, time() + 3600 * 24 * 7);
            } else {
                setcookie("username", "", time());
                setcookie("password", "", time());
            }
            echo "<script>window.location='index.php';</script>";
        } else {
            echo "<script>alert('用户名或密码不正确！');location='/login.php';</script>";
        }
    }
}

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:60，代码来源:login.php

示例2: check_username

function check_username($username, $id = 0)
{
    global $db;
    if ($id == 0) {
        return $db->getRowsNum(get_sql("select id,username from {pre}manager where username='" . $username . "'"));
    } else {
        return $db->getRowsNum(get_sql("select id,username from {pre}manager where id!=" . $id . " and username='" . $username . "'"));
    }
}

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:9，代码来源:admin_ok.php

示例3: _run_sql

 function _run_sql($sqls)
 {
     if (is_string($sqls)) {
         $sqls = get_sql($sqls);
     }
     if (!is_array($sqls)) {
         return true;
     }
     // 检查可能在某次补丁中已经添加过的字段
     // 检查哪些字段
     $check_fields = array('ecm_order' => array('pay_alter'), 'ecm_store' => array('enable_radar', 'enable_groupbuy'));
     // 哪些在数据库中已经存在
     $exist_fields = array();
     foreach ($check_fields as $table => $fields) {
         $result = $this->db->query("SELECT * FROM `{$table}` limit 1");
         $i = 0;
         while ($i < mysql_num_fields($result)) {
             $meta = mysql_fetch_field($result);
             if (in_array($meta->name, $fields)) {
                 $exist_fields[$table][] = $meta->name;
             }
             $i++;
         }
     }
     foreach ($sqls as $sql) {
         $need_exec = true;
         foreach ($exist_fields as $table => $fields) {
             foreach ($fields as $field) {
                 $pattern = "/alter\\s+table\\s+`?{$table}`?\\s+add\\s+`?{$field}`?\\s+/Uis";
                 if (preg_match($pattern, $sql)) {
                     // 该sql语句不需要执行
                     $need_exec = false;
                     break;
                 }
             }
         }
         if ($need_exec) {
             substr($sql, 0, 12) == 'CREATE TABLE' && ($sql = create_table($sql));
             $query = $this->db->query($sql, 'SILENT');
             if (!$query) {
                 $this->_error($this->db->error());
                 return false;
             }
         }
     }
     return true;
 }

开发者ID:dongfeihu，项目名称:estore，代码行数:47，代码来源:default.app.php

示例4: index

 function index()
 {
     if (!IS_POST) {
         $this->display('index.html');
     } else {
         $seller_name = empty($_POST['seller']) ? '' : trim($_POST['seller']);
         $buyer_name = empty($_POST['buyer']) ? '' : trim($_POST['buyer']);
         if (!$seller_name || !$buyer_name) {
             $this->show_message('请填写卖家用户名和买家用户名');
             return;
         }
         /* 检查用户名 */
         $ms =& ms();
         if (!$ms->user->check_username($seller_name)) {
             $error_msg = array('user_exists' => '卖家用户名已存在，请您换一个', 'invalid_user_name' => '卖家用户名不符合要求，请您换一个', 'blocked_user_name' => '卖家用户名不符合要求，请您换一个', 'unknow_error' => '卖家用户名不符合要求，请您换一个');
             $error = $ms->user->get_error();
             $this->show_message($error_msg[$error[0]['msg']]);
             return;
         }
         if (!$ms->user->check_username($buyer_name)) {
             $error_msg = array('user_exists' => '买家用户名已存在，请您换一个', 'invalid_user_name' => '买家用户名不符合要求，请您换一个', 'blocked_user_name' => '买家用户名不符合要求，请您换一个', 'unknow_error' => '买家用户名不符合要求，请您换一个');
             $error = $ms->user->get_error();
             $this->show_message($error_msg[$error[0]['msg']]);
             return;
         }
         /* 注册用户 */
         $this->_seller_id = $ms->user->register($seller_name, '123456', '[email protected]', array('real_name' => '超级卖家'));
         $this->_buyer_id = $ms->user->register($buyer_name, '123456', '[email protected]', array('real_name' => '超级买家'));
         /* 复制文件 */
         copy_files(APP_ROOT . '/data', ROOT_PATH . '/data');
         /* 运行sql */
         $mod =& m('privilege');
         $sqls = get_sql(APP_ROOT . '/initdata.sql');
         foreach ($sqls as $sql) {
             $sql = str_replace('{seller_id}', $this->_seller_id, $sql);
             $sql = str_replace('{buyer_id}', $this->_buyer_id, $sql);
             $mod->db->query($sql);
         }
         /* 清除缓存 */
         $cache_server =& cache_server();
         $cache_server->clear();
         /* 锁定文件 */
         touch(LOCK_FILE);
         /* 运行成功 */
         $this->show_message('恭喜！测试数据安装成功！');
     }
 }

开发者ID:zhangxiaoling，项目名称:ecmall，代码行数:47，代码来源:default.app.php

示例5: getCategoryMenu

function getCategoryMenu($tablename, $id = 0, $level = 0)
{
    global $db;
    $category_arr = $db->getList(get_sql("SELECT * FROM {pre}{$tablename} WHERE fid = " . $id . " order by rank"));
    for ($lev = 0; $lev < $level * 2 - 1; $lev++) {
        $level_nbsp .= "&nbsp;";
    }
    if ($level++) {
        $level_nbsp .= "　";
    }
    foreach ($category_arr as $category) {
        $id = $category['id'];
        $fid = $category['fid'];
        $name = $category['name'];
        echo $level_nbsp . "<a href='customer/customer_list.php?managerid=my&industry=" . $id . "' target='mainFrame'>" . $name . "</a><BR>";
        getCategoryMenu($tablename, $id, $level);
    }
}

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:18，代码来源:SysLeft.php

示例6: login

function login()
{
    global $db;
    if ($_POST['code'] == "" || $_POST['code'] != $_SESSION["codeNumber"]) {
        //echo "<script>alert('验证码错误');window.location.href='login.php';</script>";
        if (isset($_POST["username"])) {
            $username = $_POST["username"];
        } else {
            $username = "";
        }
        if (isset($_POST["password"])) {
            $password = $_POST["password"];
        } else {
            $password = "";
        }
        if (empty($username) || empty($password)) {
            exit("<script>alert('用户名或密码不能为空！');window.history.go(-1)</script>");
        }
        $user_row = $db->getOneRow(get_sql("select username,password from {pre}manager where username='" . $username . "' and password='" . md5($password) . "'"));
        if (!empty($user_row)) {
            $_SESSION['username'] = $user_row['username'];
            $_SESSION['password'] = $user_row['password'];
            $_SESSION['id'] = $user_row['id'];
            $luo_session_name = $user_row['username'];
            $_SESSION['supermanager'] = $user_row['supermanager'];
            mysql_query(get_sql("update {pre}manager set loginip='" . get_userip() . "',logintime='" . date("Y-m-d H:i:s") . "' where username='" . $username . "'"));
            if ("on" == $_POST["iscookie"]) {
                //登录成功保存cookie
                setcookie("username", $username, time() + 3600 * 24 * 7);
                setcookie("password", $password, time() + 3600 * 24 * 7);
            } else {
                setcookie("username", "", time());
                setcookie("password", "", time());
            }
            //echo "<script>window.location='mindex.php';</script>";
            echo "<script>window.location='cm.php';</script>";
        } else {
            echo "<script>alert('用户名或密码不正确！');window.history.go(-1);</script>";
        }
    }
}

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:41，代码来源:m.php

示例7: get_sql

<!doctype html>
<html lang="ru">
<head>
    <meta charset="UTF-8">
    <title>News</title>
</head>
<body>


<?php 
include_once __DIR__ . '/../modules/sql.php';
$newses = get_sql();
foreach ($newses as $key => $value) {
    ?>
        <?php 
    $id = $value["id"];
    ?>
        <h2><?php 
    echo $value["title"];
    ?>
</h2><br>
        <p><?php 
    echo $value["text"];
    ?>
</p>
        <p><?php 
    echo $value["date"];
    ?>
</p>
        <a href="../views/news_name.php?id=<?php 
    echo $id;

开发者ID:Alexandr1987，项目名称:news，代码行数:31，代码来源:index.php

示例8: get_sql

?>
" name="pid" id="pid">
	   <div data-role="controlgroup" data-type="horizontal" align="center"> 
    <input type="submit" name="modbtn2" id="modbtn2" value="保存小记" />
    <input type="button" name="modbtn2" id="modbtn2" onclick="location.href='mcustomer_add.php?act=mod2&id=<?php 
echo $id;
?>
';" value="客户信息" />
    </div>
  </form>  
   
   
     	<?php 
$page = $_GET['page'] ? $_GET['page'] : 1;
$page_size = 20;
$sqlstr = get_sql("select * from {pre}services where isdel=0 and fid=" . $id . " order by id desc");
$s_list = $db->selectLimit($sqlstr, $page_size, ($page - 1) * $page_size);
$total_nums = $db->getRowsNum($sqlstr);
?>
			
	<ul data-role="listview" data-inset="true">		
  <?php 
$i = 0;
foreach ($s_list as $lists) {
    $i = $i + 1;
    $remindTime = $lists['remindTime'];
    $dateline = $lists['dateline'];
    ?>
  <li> 
  	<h2><?php 
    echo $i;

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:31，代码来源:mservice_add.php

示例9: install_done

 /**
  *    完成安装
  *
  *    @author    Garbin
  *    @return    void
  */
 function install_done()
 {
     extract($_POST);
     /* 无实际用途 */
     $_code = rand(10000, 99999);
     setcookie('__INTECODE__', $_code, 0, '/');
     /* 连接数据库 */
     $con = mysql_connect($db_host . ':' . $db_port, $db_user, $db_pass);
     if (!$con) {
         show_process(r(get_lang('connect_db'), false), 'parent.show_warning("' . get_lang('connect_db_error') . '")');
         return false;
     }
     show_process(r(get_lang('connect_db'), true));
     $version = mysql_get_server_info();
     $charset = str_replace('-', '', CHARSET);
     if ($version > '4.1') {
         if ($charset != 'latin1') {
             mysql_query("SET character_set_connection={$charset}, character_set_results={$charset}, character_set_client=binary", $con);
         }
         if ($version > '5.0.1') {
             mysql_query("SET sql_mode=''", $con);
         }
     }
     /* 选择数据库 */
     $selected_db = mysql_select_db($db_name, $con);
     if (!$selected_db) {
         show_process(r(get_lang('selecte_db'), false), 'parent.show_warning("' . get_lang('selecte_db_error') . '");');
         return false;
     }
     /* 建立数据库结构 */
     show_process(r(get_lang('start_setup_db'), true));
     $sqls = get_sql(version_data('structure.sql'));
     foreach ($sqls as $sql) {
         $sql = replace_prefix('ecm_', $db_prefix, $sql);
         if (substr($sql, 0, 12) == 'CREATE TABLE') {
             $name = preg_replace("/CREATE TABLE `{$db_prefix}([a-z0-9_]+)` .*/is", "\\1", $sql);
             mysql_query(create_table($sql));
             show_process(r(sprintf(get_lang('create_table'), $name), true, 1));
         } else {
             mysql_query($sql, $con);
         }
     }
     /* 安装初始数据 TODO 暂时不完整 */
     $sqls = get_sql(version_data('initdata.sql'));
     //$password = md5($admin_pass);//不加密密码
     $password = md5($admin_name . md5($admin_pass));
     // $sqls[] = "INSERT INTO `ecm_member`(user_name, email, password, reg_time) VALUES('{$admin_name}', '{$admin_email}', '{$password}', " . gmtime() . ")";
     $sqls[] = "INSERT INTO `ecm_user` (`username`, `password`, `grade`, `name`, `gender`, `mobile`, `email`, `url`, `remark`) VALUES\r\n('{$admin_name}', '{$password}', 1, NULL, NULL, NULL, '{$admin_email}', NULL, NULL)";
     foreach ($sqls as $sql) {
         $rzt = mysql_query(replace_prefix('ecm_', $db_prefix, $sql), $con);
         if (!$rzt) {
             show_process(r(get_lang('install_initdata'), false), 'parent.show_warning("' . mysql_error() . '");');
             return false;
         }
     }
     if (mysql_errno()) {
         echo mysql_error();
     }
     show_process(r(get_lang('install_initdata'), true));
     /* 安装初始配置 */
     $db_config = "mysql://{$db_user}:{$db_pass}@{$db_host}:{$db_port}/{$db_name}";
     //$ecm_key   = get_ecm_key();
     //$mall_site_id = product_id();
     /*        save_config_file(array(
                 'SITE_URL'  => $site_url,
                 'DB_CONFIG'  => $db_config,
                 'DB_PREFIX'  => $db_prefix,
                 'LANG'  => LANG,
                 'COOKIE_DOMAIN'  => '',
                 'COOKIE_PATH'  => '/',
                 'ECM_KEY'  => $ecm_key,
                 'MALL_SITE_ID'  => $mall_site_id,
                 'ENABLED_GZIP'  => 0,
                 'DEBUG_MODE'  => 0,
                 'CACHE_SERVER'  => 'default',
                 'MEMBER_TYPE'  => 'default',
                 'ENABLED_SUBDOMAIN' => 0,
                 'SUBDOMAIN_SUFFIX'  => '',
             ));*/
     save_config_file(array('autoload_enable' => true, 'autoload_path' => '@modules', 'framework_function' => 'front::main', 'framework_enable' => true, 'framework_module' => '[go]!(self)|welcome', 'framework_action' => '[do]|index', 'template_path' => '@templates/', 'connect_server' => $db_host, 'connect_username' => $db_user, 'connect_password' => $db_pass, 'connect_dbname' => $db_name, 'connect_port' => $db_port, 'connect_charset' => 'UTF8', 'prefix_search' => $db_prefix, 'prefix_replace' => $db_prefix, 'extension_path' => '@includes', 'extension_enable' => 'myfunction', 'debug_enable' => false, 'sql_format' => false, 'debug_file' => '', 'front_action' => '', 'front_online' => 'online', 'front_class' => 'user', 'front_table' => $db_prefix . 'user', 'front_fuzzy' => '', 'front_username' => '', 'front_password' => '', 'front_redirect' => 'index.php'));
     /* 写入系统信息 */
     // save_system_info(array(
     //     'version'   => VERSION,
     //     'release'   => RELEASE,
     // ));
     show_process(r(get_lang('setup_config'), true));
     /* 锁定安装程序 */
     touch(LOCK_FILE);
     show_process(r(get_lang('lock_install'), true));
     /* 安装完成 */
     show_process(r(get_lang('install_done'), true), 'parent.install_successed();');
     return false;
 }

开发者ID:antsmallant，项目名称:coreapp，代码行数:99，代码来源:install.php

示例10: session_start

<?php

session_start();
require '../session.php';
include '../inc/const.php';
$fid = getvar("fid");
$page = getvar("page") ? getvar("page") : 1;
$page_size = 20;
$sqlstr = get_sql("select * from {pre}area order by rank asc,id asc");
$area_list = $db->selectLimit($sqlstr, $page_size, ($page - 1) * $page_size);
$total_nums = $db->getRowsNum($sqlstr);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<link href="../css/admin_css.css" rel="stylesheet" type="text/css" />
</head>
<script>
function checkreg()
{
if (document.myform.name.value=="") {
	window.alert("类别名称不能为空！！");
	document.myform.name.focus();		
	 return (false);
	}
if (document.myform.rank.value=="") {
	window.alert("排序ID不能为空！！");
	document.myform.rank.focus();		
	 return (false);

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:31，代码来源:customer_area.php

示例11: _run_sql

 function _run_sql($sqls)
 {
     if (is_string($sqls)) {
         $sqls = get_sql($sqls);
     }
     if (!is_array($sqls)) {
         return true;
     }
     foreach ($sqls as $sql) {
         //$sql = replace_prefix('ecm_', DB_PREFIX, $sql);
         substr($sql, 0, 12) == 'CREATE TABLE' && ($sql = create_table($sql));
         $query = $this->db->query($sql, 'SILENT');
         if (!$query) {
             $this->_error($this->db->error());
             return false;
         }
     }
     return true;
 }

开发者ID:dongfeihu，项目名称:estore，代码行数:19，代码来源:upgrader.base.php

示例12: getvar

if (document.myform.password.value!=document.myform.password1.value){
	window.alert("两次输入的密码不一样!!");
	document.myform.password.focus();
	document.myform.password1.value=="";	
	return (false);
	}
	return true;
}
</script>
<link href="../css/admin_css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="98%" height="101" border="0" cellpadding="3" cellspacing="1" bgcolor="#cccccc" style="margin:0 auto;padding-top:10px;">
<?php 
$id = getvar('id');
$list = $db->getOneRow(get_sql("select * from {pre}manager where id = " . $id));
?>
  <form name="myform" action="admin_ok.php?act=mod" method="POST" onSubmit="return checkreg();">
    <tr>
      <td height="24" colspan="2" bgcolor="#555555"><font color="#FFFFFF">&nbsp;<strong>管理员密码修改</strong></font></td>
    </tr>
    <tr>
      <td width="13%" height="24" align="right" valign="middle" bgcolor="#f8f8f8">用户名：</td>
      <td width="87%" height="24" align="left" valign="middle" bgcolor="#f8f8f8"><input name="username" type="text" id="username" size="50" value="<?php 
echo $list['username'];
?>
" /></td>
    </tr>
    <tr>
      <td width="13%" height="24" align="right" valign="middle" bgcolor="#f8f8f8">请输入密码：</td>
      <td width="87%" height="24" align="left" valign="middle" bgcolor="#f8f8f8"><input name="password" type="password" id="password" onblur="if(this.value==''){this.value='<?php

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:31，代码来源:admin_mod.php

示例13: session_start

<?php

session_start();
require '../session.php';
include '../inc/const.php';
$fid = getvar("fid");
$page = getvar("page") ? getvar("page") : 1;
$page_size = 20;
$sqlstr = get_sql("select * from {pre}industry order by rank asc,id asc");
$area_list = $db->selectLimit($sqlstr, $page_size, ($page - 1) * $page_size);
$total_nums = $db->getRowsNum($sqlstr);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<link href="../css/admin_css.css" rel="stylesheet" type="text/css" /></head>
<script>
function checkreg()
{
if (document.myform.name.value=="") {
	window.alert("类别名称不能为空！！");
	document.myform.name.focus();		
	 return (false);
	}
if (document.myform.rank.value=="") {
	window.alert("排序ID不能为空！！");
	document.myform.rank.focus();		
	 return (false);
	}

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:31，代码来源:customer_industry.php

示例14: session_start

<?php

session_start();
require '../session.php';
include '../inc/const.php';
$page = $_GET['page'] ? $_GET['page'] : 1;
$page_size = 10;
$manager_type = $_SESSION['supermanager'] + 1;
$sqlstr = get_sql("select a.id,username,supermanager,usermenu,loginip,logintime,logincount,a.pid as pid from {pre}manager a order by a.id desc");
$manager_list = $db->selectLimit($sqlstr, $page_size, ($page - 1) * $page_size);
$total_nums = $db->getRowsNum($sqlstr);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<link href="../css/admin_css.css" rel="stylesheet" type="text/css" />
<link href="../js/boxy.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="98%" height="101" border="0" cellpadding="3" cellspacing="1" bgcolor="#cccccc" style="margin:0 auto;padding-top:10px;">
  <tr>
    <td height="22" colspan="9" bgcolor="#555555"><font color="#FFFFFF">&nbsp;<strong>管理</strong></font></td>
  </tr>
  <tr>
    <td width="4%" height="24" align="center" valign="middle" bgcolor="#f8f8f8">ID</td>
    <td width="10%" height="24" align="center" valign="middle" bgcolor="#f8f8f8">用户名</td>     
    <td width="13%" height="24" align="center" valign="middle" bgcolor="#f8f8f8">姓名</td>
    <td width="15%" align="center" valign="middle" bgcolor="#f8f8f8">组别</td>
    <td width="15%" align="center" valign="middle" bgcolor="#f8f8f8">上级领导</td>

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:31，代码来源:admin_manage.php

示例15: get_sql

      <td width="87%" height="24" align="left" valign="middle" bgcolor="#f1f1f1"><input name="name" type="text" id="name" size="30" /></td>
    </tr>
    <tr>
      <td width="13%" height="24" align="right" valign="middle" bgcolor="#f1f1f1">排序ID：</td>
      <td width="87%" height="24" align="left" valign="middle" bgcolor="#f1f1f1"><input name="rank" type="text" id="rank" size="20" value="0" /></td>
    </tr>
    <tr>
      <td height="24" bgcolor="#f1f1f1">&nbsp;</td>
      <td height="24" bgcolor="#f1f1f1"><input type="submit" name="button" id="button" value="提交" /> <input type="button" name="back" id="back" value="返回" onclick="javascript:window.history.go(-1);" /></td>
    </tr>
  </form>
</table>
<?php 
}
if ($act == "mod") {
    $sql = get_sql("select id,name,fid,rank from {pre}area where id=" . $id);
    $list = $db->getonerow($sql);
    ?>
<table width="98%" height="126" border="0" cellpadding="3" cellspacing="1" bgcolor="#cccccc" style="margin:0 auto;padding-top:10px;">
  <form name="myform" action="customer_area_ok.php?act=mod" method="post" onSubmit="return checkreg();">
    <tr>
      <td height="24" colspan="2" bgcolor="#555555"><font color="#FFFFFF">&nbsp;<strong>修改地区</strong></font></td>
    </tr>
    <tr>
      <td width="13%" height="24" align="right" valign="middle" bgcolor="#f1f1f1">上级地区：</td>
      <td width="87%" height="24" align="left" valign="middle" bgcolor="#f1f1f1"><select name="fid">
          <option value="0">--顶级地区--</option>
          <?php 
    getCategorySelect("area", $fid);
    ?>
        </select>      </td>

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:31，代码来源:customer_area_action.php

示例16: exploit_reviews

function exploit_reviews($f)
{
    global $fld1, $fld2, $url;
    $u = $url . "index.php?ind=reviews&op=update_file&iden=";
    $sql = get_sql($f);
    $inj = sprintf($sql, $fld1);
    $var1 = exploit_init_blind($f, $u, $inj, $fld1);
    $inj = sprintf($sql, $fld2);
    $var2 = exploit_init_blind($f, $u, $inj, $fld2);
    return $var1 . " " . $var2;
}

开发者ID:SuperQcheng，项目名称:exploit-database，代码行数:11，代码来源:4179.php

示例17: get_sql

<link rel="stylesheet" href="/jquerymobile/jquery.mobile-1.3.2.min.css">
<script src="/jquerymobile/jquery-1.8.3.min.js"></script>
<script src="/jquerymobile/jquery.mobile-1.3.2.min.js"></script>
</head>
<body> 
<div data-role="page"> 
    <div data-role="header" data-position="fixed">
		<a href="../cm.php" data-icon="home"  data-ajax="false" >首页</a><h1>明星榜</h1>
	</div>
   <div data-role="content"  style="margin-top:0px;">
    	 <ul data-role="listview" data-inset="true"> 
    	<?php 
if ($type == "00") {
    $sqlstr = get_sql("SELECT CREATEUSER,COUNT(*) as c FROM {pre}customer WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= DATE(createTime) GROUP BY CREATEUSER");
} else {
    $sqlstr = get_sql("SELECT userid as CREATEUSER,COUNT(*) AS c FROM {pre}services WHERE isdel=0 and type='" . $type . "' and DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= DATE(dateline) GROUP BY userid");
}
//echo $sqlstr;
$list = $db->getList($sqlstr);
foreach ($list as $c) {
    ?>
  
      <li><a href="#"><?php 
    echo $c['CREATEUSER'];
    ?>
<span class="ui-li-count"><?php 
    echo $c['c'];
    ?>
</span></a></li> 
  <?php 
}

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:31，代码来源:mcustomer_workload.php

示例18: array

         $isvalid = false;
         $data = $db->getonerow($sql);
         //更新电话等信息
         $record = array('companyName' => $companyName, 'name' => $name, 'addr' => $addr, 'tel' => $tel, 'mobile' => $mobile, 'email' => $email, 'qq' => $qq, 'url' => $url, 'remark' => $remark, 'createTime' => date('Y-m-d h-m-s'));
         $db->update($GLOBALS[databasePrefix] . 'pool', $record, 'id=' . $data["id"]);
     }
     if (trim($email) != "") {
         $sql = get_sql("select id from {pre}pool where email='" . $email . "'");
         $rows = $db->getRowsNum($sql);
         if ($rows > 0) {
             $errmsg = $errmsg . "电子邮件已经存在了";
             $isvalid = false;
         }
     }
     if (trim($mobile) != "") {
         $sql = get_sql("select id from {pre}pool where mobile='" . $mobile . "'");
         $rows = $db->getRowsNum($sql);
         if ($rows > 0) {
             $errmsg = $errmsg . "手机号码存在了";
             $isvalid = false;
         }
     }
     if ($isvalid) {
         $record = array('companyName' => $companyName, 'name' => $name, 'addr' => $addr, 'tel' => $tel, 'mobile' => $mobile, 'email' => $email, 'qq' => $qq, 'url' => $url, 'remark' => $remark, 'createTime' => date('Y-m-d h-m-s'));
         $id = $db->insert($GLOBALS[databasePrefix] . 'pool', $record);
         $okcount = $okcount + 1;
     } else {
         echo $row . ".[" . $companyName . "]没有导入成功！>>>" . $errmsg . "<br>";
         $faultcount = $faultcount + 1;
     }
 }

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:31，代码来源:upload2.php

示例19: Product

 function Product($id)
 {
     $this->{$id} = $id;
     $query = "select name, description, price, stock, picture_id from products where id={$id}";
     get_sql($query);
 }

开发者ID:jabeck，项目名称:website-code，代码行数:6，代码来源:product.php

示例20: get_sql

      <td width="87%" height="24" align="left" valign="middle" bgcolor="#f1f1f1"><input name="name" type="text" id="name" size="30" /></td>
    </tr>
    <tr>
      <td width="13%" height="24" align="right" valign="middle" bgcolor="#f1f1f1">排序ID：</td>
      <td width="87%" height="24" align="left" valign="middle" bgcolor="#f1f1f1"><input name="rank" type="text" id="rank" size="20" value="0" /></td>
    </tr>
    <tr>
      <td height="24" bgcolor="#f1f1f1">&nbsp;</td>
      <td height="24" bgcolor="#f1f1f1"><input type="submit" name="button" id="button" value="提交" /> <input type="button" name="back" id="back" value="返回" onclick="javascript:window.history.go(-1);" /></td>
    </tr>
  </form>
</table>
<?php 
}
if ($act == "mod") {
    $sql = get_sql("select id,name,fid,rank from {pre}services where id=" . $id);
    $list = $db->getonerow($sql);
    ?>
<table width="98%" height="126" border="0" cellpadding="3" cellspacing="1" bgcolor="#cccccc" style="margin:0 auto;padding-top:10px;">
  <form name="myform" action="customer_services_ok.php?act=mod" method="post" onSubmit="return checkreg();">
    <tr>
      <td height="24" colspan="2" bgcolor="#555555"><font color="#FFFFFF">&nbsp;<strong>修改服务</strong></font></td>
    </tr>
    <tr>
      <td width="13%" height="24" align="right" valign="middle" bgcolor="#f1f1f1">上级服务：</td>
      <td width="87%" height="24" align="left" valign="middle" bgcolor="#f1f1f1"><select name="fid">
          <option value="0">--顶级类别--</option>
          <?php 
    getCategorySelect("services", $fid);
    ?>
        </select>      </td>

开发者ID:sdgdsffdsfff，项目名称:crm，代码行数:31，代码来源:customer_services_action.php

注：本文中的get_sql函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP get_sql_condition_FandF函数代码示例发布时间：2022-05-15

PHP get_spip_doc函数代码示例发布时间：2022-05-15

CVE-2022-30203

1 PacktPublishing/Python-Machine-Learning-

PacktPublishing/Python-Machine-Learning-Second-Edition: Python Machine Learning

阅读：975|2022-08-18

2 鲁东大学一米网:Win7系统USB驱动器RAM的操

win7系统电脑使用过程中有不少朋友表示遇到过win7系统USB驱动器RAM的状况，当出现win7

阅读：891|2022-11-06

3 elipapa/markdown-cv: a simple template t

elipapa/markdown-cv: a simple template to write your CV in a readable markdown f

阅读：514|2022-08-17

4 卡莉·蕾·吉普森是谁?不雅录像是怎么回事?

Call Me Maybe 中英字幕对于加拿大歌手卡莉·蕾·吉普森很多人有些陌生，她隶属于贾

阅读：632|2022-11-06

客服电话

电子邮件

PHP get_sql函数代码示例

示例1: login

示例2: check_username

示例3: _run_sql

示例4: index

示例5: getCategoryMenu

示例6: login

示例7: get_sql

示例8: get_sql

示例9: install_done

示例10: session_start

示例11: _run_sql

示例12: getvar

示例13: session_start

示例14: session_start

示例15: get_sql

示例16: exploit_reviews

示例17: get_sql

示例18: array

示例19: Product

示例20: get_sql

请发表评论

全部评论

上一篇：

下一篇：

bradtraversy/iweather: Ionic 3 mobile we

CVE-2022-2342

joaomh/curso-de-matlab

断牙刷新位置时间（断牙属性及刷新位置介绍

Yalantis/uCrop: Image Cropping Library f

CVE-2022-30203

PacktPublishing/Python-Machine-Learning-

altair-viz/altair: Declarative statistic

sussillo/hfopt-matlab: A parallel, cpu-b

鲁东大学一米网:Win7系统USB驱动器RAM的操

emersion/go-ostatus: An OStatus library

关于我们

产品与服务

解决方案

139-2527-9053