FagsamPHP:
well done op.....
i know this looks like rubbish to many.

imohchard:
I know.. But you have ready made plugins in wp that does essential web app functions

BUSHHUNTER:
Using Dreamweaver for programming html now

imohchard:
So people still code websites? Wordpress and joomla don collect work frrom una hand na... CMS all the way... So I go code 25k Website?

FHA:


Any special reason why you would wanna use dreams.?

BUSHHUNTER:


preferred dreamwvr...easy 4 coding nd some other tins

GoodMuyis:


Could Try VIM, thats badt pass Dreamweaver.

By the way, e be like say Oga seun don start to dey moderate,

bigdrey:
If you want to have a very powerful and interactive website then consider the use of web database either MYSQL or ORACLE just to mention a few.

In this article we will see and explain most used mysql function which you may need and must know as a PHP Beginner and Programmer.

Using PHP you can interact with MySQL database either using Mysql extension, PDO extension and MySQLI extension, for security reasons MySQL extension is considered as depreciated and it should not be used. In this article we will focus on MySQLI where ‘I’ means Improved.
BUT WHAT IS MYSQL?

This is an open source relation database management system (RDBMS) based on structured query language (SQL)
WHY NEED MYSQLI

This structured query language (SQL) provide an easy way to add, remove, alter and join information in database using standard SQL commands INSERT, DELETE, JOIN AND UPDATE. Let’s take a look on each function in detail.

Before you can use MySQLI extension you may need to connect to database once, to connect to database you need to know few things about your database such as password, host, user and database name.

HOST: This is where the database is located; it can be either localhost meaning your web server machine is hosting it's self the database or the database can be in another server.
To connect to database which is on another server you use IP Address of the server otherwise you may use localhost (Self hosted database).

CONNECTING TO DATABASE

define(“HOST”,”localhost”); // our database host
define(“USER”,”root”); // by default if mysql user name has not been changed the default is root
define(“PASSWORD”,””); // database password
define(“DB”,”test”); // our database to connect to

$con = mysqli_connect(HOST,USER,PASSWORD,DB);
if($con) die(“unable to connect to database”);

Don’t forget to see how to create database and database table
ADDING DATA TO DATABASE

$query = “INSERT TO users (username,email,password) VALUES (‘user1’,’user0@gmail.com’,’password1’)"; // do not add comma (,) at the end
$sql_execute = mysqli_query($query,$con);
# check if MySQL executed successfully or not
If(!$sql_execute){
die("unable to insert data into database";
}else{
echo ("successfully added new record to database";
}
UPDATING DATA IN DATABASE

$query = “UPDATE users SET email = ’user1@gmail.com’ WHERE email = ’user0@gmail.com’ LIMIT 1”;
// Its always a good practice to add LIMIT when using update command, if more than one record match all will be updated

$sql_execute = mysqli_query($query,$con);

// let’s check if an update was successful
If(mysqli_affected_rows($con) > 0){
echo = “Record updated”;
}else{
die(“No record was updated”);
}
// if making alteration to a record with same info you may get an error
DELETING DATA IN DATABASE

- When performing this command you need to be careful as it can delete all records of the database and there is no undo

$query = “DELETE FROM users WHERE email = ’user1@gmail.com’ LIMIT 1”;
$ sql_execute = mysqli_query($query,$con);

// let’s check if Delete was successful
If(!$ sql_execute){
die (“Unable to delete file”);
}else{
echo(“succefully deleted a file”);
}

Hint: for security reasons you are required to close MySQL connection when a query finishes but lucky MySQL usually do this for you when connection is not closed

Don’t forget to check how to create simple but secure login script
Don’t forget to check the power of OOP’s in PHP

Source: http://blog.windrey.com/most_used_mysql_functions/

labogini13:
want to create my blog

bigdrey:

Ehya too bad. Thanks for letting me know. Seems not everyone should have programming knowledge.

GoodMuyis:


Could Try VIM, thats badt pass Dreamweaver.

By the way, e be like say Oga seun don start to dey moderate,

JD123:
Sorry to say,but mysqli is well outdated .expect its deprecation. It still has its own loopholes. I use PDO
,search that out. It's secured and beyond deprecation.

...

sunnico:

I guess dats why dis topic made fp.....

Ofatfoed:
bigdrey
I have a wamp server on my pc, i already installed but i don't know how to connect to the local host stuff. how do i go about that?

olukenzo:
I was disappointed when I came here to see php. Overlooking that, there's also a huge difference between your topic and what you eventually wrote on.

And why do I get the feeling that you webdev cats seem to think SQL is just about Web? I recently moved transaction data management on my embedded device from flat file to SQL-based. I use sqlite.so. Imagine if I were to start a topic on sqlite C functions telling you it's "SQL"?

9jawebdev:
The mysqli procedural is okay but recommended is the object oriented.

Instantiate a mysqli database connection using

$con = new mysqli(host,username,password,db)

Then execute an sql query by calling the query method

Like

$con->query($sql) ;

Etc.

Ricswagger:

BOSS abeg i wan learn mysql step by step,i am working with macromedia dreamweaver,i already know html,css, still learning js , php
abeg bro

swtdrms:
This is good, am actually excited seeing someone creating a thread for application development. @OP, it'll be better if u can be more professional in ur programming threads or articles by taking screen shots from a code editor, it presents u as a professional as well help the intended readers to make sense of it.
Also always stick to what title or topics you give ur article/thread. As your title do not correlate with the body of the write up and lastly, screen shots of the final results will also put you in the professional light.

As always, you have tried, keep it up and improve on it....

As for me, do i really have time dirtying my hands with mysql functions? Frameworks can really do lots of this elementary stuffs in a cinch, and if i'll have to, i'll rather go the OOP way

labogini13:
want to create my blog

bigdrey:

check if it's working by starting the wamp server as an administrator and then open any of your preferred browsers and type in http://localhost in the address bar or type in http://127.0.0.1 and see if it loads the wamp server index page. Update me on that.

Ofatfoed:

I tried it, both urls, but it doesn't load the wamp server index page. pls, what am i to do next?