這是當前代碼，但它所做的只是從 1 行中選擇列。<?phpsession_start();include 'sqlconnection.php';$conn = OpenCon();$stmt = $conn->prepare('SELECT uid,coverphoto,profilepic,bio FROM profile WHERE uid = ?');$stmt->bind_param('i', $_SESSION['uid']);$stmt->execute();$stmt->bind_result($uid,$coverphoto,$profilepic,$bio);while($stmt->fetch()) { $output=array( 'uid' => $uid, 'coverphoto' => $coverphoto, 'profilepic' => $profilepic, 'bio' => $bio );}$json=json_encode($output);echo $json;$stmt->close();CloseCon($conn);?>如何為此添加 if 語句，以便如果 coverphoto 和/或 profilepic = null，手動將值分配給輸出數組的 coverphoto 和 profilepic？我將在下面顯示我的錯誤嘗試：<?phpsession_start();include 'sqlconnection.php';$conn = OpenCon();$stmt = $conn->prepare('SELECT uid,coverphoto,profilepic,bio FROM profile WHERE uid = ?');$stmt->bind_param('i', $_SESSION['uid']);if ($stmt->execute()){ if (coverphoto=null){ $coverphoto = 'coverphoto.jpg'; }else{ if (profilepic=null){ $profilepic = "profilepic.jpg"; }else{$stmt->bind_result($uid,$coverphoto,$profilepic,$bio);while($stmt->fetch()) { $output=array( 'uid' => $uid, 'coverphoto' => $coverphoto, 'profilepic' => $profilepic, 'bio' => $bio );}}}}$json=json_encode($output);echo $json;$stmt->close();CloseCon($conn);?>
1 回答
牛魔王的故事
TA貢獻1830條經驗 獲得超3個贊
我認為你只是有一些語法錯誤。
<?php
session_start();
include 'sqlconnection.php';
$conn = OpenCon();
$stmt = $conn->prepare('SELECT uid,coverphoto,profilepic,bio FROM profile WHERE uid = ?');
$stmt->bind_param('i', $_SESSION['uid']);
$result = $stmt->execute();
if ($result){
if ($result['coverphoto']){
$coverphoto = 'coverphoto.jpg';
}else{
if ($result['profilepic']){
$profilepic = "profilepic.jpg";
}else{
$stmt->bind_result($uid,$coverphoto,$profilepic,$bio);
while($stmt->fetch()) {
$output=array(
'uid' => $uid,
'coverphoto' => $coverphoto,
'profilepic' => $profilepic,
'bio' => $bio
);
}
}
}
}
$json=json_encode($output);
echo $json;
$stmt->close();
CloseCon($conn);
?>
你也可以這樣做
<?php
<?php
session_start();
include 'sqlconnection.php';
$conn = OpenCon();
$stmt = $conn->prepare('SELECT uid,coverphoto,profilepic,bio FROM profile WHERE uid = ?');
$stmt->bind_param('i', $_SESSION['uid']);
$stmt->execute();
$stmt->bind_result($uid,$coverphoto,$profilepic,$bio);
while($stmt->fetch()) {
$output=array(
'uid' => $uid,
'coverphoto' => $coverphoto ? $coverphio : 'coverphoto.jpg',
'profilepic' => $profilepic ? $profilepic : 'profilepic.jpg',
'bio' => $bio
);
}
$json=json_encode($output);
echo $json;
$stmt->close();
CloseCon($conn);
?>
- 1 回答
- 0 關注
- 94 瀏覽
添加回答
舉報
0/150
提交
取消