php - How to use PDO prepare more than oncee in a class -

- 

class dbconnection {      function connect(){         try{             $this->db_conn = new pdo("mysql:host=$this->db_host;dbname=$this->db_name", $this->db_user, $this->db_pass);             return $this->db_conn;         } catch(pdoexception $e) {             return $e->getmessage();         }     } }  class student{     public $link;      public function __construct(){         $db_connection = new dbconnection();         $this->link = $db_connection->connect();         return $this->link;     }      public function checklogin($username,$password){         $query = $this->link->prepare("select * studentprofiles username = :uname , logpassword = (select md5(:upassword));");         $query->execute(array(':uname' => $username, ':upassword' => $password));         $count = $query->rowcount();         if($count === 1){             $this->setsession($username);         }         return $count;         $query = null;     }      public static function display(){         $query = $this->link->prepare("select forename, surname studentprofiles username = :uname;"); //getting error here: fatal error: using $this when not in object context         $query->execute(array(':uname' => self::getsession()));         while($row = $query->fetch(pdo::fetch_assoc)) {             printf (" <span id='welcomename'> welcome: %s %s\n </span>",$row[0],$row[1]);         }         $query = null;     } }

error using $this again prepare select statement, how use again function in same class? thank you

appreciate help, stuck on problem

hi can check code , prefer asign in value conection example

 $conn = new pdo('mysql:host=localhost;dbname=mydatabase', $username, $password);  $conn->setattribute(pdo::attr_errmode, pdo::errmode_exception);

and in function make 1 how this

function connect(){         try{             $conn = new pdo('mysql:host=localhost;dbname=mydatabase', $username, $password);             $conn->setattribute(pdo::attr_errmode, pdo::errmode_exception);               return $conn;         } catch(pdoexception $e) {             return $e->getmessage();         }     }

in complete example this:

$id = 5; try {     $conn = new pdo('mysql:host=localhost;dbname=mydatabase', $username, $password);     $conn->setattribute(pdo::attr_errmode, pdo::errmode_exception);          $stmt = $conn->prepare('select * mytable id = :id');     $stmt->execute(array('id' => $id));      while($row = $stmt->fetch()) {         print_r($row);     } } catch(pdoexception $e) {     echo 'error: ' . $e->getmessage(); }

please try , luck


Comments

Post a Comment

Popular posts from this blog

ruby - Trying to change last to "x"s to 23 -

-
i have been playing around irb , have string looks this: irb(main):072:0> puts ["[\"4354 5432 5432 xxxxx\", \"6547 6547 8543 xxxxx\", \"2344 6543 6674 xxxxx\", \"2346 6236 7543 xxxxx\", \"1273 5585 5587 xxxxx\"]"] => nil irb(main):073:0> what want gsub last 2 "x" s of each 17 digit combination, 23 . what i've tried far (i've been using rubular): a.gsub(/\d[x]/,"23") <= grabs "x" s i'm close a.gsub(/\w[x{2}]/,"23") <= grabs "x" s grabs two digits each combination. is there easier way i'm not understanding? a.gsub(/\d{4} \d{4} \d{4} xxx\kxx/, '23') \d{4} = 4 digits what \k drop matched far. can use don't replace entire number, still able validate have in desired format.
Read more

jquery - Clone last and append item to closest class -

-
this bare-bones code on page: <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <div class="list-container"> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> <div class="single-list-item"> <button>remove</button> </div> </div> <p><button class="add-list-item">add</button></p> <di...
Read more

css - Can I use the :after pseudo-element on an input field? -

-
i trying use :after css pseudo-element on input field, not work. if use span , works ok. <style type="text/css"> .mystyle:after {content:url(smiley.gif);} .mystyle {color:red;} </style> this works (puts smiley after "buu!" , before "some more") <span class="mystyle">buuu!</span>a more this not work - colors somevalue in red, there no smiley. <input class="mystyle" type="text" value="somevalue"> what doing wrong? should use pseudo-selector? note: cannot add span around input , because being generated third-party control. :after , :before not supported in internet explorer 7 , under, on elements. it's not meant used on replaced elements such form elements (inputs) , image elements . in other words it's impossible pure css. however if using jquery can use $(".mystyle").after("add smiley here"); api docs on .after to ...
Read more