相關免費學習推薦:mysql視頻教程
數(shù)據(jù)庫中有數(shù)據(jù)表hacker,現(xiàn)在我們要將hacker表中的數(shù)據(jù)查詢出來并在頁面上顯示,代碼如下:
<?php // 連接數(shù)據(jù)庫 $mysqli = mysqli_connect("localhost","root","123",'student'); //mysqli_close($con); $mysqli ? print 'yes!<br>':print?"no!<br>"; ????$sql?=?$mysqli?->?query('use?student'); ????$sql?=?$mysqli?->?query('set?name?utf8'); ????//?創(chuàng)建數(shù)據(jù)表 ????$sql?=?$mysqli?->?query("create?table?hacker( ????????id?char(6)?not?null, ????????name?char(8)?not?null, ????????chinese?float?not?null, ????????math?float?not?null, ????????english?float?not?null ????)"); ????if($sql?==?true){ ????????echo?'成功創(chuàng)建hacker表!<br>'; ????}else{ ????????echo?'創(chuàng)建hacker表失敗!'.$mysqli->error.'<br>'; ????} ????//?添加數(shù)據(jù)——hacker ????//?$sql??=?"insert?into?hacker?values('1','張三','10','20','30');";? ????//?$sql??.=?"insert?into?hacker?values('2','李四','66','77','88');";? ????//?$sql?.=?"insert?into?hacker?values('3','王二','55','44','33');";? ????//?$sql?.=?"insert?into?hacker?values('4','麻子','22','55','77')";? ????//?$rows?=?$mysqli->affected_rows; ????//?if($rows?==?3){ ????//?????echo?"添加數(shù)據(jù)成功。<br>"; ????//?}else{ ????//?????echo?'添加失敗。'.$mysqli->error."<br>"; ????//?} ????$sql?=?$mysqli?->?query("insert?into?hacker ????????values('2','李四','66','77','88') ????"); ????$rows?=?$mysqli->affected_rows; ????if($rows?==?1){ ????????echo?"添加數(shù)據(jù)成功。<br>"; ????}else{ ????????echo?'添加失敗。'.$mysqli->error."<br>"; ????} ????$sql?=?$mysqli?->?query("insert?into?hacker ????????values('3','王二','55','44','33') ????"); ????$rows?=?$mysqli->affected_rows; ????if($rows?==?1){ ????????echo?"添加數(shù)據(jù)成功。<br>"; ????}else{ ????????echo?'添加失敗。'.$mysqli->error."<br>"; ????} ????$sql?=?$mysqli?->?query("insert?into?hacker ????????values('4','麻子','22','55','77') ????"); ????$rows?=?$mysqli->affected_rows; ????if($rows?==?1){ ????????echo?"添加數(shù)據(jù)成功。<br>"; ????}else{ ????????echo?'添加失敗。'.$mysqli->error."<br>"; ????} ????//?數(shù)據(jù)查詢 ????$sql?=?$mysqli->query("select?*?from?hacker"); ????if($sql){ ????????//?echo?'有數(shù)據(jù)!<br>'; ????????$rows?=?$sql->num_rows; ????????echo?'查詢結果共有'.$rows.'條記錄<br>'; ????????echo?"
序號 | 姓名 | 語文 | 數(shù)學 | 英語 |
---|---|---|---|---|
“.$row[‘id’].” | “.$row[‘name’].” | “.$row[‘chinese’].” | “.$row[‘math’].” | “.$row[‘english’].” |
“; ????????}else{ ????????????echo?‘沒有您要找的數(shù)據(jù)。
‘; ????????} ????}else{ ????????echo?‘MySQL語句有誤。
‘.$mysqli->error.’
‘; ????}?>
? 版權聲明
文章版權歸作者所有,未經(jīng)允許請勿轉載。
THE END