[操作疑難] 請教OOP

carlkyo

請教OOP

請問各位CHING
WHERE clientsid 係個CLASS度要點寫個get method??
many thanks

<?php
echo "<center><table border='1'>";
$result = mysql_query("SELECT * FROM clients");
while($row = mysql_fetch_array($result)){
$result1 = mysql_query("SELECT * FROM clientsmany WHERE clientsid=".$row['id']);
if(mysql_num_rows($result1)>0 ){
while($row1 = mysql_fetch_array($result1)){
echo "<tr><td>".$row['ID']."</td><td>".$row['phone']."<br>".$row1['phone']."</td>       </tr>";
}
}else{
echo "<tr><td>".$row['ID']."</td><td>".$row['phone']."</td></tr>";
}
}
echo "</table></center>";
?>

carlkyo

public function __construct($myID)
    {
        $this->$clientID=$myID;
    }
    public function getMyDetails()
    {
        $sql="select clientName, clientPhone from clients where clientID=".$this->clientID.";";
        foreach($stmt as $clientContact)
        {

insanity

得你自己先知你嘅"getMyDetails" 想GET 啲乜嘢...
而且你第一個POST同第二個POST其實有乜關係？

題外話點解你第一個POST 唔用JOIN?

carlkyo

得你自己先知你嘅"getMyDetails" 想GET 啲乜嘢...
而且你第一個POST同第二個POST其實有乜關係？

題外話點 ...
insanity 發表於 2014-2-28 13:15

table    A    person
table    B     course
我係想出output
陳大文
1      中文          50
2      地理          60
3      代數          70
陳小文
1        中文          50
2        英文          50
好似用唔到join

many thanks

insanity

clientsmany  唔係有個foreign key? 點解會join 唔到？

DraGoNxHK

有無需要咁多query?
仲要loop佢......

carlkyo

有無需要咁多query?
仲要loop佢......
DraGoNxHK 發表於 2014-2-28 17:37

guestbook