搜尋
首頁後端開發php教程php 连接数据库解决思路

php 连接数据库
出错为:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in E:\phpser\AppServ\www\mzgz1.php on line 115
JpGraph Error: HTTP headers have already been sent.
Caused by output from file mzgz1.php at line 115. 
Explanation:
HTTP headers have already been sent back to the browser indicating the data as text before the library got a chance to send it's image HTTP header to this browser. This makes it impossible for the library to send back image data to the browser (since that would be interpretated as text by the browser and show up as junk text).
Most likely you have some text in your script before the call to Graph::Stroke(). If this texts gets sent back to the browser the browser will assume that all data is plain text. Look for any text, even spaces and newlines, that might have been sent back to the browser. 

For example it is a common mistake to leave a blank line before the opening " 

代码为:
ini_set('date.timezone','Asia/Shanghai'); // 'Asia/Shanghai' 为上海时区 
$day=date("Y-m-d");     //获取当前日期
$timer=date("H:00:00");//获取当前的时间
$yestday=date("Y-m-d",strtotime("-1 day"));//获取昨天时间
$conn=mysql_connect('localhost','root','root');
mysql_select_db("pm25",$conn);
mysql_query("set names utf8");
$arr=mysql_query("select pm25,time from ceshi where data='$day'",$conn);   //查询日期为今天结果赋值给数组arr
$arr1=mysql_query("select pm25,time from ceshi where data=$yestday",$conn);   //查询日期为昨天结果赋值给数组arr1
$time=array(
"0"=>"00:00:00",
"1"=>"01:00:00",
"2"=>"02:00:00",
"3"=>"03:00:00",
"4"=>"04:00:00",
"5"=>"05:00:00",
"6"=>"06:00:00",
"7"=>"07:00:00",
"8"=>"08:00:00",
"9"=>"09:00:00",
"10"=>"10:00:00",
"11"=>"11:00:00",
"12"=>"12:00:00",
"13"=>"13:00:00",
"14"=>"14:00:00",
"15"=>"15:00:00",
"16"=>"16:00:00",
"17"=>"17:00:00",
"18"=>"18:00:00",
"19"=>"19:00:00",
"20"=>"20:00:00",
"21"=>"21:00:00",
"22"=>"22:00:00",
"23"=>"23:00:00"
);
$pm25=array("0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0");
$pm25today=array("0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0");
$pm25yestday=array("0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0");
while($result=mysql_fetch_assoc($arr)){
//echo "yes2";
for($j=0;$j //echo "yes1";
if ($result['time']==$time[$j]){
$pm25today[$j]=$result['pm25']; //存放今天的Pm2.5
//echo "yes";
}
}
}
while($result=mysql_fetch_assoc($arr1)){
//echo "yes2";
for($j=0;$j //echo "yes1";
if ($result['time']==$time[$j]){
$pm25yestday[$j]=$result['pm25']; //存放昨天的Pm2.5
//echo "yes";
}
}
}
for($i=0;$i if ($pm25[$i]==0){
  $pm25today[$i]= $pm25today[$i-1]; //获取今天PM25数据
}
}
$a1=array("0点","1点","2点","3点","4点","5点","6点","7点","8点","9点","10点","11点","12点","13点","14点","15点","16点","17点","18点","19点","20点","21点","22点","23点"); //设置X轴
$a=array("0点","1点","2点","3点","4点","5点","6点","7点","8点","9点","10点","11点","12点","13点","14点","15点","16点","17点","18点","19点","20点","21点","22点","23点"); //设置X轴
if($timer=="23:00:00"){
$pm25[$i]=$pm25today[$i];
if($pm25[0]==0){
$arr=NULL;
$daytimer=0;
while($arr==NULL){
$daytimer++;
$day=date("Y-m-d",strtotime("-$daytimer day"));
$arr=mysql_query("select pm25 from ceshi where data=$day",$conn);
}
$a3=mysql_num_rows($arr);
$result=mysql_fetch_assoc($arr[$a3]); //去最后一条记录
$pm25[0]=$result['pm25'];
}
}
else{ //初始化
$m=0;
$yestimer=date("H:00:00",strtotime("+1 hour"));//24小时之前的时间
for($j=0;$j if($timer==$time[$j]){
$m=$j;//标记现在时间位置
}
}
for($i=0;$i if ($pm25[$i]==0){
  $pm25yestday[$i]= $pm25yesday[$i-1]; //获取昨天PM25数据
}
}
$m1=23-$m;
$m2=23-$m;
for($j=0;$j $pm25[$j]=$pm25yestday[24-$m1];
$m1=$m1+1;
}
for($i=0;$i $pm25[$m2]=$pm25today[$i];
$m2++;
}

if($pm25[0]==0){
$arr=NULL;
$daytime=3;
while($arr==NULL){
$day3=date("Y-m-d",strtotime("-$daytime day"));
$arr=mysql_query("select pm25 from ceshi where data=$day3",$conn);
$daytime++;
}
$a4=mysql_num_rows($arr);
$result=mysql_fetch_assoc($arr[$a4]); //去最后一条记录
$pm25[0]=$result['pm25'];
}

for($j=23-$m;$j $m1=$j-$m;
$a[$j]=$a1[$m1];
}
for($j=0;$j $a[$j]=$a1[$n];
$n=$n+1;
}
}
 //用PHP画折线图
  include("E:/phpser/AppServ/jpgraph/jpgraph/jpgraph.php");
  include("E:/phpser/AppServ/jpgraph/jpgraph/jpgraph_line.php");
//$datay = array(109,120,120,97,112,135,135,106,106,106,204,124,124,124,119,109,118,118,197,155,142,142,136,137); //填充的数据
$datay=$pm25;
  $graph = new Graph(700,300,"auto");    //生成画布
  $graph->img->SetMargin(50,40,30,40);  //设置画布的边距
  $graph->img->SetAntiAliasing();     //设置拆线的平滑状态
  $graph->SetScale("textlin");     //设置刻度样式
  $graph->SetShadow();//创建画布阴影
  $graph->title->Set("最近24小时pm2.5值的变化");//设置标题
  $graph->title->SetFont(FF_SIMSUN,FS_BOLD);//设置标题字体
  $graph->SetMarginColor("lightblue");//设置画布的背景颜色为淡蓝色
  $graph->yaxis->title->SetFont(FF_SIMSUN,FS_BOLD);//设置Y轴标题的字体
  $graph->xaxis->SetPos("min");
  $graph->yaxis->HideZeroLabel();
  $graph->ygrid->SetFill(true,[email protected]',[email protected]');
  //$a=array("0点","1点","2点","3点","4点","5点","6点","7点","8点","9点","10点","11点","12点","13点","14点","15点","16点","17点","18点","19点","20点","21点","22点","23点"); //设置X轴
  $graph->xaxis->SetTickLabels($a);
  $graph->xaxis->SetFont(FF_SIMSUN);   //设置X坐标轴的字体
  $graph->yscale->SetGrace(20);
  $p1 = new LinePlot($datay);    //创建折线图对象
  $p1->mark->SetType(MARK_FILLEDCIRCLE);    //设置数据坐标点为图形标记
  $p1->mark->SetFillColor("red");     //设置填充的颜色
  $p1->mark->SetWidth(4); //设置圆柱形标记的直径为4像素
  $p1->mark->SetColor("blue");    //设置拆线颜色为蓝色
  $p1->SetCenter();   //在X轴的各坐标点中心位置绘制拆线
  $graph->Add($p1);    //在统计图上绘制折线
  $graph->Stroke();   //输出图像
?>
------解决思路----------------------
115行是哪行?

陳述
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
優化PHP代碼:減少內存使用和執行時間優化PHP代碼:減少內存使用和執行時間May 10, 2025 am 12:04 AM

TooptimizePHPcodeforreducedmemoryusageandexecutiontime,followthesesteps:1)Usereferencesinsteadofcopyinglargedatastructurestoreducememoryconsumption.2)LeveragePHP'sbuilt-infunctionslikearray_mapforfasterexecution.3)Implementcachingmechanisms,suchasAPC

PHP電子郵件:分步發送指南PHP電子郵件:分步發送指南May 09, 2025 am 12:14 AM

phpisusedforsendendemailsduetoitsignegrationwithservermailservicesand andexternalsmtpproviders,自動化intifications andMarketingCampaigns.1)設置設置yourphpenvenvironnvironnvironmentwithaweberswithawebserverserververandphp,確保themailfunctionisenabled.2)useabasicscruct

如何通過PHP發送電子郵件:示例和代碼如何通過PHP發送電子郵件:示例和代碼May 09, 2025 am 12:13 AM

發送電子郵件的最佳方法是使用PHPMailer庫。 1)使用mail()函數簡單但不可靠,可能導致郵件進入垃圾郵件或無法送達。 2)PHPMailer提供更好的控制和可靠性,支持HTML郵件、附件和SMTP認證。 3)確保正確配置SMTP設置並使用加密(如STARTTLS或SSL/TLS)以增強安全性。 4)對於大量郵件,考慮使用郵件隊列系統來優化性能。

高級PHP電子郵件:自定義標題和功能高級PHP電子郵件:自定義標題和功能May 09, 2025 am 12:13 AM

CustomHeadersheadersandAdvancedFeaturesInphpeMailenHanceFunctionalityAndreliability.1)CustomHeadersheadersheadersaddmetadatatatatataatafortrackingandCategorization.2)htmlemailsallowformattingandttinganditive.3)attachmentscanmentscanmentscanbesmentscanbestmentscanbesentscanbesentingslibrarieslibrarieslibrariesliblarikelikephpmailer.4)smtppapapairatienticationaltication enterticationallimpr

使用PHP和SMTP發送電子郵件的指南使用PHP和SMTP發送電子郵件的指南May 09, 2025 am 12:06 AM

使用PHP和SMTP發送郵件可以通過PHPMailer庫實現。 1)安裝並配置PHPMailer,2)設置SMTP服務器細節,3)定義郵件內容,4)發送郵件並處理錯誤。使用此方法可以確保郵件的可靠性和安全性。

使用PHP發送電子郵件的最佳方法是什麼?使用PHP發送電子郵件的最佳方法是什麼?May 08, 2025 am 12:21 AM

ThebestapproachforsendingemailsinPHPisusingthePHPMailerlibraryduetoitsreliability,featurerichness,andeaseofuse.PHPMailersupportsSMTP,providesdetailederrorhandling,allowssendingHTMLandplaintextemails,supportsattachments,andenhancessecurity.Foroptimalu

PHP中依賴注入的最佳實踐PHP中依賴注入的最佳實踐May 08, 2025 am 12:21 AM

使用依賴注入(DI)的原因是它促進了代碼的松耦合、可測試性和可維護性。 1)使用構造函數注入依賴,2)避免使用服務定位器,3)利用依賴注入容器管理依賴,4)通過注入依賴提高測試性,5)避免過度注入依賴,6)考慮DI對性能的影響。

PHP性能調整技巧和技巧PHP性能調整技巧和技巧May 08, 2025 am 12:20 AM

phpperformancetuningiscialbecapeitenhancesspeedandeffice,whatevitalforwebapplications.1)cachingwithapcureduccureducesdatabaseloadprovesrovessetimes.2)優化

See all articles

熱AI工具

Undresser.AI Undress

Undresser.AI Undress

人工智慧驅動的應用程序,用於創建逼真的裸體照片

AI Clothes Remover

AI Clothes Remover

用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool

Undress AI Tool

免費脫衣圖片

Clothoff.io

Clothoff.io

AI脫衣器

Video Face Swap

Video Face Swap

使用我們完全免費的人工智慧換臉工具,輕鬆在任何影片中換臉!

熱工具

SecLists

SecLists

SecLists是最終安全測試人員的伙伴。它是一個包含各種類型清單的集合,這些清單在安全評估過程中經常使用,而且都在一個地方。 SecLists透過方便地提供安全測試人員可能需要的所有列表,幫助提高安全測試的效率和生產力。清單類型包括使用者名稱、密碼、URL、模糊測試有效載荷、敏感資料模式、Web shell等等。測試人員只需將此儲存庫拉到新的測試機上,他就可以存取所需的每種類型的清單。

PhpStorm Mac 版本

PhpStorm Mac 版本

最新(2018.2.1 )專業的PHP整合開發工具

SublimeText3 Linux新版

SublimeText3 Linux新版

SublimeText3 Linux最新版

mPDF

mPDF

mPDF是一個PHP庫,可以從UTF-8編碼的HTML產生PDF檔案。原作者Ian Back編寫mPDF以從他的網站上「即時」輸出PDF文件,並處理不同的語言。與原始腳本如HTML2FPDF相比,它的速度較慢,並且在使用Unicode字體時產生的檔案較大,但支援CSS樣式等,並進行了大量增強。支援幾乎所有語言,包括RTL(阿拉伯語和希伯來語)和CJK(中日韓)。支援嵌套的區塊級元素(如P、DIV),

SublimeText3 Mac版

SublimeText3 Mac版

神級程式碼編輯軟體(SublimeText3)