Click here to Skip to main content
16,016,527 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
GeneralRe: Help Pin
Member 1302311826-Apr-17 4:55
Member 1302311826-Apr-17 4:55 
GeneralRe: Help Pin
Jochen Arndt26-Apr-17 5:01
professionalJochen Arndt26-Apr-17 5:01 
QuestionHow To Add More Than One Entry On A Single Cell/Array ? Pin
Member 129567898-Apr-17 14:17
Member 129567898-Apr-17 14:17 
AnswerRe: What is the difference between web development and Web designing? Pin
ZurdoDev21-Mar-17 1:48
professionalZurdoDev21-Mar-17 1:48 
QuestionWhere do I put my jquery and AngularJS libraries in wordpress? Pin
samflex17-Feb-17 8:14
samflex17-Feb-17 8:14 
QuestionTrying to connect categories and users through pivot table i Laravel Pin
Duško Oljača3-Feb-17 1:21
Duško Oljača3-Feb-17 1:21 
AnswerRe: Trying to connect categories and users through pivot table i Laravel Pin
Afzaal Ahmad Zeeshan3-Feb-17 2:10
professionalAfzaal Ahmad Zeeshan3-Feb-17 2:10 
QuestionOutputting ROW QUERY result to main program Pin
ELMAGLAYA16-Jan-17 21:19
ELMAGLAYA16-Jan-17 21:19 
Hi,

I'm a newbie in OOP. Can you please help me how to fix this code below because it gives me an infinite output. I want to output or echo my fetched data to my main program. Thanks.

===========================================

class DB {

private $_hostdb = 'localhost';
private $_namedb = 'imsdb';
private $_userdb = 'root';
private $_passdb = '';
private $_conn;
private static $_instance;
private $_rowResult;

private function __construct(){
try{
$this->_conn=new PDO("mysql:host=$this->_hostdb;dbname=$this->_namedb",$this->_userdb,$this->_passdb);
$this->_conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
if($this->_conn){
echo "Connected Successfully!
";
}

} catch (Exception $ex) {
echo ("Connection Failed!")."
".$ex->getMessage();
}
}

public static function getInstance(){
if(!isset(self::$_instance))
{
return self::$_instance=new DB();
}
}

public function processQuery($sql){
try{

$q=$this->_conn->prepare($sql);
$q->execute();
$q->setFetchMode(PDO::FETCH_ASSOC);
return $this->_rowResult=$q->fetch(); //Is this correct??

} catch (Exception $ex) {
echo ("Failed!")."
".$ex->getMessage();
}
}
}

//MAIN PROGRAM -> OUTPUT gives me an infinite data which is wrong

$dbUser=DB::getInstance()->processQuery("SELECT * FROM users");

while($dbUser){
echo $dbUser['username'];
}
AnswerRe: Outputting ROW QUERY result to main program Pin
Richard MacCutchan16-Jan-17 21:53
mveRichard MacCutchan16-Jan-17 21:53 
QuestionHow to fix this error $_SESSION:Notice: Undefined offset: 0 Pin
ELMAGLAYA4-Jan-17 18:45
ELMAGLAYA4-Jan-17 18:45 
AnswerRe: How to fix this error $_SESSION:Notice: Undefined offset: 0 Pin
Jochen Arndt4-Jan-17 22:16
professionalJochen Arndt4-Jan-17 22:16 
GeneralRe: How to fix this error $_SESSION:Notice: Undefined offset: 0 Pin
ELMAGLAYA16-Jan-17 21:33
ELMAGLAYA16-Jan-17 21:33 
AnswerCentOS httpd can not access Symbolink Pin
njzt28-Dec-16 1:26
njzt28-Dec-16 1:26 
QuestionOpen Suse Linux Pin
ForNow27-Dec-16 13:42
ForNow27-Dec-16 13:42 
AnswerRe: Open Suse Linux Pin
Richard MacCutchan27-Dec-16 21:00
mveRichard MacCutchan27-Dec-16 21:00 
GeneralRe: Open Suse Linux Pin
ForNow28-Dec-16 2:11
ForNow28-Dec-16 2:11 
GeneralRe: Open Suse Linux Pin
Richard MacCutchan28-Dec-16 5:45
mveRichard MacCutchan28-Dec-16 5:45 
AnswerRe: Open Suse Linux Pin
Albert Holguin9-Jan-17 7:52
professionalAlbert Holguin9-Jan-17 7:52 
QuestionWhich is the Best Laravel Admin Template with all the advanced functionalities? Pin
Rakeshroshans23-Dec-16 20:00
Rakeshroshans23-Dec-16 20:00 
AnswerRe: Which is the Best Laravel Admin Template with all the advanced functionalities? Pin
Richard MacCutchan23-Dec-16 21:55
mveRichard MacCutchan23-Dec-16 21:55 
Questionfail to run php script as shell Pin
njzt6-Dec-16 15:36
njzt6-Dec-16 15:36 
SuggestionRe: fail to run php script as shell Pin
Richard MacCutchan6-Dec-16 22:03
mveRichard MacCutchan6-Dec-16 22:03 
QuestionDatabase connection refused. Pin
taiwokaffo6-Dec-16 4:16
taiwokaffo6-Dec-16 4:16 
QuestionRe: Database connection refused. Pin
Richard MacCutchan6-Dec-16 4:27
mveRichard MacCutchan6-Dec-16 4:27 
AnswerRe: Database connection refused. Pin
taiwokaffo6-Dec-16 4:45
taiwokaffo6-Dec-16 4:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.