chksqlv PHP Code Examples

Example #1

0

Show file

File: index.php Project: lyhiving/mini_class

/**
 * 迷你同学录 (http://mini_class.piscdong.com/)
 * (c)PiscDong studio (http://www.piscdong.com/)
 *
 * 程序完全免费，请保留这段代码。
 * 请勿出售本程序或其修改版，请勿利用本程序或其修改版进行任何商业活动。
 */
require_once 'inc.php';
if (!file_exists($l_file)) {
    echo getstop();
    if (!file_exists($c_file)) {
        if ($_SERVER['REQUEST_METHOD'] == 'POST' && $_POST['hostname'] != '' && $_POST['database'] != '' && $_POST['username'] != '') {
            if (@mysql_connect($_POST['hostname'], $_POST['username'], $_POST['password'])) {
                if (mysql_select_db($_POST['database']) || mysql_query('CREATE DATABASE ' . $_POST['database'])) {
                    $c_content = "<?php\n\$hostname_conn='" . $_POST['hostname'] . "';\n\$database_conn='" . $_POST['database'] . "';\n\$username_conn='" . $_POST['username'] . "';\n\$password_conn='" . $_POST['password'] . "';\n\$dbprefix='" . $_POST['dbprefix'] . "';\n\$conn=mysql_connect(\$hostname_conn, \$username_conn, \$password_conn) or die('');\nmysql_select_db(\$database_conn, \$conn);" . (chksqlv() ? "\nmysql_query(\"SET NAMES 'utf8'\", \$conn);\n\$charset_conn=1;" : '') . "\n?>";
                    writeText($c_file, $c_content);
                } else {
                    $e = 1;
                }
            } else {
                $e = 2;
            }
            echo '<script type="text/javascript">' . (isset($e) ? 'location.href=\'?e=' . $e : 'location.href=\'mysql.php') . '\';</script>';
        } else {
            if (isset($_GET['e'])) {
                $msg = $_GET['e'] == 2 ? '无法连接数据库！' : '无法建立数据库！';
            }
            if (isset($msg)) {
                echo '<div class="msg_v">' . $msg . '</div>';
            }

Example #2

0

Show file

File: mysql.php Project: lyhiving/mini_class

 $query = "create table {$dbprefix}message (\r\nid int(10) NOT NULL auto_increment,\r\naid int(10) NOT NULL default '0',\r\ntid int(10) NOT NULL default '0',\r\ndatetime int(15) NOT NULL default '0',\r\nreaded int(5) NOT NULL default '0',\r\ncontent text NOT NULL,\r\nPRIMARY KEY (`id`)\r\n) " . (chksqlv() ? 'ENGINE=MyISAM DEFAULT CHARSET=utf8' : 'type=MyISAM');
 $result = mysql_query($query);
 echo '<li>建立数据表 ' . $dbprefix . 'message：<span style="font-weight:bold;color:#' . ($result == true ? '036;">成功' : 'f00;">失败') . '</span></li>';
 unset($query);
 unset($result);
 $query = "create table {$dbprefix}adminop (\r\nid int(10) NOT NULL auto_increment,\r\naid int(10) NOT NULL default '0',\r\nsid int(10) NOT NULL default '0',\r\ntid int(5) NOT NULL default '0',\r\ndatetime int(15) NOT NULL default '0',\r\ncontent text NOT NULL,\r\nPRIMARY KEY (`id`)\r\n) " . (chksqlv() ? 'ENGINE=MyISAM DEFAULT CHARSET=utf8' : 'type=MyISAM');
 $result = mysql_query($query);
 echo '<li>建立数据表 ' . $dbprefix . 'adminop：<span style="font-weight:bold;color:#' . ($result == true ? '036;">成功' : 'f00;">失败') . '</span></li>';
 unset($query);
 unset($result);
 $query = "create table {$dbprefix}link (\r\nid int(10) NOT NULL auto_increment,\r\ntitle varchar(255) NOT NULL,\r\nurl varchar(255) NOT NULL,\r\nthread int(10) NOT NULL default '0',\r\nPRIMARY KEY (`id`)\r\n) " . (chksqlv() ? 'ENGINE=MyISAM DEFAULT CHARSET=utf8' : 'type=MyISAM');
 $result = mysql_query($query);
 echo '<li>建立数据表 ' . $dbprefix . 'link：<span style="font-weight:bold;color:#' . ($result == true ? '036;">成功' : 'f00;">失败') . '</span></li>';
 unset($query);
 unset($result);
 $query = "create table {$dbprefix}skin (\r\nid int(10) NOT NULL auto_increment,\r\npath varchar(255) NOT NULL,\r\ntitle varchar(255) default NULL,\r\nsfile varchar(255) NOT NULL,\r\nPRIMARY KEY (`id`)\r\n) " . (chksqlv() ? 'ENGINE=MyISAM DEFAULT CHARSET=utf8' : 'type=MyISAM');
 $result = mysql_query($query);
 echo '<li>建立数据表 ' . $dbprefix . 'skin：<span style="font-weight:bold;color:#' . ($result == true ? '036;">成功' : 'f00;">失败') . '</span></li>';
 unset($query);
 unset($result);
 $title = htmlspecialchars(trim($_POST['title']), ENT_QUOTES);
 $query = sprintf('insert into %s (title) values (%s)', $dbprefix . 'main', SQLString($title, 'text'));
 $result = mysql_query($query);
 echo '<li>写入新数据 ' . $dbprefix . 'main：<span style="font-weight:bold;color:#' . ($result == true ? '036;">成功' : 'f00;">失败') . '</span></li>';
 unset($query);
 unset($result);
 $username = trim($_POST['username']);
 $password = enc_p(trim($_POST['password']));
 $name = htmlspecialchars(trim($_POST['name']), ENT_QUOTES);
 $query = sprintf('insert into %s (username, password, name, power, regdate) values (%s, %s, %s, 9, %s)', $dbprefix . 'member', SQLString($username, 'text'), SQLString($password, 'text'), SQLString($name, 'text'), time());
 $result = mysql_query($query);

Example #3

0

Show file

File: function.php Project: omusico/jianli

        $ip = trim($arr[0]);
    } elseif (isset($_SERVER['HTTP_CLIENT_IP'])) {
        $ip = $_SERVER['HTTP_CLIENT_IP'];
    } elseif (isset($_SERVER['REMOTE_ADDR'])) {
        $ip = $_SERVER['REMOTE_ADDR'];
    }
    // IP地址合法验证
    $long = sprintf("%u", ip2long($ip));
    $ip = $long ? array($ip, $long) : array('0.0.0.0', 0);
    return $ip[$type];
}
function chksqlv()
{
    return version_compare(mysql_get_server_info(), '4.1.0', '>=');
}
if (chksqlv()) {
    mysql_query("SET NAMES 'utf8'", $conn);
    $charset_conn = 1;
}
$q_main = sprintf('select * from %s limit 1', $yjl_dbprefix . 'main');
$main = mysql_query($q_main) or die(mysql_error());
$r_main = mysql_fetch_assoc($main);
mysql_free_result($main);
//$d_l1id=175;
//$d_l1title='杭州市';
$p_size = 20;
$max_file = 1024 * 2;
$u_ea = array('jpg', 'gif', 'png');
$u_jlea = array('jpg', 'doc', 'docx', 'pdf');
$a_filet = array('image/jpeg', 'application/msword', 'application/msword', 'application/pdf');
$a_wh_wbtp = array(80, 80);

PHP chksqlv Examples