mysql_ to pdo and making functions work

[brown2005]

class Selmgec {

 

function myfunction(){

 

}

 

}

 

I currently do $selmgec->myfunction();, which I was using with the old way of connecting mysql_ but was adivsed to change to pdo connection, so how do I change my code to make the function work, as currently it is not?

[kicken]

The only thing that might change in how you call the function is you may need to pass in a handle for the PDO connection, if it's not available via some other means (ie class variable).  You just have to update the code within it to use PDO rather than the mysql_* functions.

 

 

 

 

[brown2005]

class Selmgec {

function website_url($url){
global $db;
    $stmt = $db->query("SELECT selmgec_id FROM selmgec INNER JOIN domains ON selmgec_domain=domains_id WHERE domains_url='$url'");
while($row = $stmt->fetchAll(PDO::FETCH_ASSOC)){
return $row['selmgec_id'];
}
   }

 function website_id($id){
global $db;
    $stmt = $db->query("SELECT domains_url FROM domains INNER JOIN selmgec ON selmgec_domain=domains_id WHERE selmgec_id='$id'");
while($row = $stmt->fetchAll(PDO::FETCH_ASSOC)){
return $row['domains_url'];
}
   }

}

$network = $selmgec->website_url('http://www.richardbrown.name');

 

so why is this not working?

[kicken]

Because fetchAll returns an array of rows, yet you're trying to use it as if it returned just a single row.  You want to use just fetch instead.

[brown2005]

Because fetchAll returns an array of rows, yet you're trying to use it as if it returned just a single row. You want to use just fetch instead.

 

thank you!