Click here to Skip to main content
15,885,366 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
Questionhow to get hard disk Serial Number using php on server side Pin
Lakshmanan Duraisamy26-Jul-17 23:15
Lakshmanan Duraisamy26-Jul-17 23:15 
AnswerRe: how to get hard disk Serial Number using php on server side Pin
Richard MacCutchan26-Jul-17 23:35
mveRichard MacCutchan26-Jul-17 23:35 
AnswerRe: how to get hard disk Serial Number using php on server side Pin
Jochen Arndt27-Jul-17 0:09
professionalJochen Arndt27-Jul-17 0:09 
SuggestionRe: how to get hard disk Serial Number using php on server side Pin
Richard Deeming27-Jul-17 1:31
mveRichard Deeming27-Jul-17 1:31 
QuestionPHP connecting to vb.Net Pin
Member 1296881918-Jul-17 19:48
Member 1296881918-Jul-17 19:48 
AnswerRe: PHP connecting to vb.Net Pin
Richard MacCutchan18-Jul-17 20:49
mveRichard MacCutchan18-Jul-17 20:49 
QuestionTrying to create a secure login script, just have a few questions. Pin
BlackMagix14-May-17 4:40
BlackMagix14-May-17 4:40 
AnswerRe: Trying to create a secure login script, just have a few questions. Pin
Superolmo10-Jul-17 9:09
Superolmo10-Jul-17 9:09 
QuestionSorting array and adding position numbers while/after sorting Pin
Member 131868238-May-17 4:15
Member 131868238-May-17 4:15 
QuestionHelp Pin
Member 1302311826-Apr-17 3:40
Member 1302311826-Apr-17 3:40 
AnswerRe: Help Pin
Jochen Arndt26-Apr-17 3:58
professionalJochen Arndt26-Apr-17 3:58 
GeneralRe: Help Pin
Member 1302311826-Apr-17 4:14
Member 1302311826-Apr-17 4:14 
GeneralRe: Help Pin
Jochen Arndt26-Apr-17 4:43
professionalJochen Arndt26-Apr-17 4:43 
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 

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.