正文
php读取cpu数据库 php读取数据表内容
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
php+mysql如何读取数据库数据
大概的基本流程如下：
连接数据库，再加一个判断。
选择数据库
读取表
输出表中数据
下面是代码：
?php
$con = mysql_connect("localhost","root","abc123");
/* localhost 是服务器 root 是用户名 abc123 是密码*/
if (!$con)
{
die("数据库服务器连接失败");
}
/* 这就是一个逻辑非判断，如果错误就输出括号里的字符串 */
@mysql_select_db("a", $con);
/* 选择mysql服务器里的一个数据库,假设你的数据库名为 a*/
$sql = "SELECT * FROM qq";
/* 定义变量sql, "SELECT * FROM qq" 是SQL指令，表示选取表qq中的数据 */
$result = mysql_query($sql); //执行SQL语句，获得结果集
/*下面就是选择性的输出打印了，由于不清楚你的具体情况给你个表格打印吧*/
//打印表格
echo "table border=1";
while( $row = mysql_fetch_array($result) )
/*逐行获取结果集中的记录，得到数组row */
{
/*数组row的下标对应着数据库中的字段值 */
$id = $row['id'];
$name = $row['name'];
$sex = $row['sex'];
echo "tr";
echo "td$id/td";
echo "td$name/td";
echo "td$sex/td";
echo "/tr";
}
echo "table /";
?
如果你的switch是表头，就定义这个表头字段，然后输出。
相关问答
Q1: php的服务器cpu数量怎么获取
?php
header("Content-type: text/html; charset=utf-8");
error_reporting(E_ALL ^ E_DEPRECATED);
//linux系统探测
function sys_linux() {
// CPU
if (false === ($str = @file("/proc/cpuinfo"))) return false;
$str = implode("", $str);
@preg_match_all("/model\s+name\s{0,}\:+\s{0,}([\w\s\)\(\@.-]+)([\r\n]+)/s", $str, $model);
@preg_match_all("/cpu\s+MHz\s{0,}\:+\s{0,}([\d\.]+)[\r\n]+/", $str, $mhz);
@preg_match_all("/cache\s+size\s{0,}\:+\s{0,}([\d\.]+\s{0,}[A-Z]+[\r\n]+)/", $str, $cache);
@preg_match_all("/bogomips\s{0,}\:+\s{0,}([\d\.]+)[\r\n]+/", $str, $bogomips);
if (false !== is_array($model[1])) {
$res['cpu']['num'] = sizeof($model[1]);
$res['cpu']['num_text'] = str_replace(array(1,2,4,8,16), array('单','双','四','八','十六'), $res['cpu']['num']).'核';
/*
for($i = 0; $i $res['cpu']['num']; $i++) {
$res['cpu']['model'][] = $model[1][$i].'nbsp;('.$mhz[1][$i].')';
$res['cpu']['mhz'][] = $mhz[1][$i];
$res['cpu']['cache'][] = $cache[1][$i];
$res['cpu']['bogomips'][] = $bogomips[1][$i];
}*/
$x1 = ($res['cpu']['num']==1) ? '' : ' ×'.$res['cpu']['num'];
$mhz[1][0] = ' | 频率:'.$mhz[1][0];
$cache[1][0] = ' | 二级缓存:'.$cache[1][0];
$bogomips[1][0] = ' | Bogomips:'.$bogomips[1][0];
$res['cpu']['model'][] = $model[1][0].$mhz[1][0].$cache[1][0].$bogomips[1][0].$x1;
if (false !== is_array($res['cpu']['model'])) $res['cpu']['model'] = implode("br /", $res['cpu']['model']);
if (false !== is_array($res['cpu']['mhz'])) $res['cpu']['mhz'] = implode("br /", $res['cpu']['mhz']);
if (false !== is_array($res['cpu']['cache'])) $res['cpu']['cache'] = implode("br /", $res['cpu']['cache']);
if (false !== is_array($res['cpu']['bogomips'])) $res['cpu']['bogomips'] = implode("br /", $res['cpu']['bogomips']);
}
// NETWORK
// UPTIME
if (false === ($str = @file("/proc/uptime"))) return false;
$str = explode(' ', implode("", $str));
$str = trim($str[0]);
$min = $str / 60;
$hours = $min / 60;
$days = floor($hours / 24);
$hours = floor($hours - ($days * 24));
$min = floor($min - ($days * 60 * 24) - ($hours * 60));
if ($days !== 0) $res['uptime'] = $days."天";
if ($hours !== 0) $res['uptime'] .= $hours."小时";
$res['uptime'] .= $min."分钟";
// MEMORY
if(false === ($str = @file("/proc/meminfo"))) return false;
$str = implode("", $str);
preg_match_all("/MemTotal\s{0,}\:+\s{0,}([\d\.]+).+?MemFree\s{0,}\:+\s{0,}([\d\.]+).+?Cached\s{0,}\:+\s{0,}([\d\.]+).+?SwapTotal\s{0,}\:+\s{0,}([\d\.]+).+?SwapFree\s{0,}\:+\s{0,}([\d\.]+)/s", $str, $buf);
preg_match_all("/Buffers\s{0,}\:+\s{0,}([\d\.]+)/s", $str, $buffers);
$res['mem_total'] = round($buf[1][0]/1024, 2);
$res['mem_free'] = round($buf[2][0]/1024, 2);
$res['mem_buffers'] = round($buffers[1][0]/1024, 2);
$res['mem_cached'] = round($buf[3][0]/1024, 2);
$res['mem_used'] = $res['mem_total']-$res['mem_free'];
$res['mem_percent'] = (floatval($res['mem_total'])!=0)?round($res['mem_used']/$res['mem_total']*100,2):0;
$res['mem_real_used'] = $res['mem_total'] - $res['mem_free'] - $res['mem_cached'] - $res['mem_buffers']; //真实内存使用
$res['mem_real_free'] = $res['mem_total'] - $res['mem_real_used']; //真实空闲
$res['mem_real_percent'] = (floatval($res['mem_total'])!=0)?round($res['mem_real_used']/$res['mem_total']*100,2):0; //真实内存使用率
$res['mem_cached_percent'] = (floatval($res['mem_cached'])!=0)?round($res['mem_cached']/$res['mem_total']*100,2):0; //Cached内存使用率
$res['swap_total'] = round($buf[4][0]/1024, 2);
$res['swap_free'] = round($buf[5][0]/1024, 2);
$res['swap_used'] = round($res['swap_total']-$res['swap_free'], 2);
$res['swap_percent'] = (floatval($res['swap_total'])!=0)?round($res['swap_used']/$res['swap_total']*100,2):0;
// LOAD AVG
if (false === ($str = @file("/proc/loadavg"))) return false;
$str = explode(' ', implode("", $str));
$str = array_chunk($str, 4);
$res['load_avg'] = implode(' ', $str[0]);
return $res;
}
//FreeBSD系统探测
function sys_freebsd() {
//CPU
if (false === ($res['cpu']['num'] = get_key("hw.ncpu"))) return false;
$res['cpu']['num_text'] = str_replace(array(1,2,4,8,16), array('单','双','四','八','十六'), $res['cpu']['num']).'核';
$res['cpu']['model'] = get_key("hw.model");
//LOAD AVG
if (false === ($res['load_avg'] = get_key("vm.loadavg"))) return false;
//UPTIME
if (false === ($buf = get_key("kern.boottime"))) return false;
$buf = explode(' ', $buf);
$sys_ticks = time() - intval($buf[3]);
$min = $sys_ticks / 60;
$hours = $min / 60;
$days = floor($hours / 24);
$hours = floor($hours - ($days * 24));
$min = floor($min - ($days * 60 * 24) - ($hours * 60));
if ($days !== 0) $res['uptime'] = $days."天";
if ($hours !== 0) $res['uptime'] .= $hours."小时";
$res['uptime'] .= $min."分钟";
//MEMORY
if (false === ($buf = get_key("hw.physmem"))) return false;
$res['mem_total'] = round($buf/1024/1024, 2);
$str = get_key("vm.vmtotal");
preg_match_all("/\nVirtual Memory[\:\s]*\(Total[\:\s]*([\d]+)K[\,\s]*Active[\:\s]*([\d]+)K\)\n/i", $str, $buff, PREG_SET_ORDER);
preg_match_all("/\nReal Memory[\:\s]*\(Total[\:\s]*([\d]+)K[\,\s]*Active[\:\s]*([\d]+)K\)\n/i", $str, $buf, PREG_SET_ORDER);
$res['mem_real_used'] = round($buf[0][2]/1024, 2);
$res['mem_cached'] = round($buff[0][2]/1024, 2);
$res['mem_used'] = round($buf[0][1]/1024, 2) + $res['mem_cached'];
$res['mem_free'] = $res['mem_total'] - $res['mem_used'];
$res['mem_percent'] = (floatval($res['mem_total'])!=0)?round($res['mem_used']/$res['mem_total']*100,2):0;
$res['mem_real_percent'] = (floatval($res['mem_total'])!=0)?round($res['mem_real_used']/$res['mem_total']*100,2):0;
return $res;
}
//取得参数值 FreeBSD
function get_key($keyName) {
return do_command('sysctl', "-n $keyName");
}
//确定执行文件位置 FreeBSD
function find_command($commandName) {
$path = array('/bin', '/sbin', '/usr/bin', '/usr/sbin', '/usr/local/bin', '/usr/local/sbin');
foreach($path as $p) {
if (@is_executable("$p/$commandName")) return "$p/$commandName";
}
return false;
}
//windows系统探测
function sys_windows() {
if(PHP_VERSION = 5) {
$obj_locator = new COM("WbemScripting.SWbemLocator");
$wmi = $obj_locator-ConnectServer();
} else {
return false;
}
//CPU
$cpuinfo = GetWMI($wmi, "Win32_Processor", array("Name", "L2CacheSize", "NumberOfCores"));
$res['cpu']['num'] = $cpuinfo[0]['NumberOfCores'];
if (null == $res['cpu']['num']) {
$res['cpu']['num'] = 1;
}
$res['cpu']['num_text'] = str_replace(array(1,2,4,8,16), array('单','双','四','八','十六'), $res['cpu']['num']).'核';
/*
for ($i=0;$i$res['cpu']['num'];$i++) {
$res['cpu']['model'] .= $cpuinfo[0]['Name']."br /";
$res['cpu']['cache'] .= $cpuinfo[0]['L2CacheSize']."br /";
}*/
$cpuinfo[0]['L2CacheSize'] = ' ('.$cpuinfo[0]['L2CacheSize'].')';
$x1 = ($res['cpu']['num']==1) ? '' : ' ×'.$res['cpu']['num'];
$res['cpu']['model'] = $cpuinfo[0]['Name'].$cpuinfo[0]['L2CacheSize'].$x1;
//SYSINFO
$sysinfo = GetWMI($wmi, "Win32_OperatingSystem", array('LastBootUpTime','TotalVisibleMemorySize','FreePhysicalMemory','Caption','CSDVersion','SerialNumber','InstallDate'));
$sysinfo[0]['Caption']=iconv('GBK', 'UTF-8',$sysinfo[0]['Caption']);
$sysinfo[0]['CSDVersion']=iconv('GBK', 'UTF-8',$sysinfo[0]['CSDVersion']);
$res['win_n'] = $sysinfo[0]['Caption'].' '.$sysinfo[0]['CSDVersion']." 序列号:{$sysinfo[0]['SerialNumber']} 于".date('Y年m月d日H:i:s',strtotime(substr($sysinfo[0]['InstallDate'],0,14)))."安装";
//UPTIME
$res['uptime'] = $sysinfo[0]['LastBootUpTime'];
$sys_ticks = time() - strtotime(substr($res['uptime'], 0, 14));
$min = $sys_ticks / 60;
$hours = $min / 60;
$days = floor($hours / 24);
$hours = floor($hours - ($days * 24));
$min = floor($min - ($days * 60 * 24) - ($hours * 60));
if ($days !== 0) $res['uptime'] = $days."天";
if ($hours !== 0) $res['uptime'] .= $hours."小时";
$res['uptime'] .= $min."分钟";
//MEMORY
$res['mem_total'] = round($sysinfo[0]['TotalVisibleMemorySize']/1024,2);
$res['mem_free'] = round($sysinfo[0]['FreePhysicalMemory']/1024,2);
$res['mem_used'] = $res['mem_total']-$res['mem_free']; //上面两行已经除以1024,这行不用再除了
$res['mem_percent'] = round($res['mem_used'] / $res['mem_total']*100,2);
//LoadPercentage
$loadinfo = GetWMI($wmi, "Win32_Processor", array("LoadPercentage"));
$res['load_avg'] = $loadinfo[0]['LoadPercentage'];
return $res;
}
function GetWMI($wmi, $strClass, $strValue = array()) {
$arrData = array();
$objWEBM = $wmi-Get($strClass);
$arrProp = $objWEBM-Properties_;
$arrWEBMCol = $objWEBM-Instances_();
foreach($arrWEBMCol as $objItem) {
@reset($arrProp);
$arrInstance = array();
foreach($arrProp as $propItem) {
eval("\$value = \$objItem-" . $propItem-Name . ";");
if (empty($strValue)) {
$arrInstance[$propItem-Name] = trim($value);
} else {
if (in_array($propItem-Name, $strValue)) {
$arrInstance[$propItem-Name] = trim($value);
}
}
}
$arrData[] = $arrInstance;
}
return $arrData;
}
//根据操作系统取得CPU相关信息
switch(PHP_OS) {
case "Linux":
$sysReShow = (($sys_info = sys_linux()) !== false) ? "show" : "none";
break;
case "FreeBSD":
$sysReShow = (($sys_info = sys_freebsd()) !== false) ? "show" : "none";
break;
case "WINNT":
$sysReShow = (($sys_info = sys_windows()) !== false) ? "show" : "none";
break;
default:
break;
}
?
此PHP类，根据操作系统来进行判断。
调用?php echo '['.$sys_info['cpu']['num_text'].'] '.$sys_info['cpu']['model']; ?
Q2: php如何通过读取数据库？
php读取cpu数据库我建议一下吧php读取cpu数据库，文本数据库php读取cpu数据库的例子本来太多，但是为了逻辑简化，最好通过专门接口实现文件与数据php读取cpu数据库的转换，可以采用我下面的模板编写php读取cpu数据库：
?php
//文件最前面定义两个全局变量，数据库文件名和用户数组
$pwd_db_file='db.txt';
$UserPassword=array();
//下面的pwd_db_read函数，把文件内容读入到全局数组中
function pwd_db_read(){
global $pwd_db_file, $UserPassword;
$fp=fopen($pwd_db_file,'r');
while ($s=fgets($fp)){
list($usr,$pwd)=explode('|', $s);
$UserPassword[$usr]=$pwd;
}
fclose($fp);
}
//下面的pwd_db_write函数保存数组内容到文件中
function pwd_db_write(){
global $pwd_db_file, $UserPassword;
fp=fopen($pwd_db_file, 'w');
foreach ($UserPassword as $usr=$pwd)
fputs($fp,"$usr|$pwd\n");
fclose($fp);
}
//有了上面的全局变量和函数，要写什么功能都简单
//下面假释本脚本调用的时候通过reg.php?job=adduser=...pass=...
//的格式进行调用，job为add表示添加用户,del表示删除,modi表示修改
//另外的user和pass表示用户名或者密码，job不是以上内容表示登录
//主程序一开始就打开数据库
pwd_db_read();
//下面判断功能
if ($jon=='add'){
if (array_key_exists($user,$UserPassword)) echo "用户 $user 已经存在！"
else $UserPassword[$user]=$pass;//就一句话，简单吧
}elseif (job=='del'){
unset($UserPassword[$user]);//你自己考虑编写是否确认删除的内容
}elseif ($job=='modi'){
if (array_key_exists($user,$UserPassword)) $UserPassword[$user]=$pass;//和添加是不是有点类似
else echo "用户 $user 不存在！"
}else{
if ($UserPassword[$user]==$pass){
echo '密码正确。';
//接下来可能要做许多事情
}else echo '密码错误！';
}
//程序最后保存数据库修改
pwd_db_write();
?
看得懂吗，没有上机调试，语法问题可能难免，如果发现不明白的问题请补充。
Q3: php框架thinkphp3.2怎么读取数据库内容
先找到config.php文件,如图php读取cpu数据库：
然后打开配置文件并在其中配置数据库php读取cpu数据库的信息php读取cpu数据库，如下代码php读取cpu数据库：
?php
return array(
//'配置项'='配置值'
'DB_TYPE' = 'mysql', // 数据库类型
'DB_HOST' = '127.0.0.1', // 服务器地址
'DB_NAME' = 'tpshow', // 数据库名
'DB_USER' = 'root', // 用户名
'DB_PWD' = 'root', // 密码
'DB_PORT' = '3306', // 端口
'DB_PREFIX' = 'tp_' // 数据库表前缀
);
然后在应用的Home的Controller中php读取cpu数据库，如下图的文件
?php
namespace Home\Controller;
use Think\Controller;
class IndexController extends Controller {
public function index(){
$db = M("show"); // 实例化show对象
$data = $db-find();//读取一条数据
dump($data);//打印数据
}
}
Q4: PHP如何在windows下获取计算机的cpu和内存
在cmd下 用批处理语句获取windows的CPU 内存使用情况的语句，找下。
然后php有执行 OS 原生脚本的函数，跟你在CMD下执行一样。
执行完，获取返回的信息即可。
Q5: php读取数据库资料
修改一下你的程序，把下面这三行：
for($i=0;$imysql_num_fields($result);$i++)
{
echo "$row[$i]";
}
修改为：
for($i=0;$imysql_num_fields($result);$i++)
{
echo "$i = $row[$i]br";
}
你就知道是什么原因了。
或者下面这样：
echo "pre";
print_r($row);
echo "/pre";
php读取cpu数据库的介绍就聊到这里吧，感谢你花时间阅读本站内容，更多关于php读取数据表内容、php读取cpu数据库的信息别忘了在本站进行查找喔。
