常用功能

The Ghost Atrox

查 select * from msg;
增 insert into msg (content,user,intime) values ('x','admin',222);
改 update msg set content="okok" where id =1;
删 delete from msg where id =0;$host='127.0.0.1';
$user='roots';
$pwd='sssss';
$dbname='php1025s';

$coon=new mysqli($host,$user,$pwd);
if($coon->connect_error)
{
        echo 'error' .$coon->connect_error;
        return 0;
}
echo 'coon success';
$db=new mysqli($host,$user,$pwd,$dbname);
if($db->connect_error<>0)
{
        echo 'dsaojdsaojdosa';
}
#尝试创建数据库
$time = time();
$sql="INSERT INTO msg (content,user,intime) values ('{$content}','{$user1}','{$time}')";
$db->query($sql);
?>

The Ghost Atrox

<?php
$host='127.0.0.1';
$user='root';
$pwd='phptest';
$dbname='php1025';

$coon=new mysqli($host,$user,$pwd);
if($coon->connect_error)
{
        echo 'error' .$coon->connect_error;
        return 0;
}
echo 'success,try to create a database!' .'<br>';
#尝试创建数据库
$sql='CREATE DATABASE OKDATABASE';
if ($coon->query($sql)===TRUE){
        echo "database create success";
}
else{
        echo 'errord' .$coon->error;
}
$coon->close();
exit;
?>