15、sql语句集，Linux 下PHP查询mysql

一、mysql 创建数据库

mysql密码，默认没有

如果想更改的话， mysqladmin -uroot   password root123

登录   ： [root@localhost root]#   mysql    -uroot    -proot123

1、创建book数据库

mysql>   create   database   book;
Query OK, 1 row affected (0.08 sec)

2、授权给 lili 用户

mysql> grant   all   on   book.*   to   lili@localhost   identified   by   "lili123";
Query OK, 0 rows affected (0.06 sec)

mysql> exit
Bye

3、lili登录

创建lili用户

[root@localhost html]#   mysql   -u   lili    -p
Enter password:       （这里输密码）
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.54

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

4、创建book表，添加数据

mysql> use book;    （先确定要操作的数据库）
Database changed

5、创建book表

mysql> create   table   book(
    -> id   int   not   null,
    -> name   char(20)   not   null,
    -> primary   key(id)
    -> );
Query OK, 0 rows affected (0.08 sec)

6、添加数据

mysql> insert   into   book   values

-> (1,"语文"),
    -> (2,"数学"),
    -> (3,"英语");
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

（注意：上面操作也可以用sql语句集来执行： (好处是，去别的机子也可以执行sql语句集就行，不用从头打过)

[root@localhost html]# cat > lili.sql
use   book;
create   table   book(
    id   int   not   null,
    name   char(20)   not null,
    primary   key(id)
    );
insert   into book values
     (1,"语文",),
     (2,"数学"),
     (3,"英语");

[root@localhost html]# vi root.sql
create   database   book;
grant   all   on   book.*   to   lili@localhost   identified   by   "lili123" ;

[root@localhost html]# mysql   -u   root   -p   <   root.sql
Enter password:

[root@localhost html]# mysql   -u   lili   -p   <   lili.sql
Enter password:

）

7、查询表

mysql> select   *   from   book;
+----+--------+
| id | name   |
+----+--------+
| 1 | 语文 |
| 2 | 数学 |
| 3 | 英语 |
+----+--------+

退出mysql
mysql> exit;
Bye

如果想直接命令行查询

[root@localhost root]# echo "select * from book;" | mysql -u lili -p book

Enter password:
id name
1 语文
2 数学
3 英语

二、在 /var/www/html 中创建index.php

[root@localhost html]# vi index.php

<h1>

<?php

   mysql_connect(NULL,"lili","lili123","localhost");

   mysql_selectdb("book");

   $sql="select * from book";

   $res=mysql_query($sql);

   while($row=mysql_fetch_row($res)){

      print "$row[0] $row[1]<br/>";

              }

      $a=array("阳光","沙滩","海浪","仙人掌");

      for($i=0;$i<4;$i++){

        print "$a[$i]<br/>";

              }

?>

</h1>

在浏览器输入 http://192.168.170.3/ , 结果如下：

如果想要网格线

<html>

<title>

</title>

<body>

<h1>

<?php

   mysql_connect(NULL,"lili","lili123","localhost");

   mysql_selectdb("book");

   $sql="select * from book";

   $res=mysql_query($sql);

   print ('<table border=1>');

   while($row=mysql_fetch_row($res)){

     print ('<tr>');

     for($i=0;$i<3;$i++){

        print "<td>$row[$i]</td>";

      }

    print ('</tr>');

              }

     print ('</table>');

      $a=array("阳光","沙滩","海浪","仙人掌");

       for($i=0;$i<4;$i++){

              print "$a[$i]<br/>";

                 }

?>

</h1>

</body>

</html>

效果如下：

巴特西

15、sql语句集，Linux 下PHP查询mysql

最新文章

热门文章