几个环境测试的小脚本（备忘）

最新推荐文章于 2021-04-30 18:29:10 发布

原创最新推荐文章于 2021-04-30 18:29:10 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

本文通过运行特定PHP脚本来验证PHP安装、PHPMySQL扩展、PHPRedis扩展以及PythonMysqlDB驱动的正确性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、测试php安装是否正确

[root@jira121 auto_test_install_envirment]# more info.php

<?php phpinfo(); ?>

2、测试php mysql扩展安装是否正确

[root@jira121 auto_test_install_envirment]# more phpmysql.php
<?php
$dbh = new PDO("mysql:host=localhost;dbname=mysql","root","");
$query = "select * from user;";
$result = $dbh->query($query);
$rows = $result->fetchAll();
foreach($rows as $row)
{
$ym = $row[0];
$user = $row[1];
$ps = $row[2];
printf("id-".$ym." order_id-".$user." account_id-".$ps);
print("</br>");
}

$dbh = null;

3、测试php redis扩展安装是否正确

[root@jira121 auto_test_install_envirment]# more phpredis.php
<?php
$redis = new Redis();
$redis->connect('127.0.0.1',6379);
$redis->set('testkey',23);
echo $redis->get('testkey');
?>

4、测试python mysqldb驱动安装是否正确
[root@jira121 auto_test_install_envirment]# more test.py
#!/usr/bin/env python
# -*- coding: utf-8 -*-

import MySQLdb as msd

conn = msd.connect(host="127.0.0.1",user="root",passwd="root",db="test")

cursor = conn.cursor()

cursor.execute('select area_name, count(area_id) from baby_enum_area')
for i in cursor.fetchall():
print i
cursor.close()

conn.close()