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/

This board no dey make frontpage again, it has been banned.

dhtml18:
This board no dey make frontpage again, it has been banned.

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

ok

Okies

want to create my blog

Cool

This made FP?



95% of nairalanders dont understand the poo u just wrote..

Click like if u understand. Click share if u don't

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

What are those. shorthand?


This kinda "writing in tongues" shouldn't make front page. Click the LIKE button as a SOLIDARITY warning to the Mods.
and Share for number of lashes this Mod deserve

MYSQL Lemme spread my mat here I dey come

The Topic is different from the article.

BUSHHUNTER:
Using mysql for programming html now

Really

lol this thread wont have more than 4 pages lol

nice one op

Nice job. Guy you can try an android app I programmed http://7rl.in/png12

Awesome bro... many won't understand this.

That is the procedural version of mysqli. . You can use the Oop like

$con = new Mysqli();

Speak English please
kikiki Lol, don't mind me am just kidding, nice one Op

mccoy47:
This made FP?



95% of nairalanders dont understand the poo u just wrote..

Click like if u dnt understand. Click share if u do

Because you don't understand it doesn't make it "poo"...
Programmers across the globe are earning a living with this knowledge,
Just so you know, this information is priceless.......for those who understand

mccoy47:
This made FP?



95% of nairalanders dont understand the poo u just wrote..

Click like if u dnt understand. Click share if u do

Am as shocked as you are! but it is good sha.

Thos thread can barely even make 1 page. This section is in coma.

The weird world of a Programmer

How many linda ikeji dey use ??

make una dey complicate things for una selves

the thread dey beg for life

too dry

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?

I remember the days I used to channel my queries like this, now Eloquent ti take over.

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?

There are websites and Web Apps.

Na once in a year this kind thread dey make FP, till 2017 before we fit see this type again...

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

Urine:


There are websites and Web Apps.