MY FIRST REAL PHP SITE

When you are inspired by some great purpose, some extraordinary project, all of your thoughts break their bonds: your mind transcends limitations, your consciousness expands in every direction and you find yourself in a new, great and wonderful world. Dormant forces, faculties and talents come alive and you discover yourself to be a greater person than you ever dreamed of…… (The monk who sold his Ferari).



One of my plans this year is to build a PHP site for my ex secondary school Alumni and one for the school itself, to someone else it might seem like a walk in the park, but mine isn’t the case, I am very new to the PHP world though I am quite fluent in HTML and CSS and understand the syntax of JavaScript.

This will be a deliberate effort of mine to swim with the sharks, its obvious I will make a lot of mistakes and get frustrated a lot of times, which brings me to the aim of me starting this tread, they are a lot of good programmers over here, on whose shoulder I can lean on, I will post every single code of mine here and regularly update my progress for critique and when I need help.

Tools:
Bootstrap,
Xampp
Sublime.

Thank you all in advance.

Am watching!!!

If u ever get stuck, I'll be @ your service

Bro, I will advise u go with Dreamweaver.

sinkernet:
If u ever get stuck, I'll be @ your service

How do I rectify this?

public $sql;
	public $row; 
	public $result; 
	public $something;
	public function dbr(){
	
		$this->sql="SELECT username, id FROM users";
		foreach ($this->result->exec($sql) as $row) {
        print $row['id'] . "\t";
        print $row['username'] . "\n";
		
	}

It reply's :

Fatal error: Call to a member function exec() on a non-object in E:\xampp\htdocs\Experiments\gstosa\index1.php on line 34

dhtml18
larisoft
nauman673
hcpaul
guru01
davidthegeek
sonoflucifer
hitz
Adesege

*sips Orijin*

Thirdwrist i'm not too familiar with php. Sorry can't help. dhtml18 come o

Thirdwrist:

How do I rectify this?

public $sql;
public $row;
public $result;
public $something;
public function dbr(){
$this->sql="SELECT username, id FROM users";
foreach ($this->result->exec($sql) as $row) {
print $row['id'] . "\t";
print $row['username'] . "\n";
}

It reply's :
Fatal error: Call to a member function exec() on a non-object in E:\xampp\htdocs\Experiments\gstosa\index1.php on line 34
dhtml18
larisoft
nauman673
hcpaul
guru01
davidthegeek
sonoflucifer
hitz
Adesege

You won't get quality help here, wait until we finish our community next week

Booyakasha:



You won't get quality help here, wait until we finish our community next week

PLz mrs. what is the name of the community coz i want to join as soon as it comes online.

crotonite:

PLz mrs. what is the name of the community coz i wam't to join as soon as it comes online.

alright.. I'll mention you as soon as we launch.. thanks

Booyakasha:



You won't get quality help here, wait until we finish our community next week

How do you know?!
The guys op mentioned have not yet seen his code and you're discrediting them... That's advertising in bad faith o.
@OP... While some of your errors are already obvious you should post the class so we can help comprehensively...

Booyakasha:

You won't get quality help here, wait until we finish our community next week

if that were true, you'd have helped him now. Obviously you can't help too.

This is the whole code as requested
Thanks for help in advance, i really appreciate.

ALLU

<?php
class user{
	//inniating variables to be used in db_connect method.
	// Database assess values. 
	
		 public $db_host= "localhost";
		 public $username="";
		 public $password= "";
		 public $db_name="php_database";
		 public $dbc;
	
	// method to connect to database
	function connect(){
		try{
			
			$this->dbc= new PDO("mysql:host=$this->db_host; dbname=$this->db_name;charset=utf8", $this->username, $this->password);
		}
		catch (PDOException $e){
			echo "failed to connect to database pdo ";
			echo $e->getmessage();
			exit();
					}
		return $this->dbc;
	}
	
	
	public $sql;
	public $row; 
	public $result; 
	public $something;
	public function dbr(){
	
		$this->sql="SELECT username, id FROM users";
		foreach ($this->result->fetch($sql) as $row) {
        print $row['id'] . "\t";
        print $row['username'] . "\n";
		
	}
	
	}
}
$usermanagment= new user();
$usermanagment->connect();
echo "you are an OOP genius";
$usermanagment->dbr();
echo $usermanagment->sql;

?>

DavidTheGeek:


if that were true, you'd have helped him now. Obviously you can't help too.

I can.. but No!

Booyakasha:

I can.. but No!

I believe i can fly.. Spread my wings and fly away... (remember that song? by R. Kelly...) R. Kelly still walks on foot! He hasn't grown wings to fly still... You sound just like him!

Op the content of the file you outline is it index1.php?
The class you provided, if ran, would return "you are an oop genius"
the error you are recieving is from the index1.php class, not the class.
besides, i guess you want the file to print out you are an oop genius and also usernames and id gotten from the user table.

if that is the case, ive corrected your class to be like this, and it should work.

But i repeat, the error of exec you are getting is from index1.php, not this file.


<?php
class user{
//inniating variables to be used in db_connect method.
// Database assess values.

public $db_host= "localhost";
public $username="";
public $password= "";
public $db_name="php_database";
public $dbc;
public $sql;
public $row;
public $result;
public $something;

function __construct(){

$this->connect();
}

// method to connect to database
function connect(){
try{

$this->dbc= new PDO("mysql:host=$this->db_host; dbname=$this->db_name;charset=utf8", $this->username, $this->password);
}
catch (PDOException $e){
echo "failed to connect to database pdo ";
echo $e->getmessage();
exit();
}
return $this->dbc;
}




public function dbr(){
$this->sql="SELECT username, id FROM users";

$stmt=$this->dbc->query($this->sql);
return $stmt;
return $stmt->fetchAll(PDO::FETCH_ASSOC);




}
}
$usermanagment= new user();



echo "you are an OOP genius";
echo "<br>";
try {
$answer=$usermanagment->dbr();

foreach ($answer as $row) {
print $row['id'] . "\t";
print $row['username'] . "\n";

}
} catch(PDOException $ex) {
echo $ex->getmessage();
//handle me.
}
echo "<br>";
echo $usermanagment->sql;


?>

Nairaland is not designed for codes. You can use School Network. Look at an example here https://schoolnetwork.io/529/c-programming-tutorial

Djade007:
Nairaland is not designed for codes. You can use School Network. Look at an example here https://schoolnetwork.io/529/c-programming-tutorial

You're right but the site you just shared looks weird..

Booyakasha:

You're right but the site you just shared looks weird..

weird as how?

Djade007:
weird as how?

design.. it's not really something cool.. nairaland looks better..

Ok, probably the desktop view. It looks cool on mobile

Djade007:
Ok, probably the desktop view. It looks cool on mobile

no.. mobile is boring...

Booyakasha:
no.. mobile is boring...

I have worked with alot of ui frameworks.
That website was made to be as light as possible, no frameworks were used. However I have started creating a new version with Angular2

Djade007:
I have worked with alot of ui frameworks.
That website was made to be as light as possible, no frameworks were used. However I have started creating a new version with Angular2

Okay cool.. I'll love to see it, btw we're almost done creating our community.. i hope you become a contributor there..

heroku.com + github , that way you caan easily collaborate and ask questions with proper examples

DavidTheGeek:
Thirdwrist i'm not too familiar with php. Sorry can't help. dhtml18 come o

Who is this one again...

Booyakasha:



You won't get quality help here, wait until we finish our community next week

After all the stylish advertisement of "your community - Gdevit", it better be top notch when you launch.

DanielTheGeek:


After all the stylish advertisement of "your community - Gdevit", it better be top notch when you launch.

We won't disappoint..

Thirdwrist:


How do I rectify this?

public $sql;
	public $row; 
	public $result; 
	public $something;
	public function dbr(){
	
		$this->sql="SELECT username, id FROM users";
		foreach ($this->result->exec($sql) as $row) {
        print $row['id'] . "\t";
        print $row['username'] . "\n";
		
	}

It reply's :

Fatal error: Call to a member function exec() on a non-object in E:\xampp\htdocs\Experiments\gstosa\index1.php on line 34

dhtml18
larisoft
nauman673
hcpaul
guru01
davidthegeek
sonoflucifer
hitz
Adesege

I'm just seeing this.

If a solution hasn't been proffered, I will go thru the code and give my observations.

Regards

Thirdwrist, can you upload your code on http://www.pastebucket.com? Nairaland is cutting off your code, so you can get help. I can't even see some of your code.

I am trying to login to my site with facebook, but it isnt communicating with the database. After login it does not store the user details in the table i created.

CREATE TABLE users(
    uid int auto_increment not null primary key,
    Fuid not null int,
    Ffname varchar(100) not null,
    flname varchar(100) not null,
    Femail varchar(100) not null
    
    ) DEFAULT CHARACTER SET utf8 ENGINE=InnoDB

I got the codes from here
http://www.krizna.com/demo/login-with-facebook-using-php/dhtml18
larisoft
nauman673
hcpaul
guru01
davidthegeek
sonoflucifer
hitz
Adesege