Create a Simple API In PHP with MySQL Database

[@mmhoq8828]

A video should look likes that a new comer can learn without Instructor. You did the perfect job for a new learner.

[@CodesEasy]

Happy to hear that.

[@sirlexie9810]

Luckily found this tutorial, I need to create a dummy API for my front end page, Great tutorial!

[@CodesEasy]

Happy that it helped you

[@yinhlamakamu2624]

Thank you so much, still relevant in 2024

[@CodesEasy]

Happy that you liked it

[@usd00]

Very informative & to the point Helped me a lot in making an API that I want to use with ReactJS

[@CodesEasy]

Happy that the video helped you

[@matafungsi89]

Great tutorial. Simple and ez to understand. Many tutorial out there are using classes. It make me confused 😵

[@CodesEasy]

Glad it was helpful!

[@jies933]

aahhh thanks you guyz completely wrecked my 2 hour , in the line no 5 there `data` should bein back thick 😤😤😤😤

[@CodesEasy]

What is the error you are facing, explain it so we could help you 🙂

[@jies933]

@@CodesEasy I resolved it , without the backtick the data was not visible 🗿

[@ATouchofClass196]

After a year its helped me, thanks a lot sir 😊

[@CodesEasy]

Happy that it helped you

[@Undurkhaan]

It's really good. Please continue this video further.

[@CodesEasy]

Happy to hear that

[@alihussainabro7694]

Very helpful vdieo, Thanks

[@CodesEasy]

Glad it was helpful!

[@moifouss]

This is really simple... waiting for C (R = done) U D parts. Thanks !

[@AliHaider_786]

Great❤

[@CodesEasy]

Happy that you liked the video

[@aakrandan]

How did you connect the .php file to the sql database? I am new to this, i need bit explanation.

[@cjcro6456]

Very informative! Thanks for creating. Would be nice to see this integrated with a token for security. And potentially integrated with power bi. Also even the ability to push info to the DB using the api :)

[@CodesEasy]

Sure, we will be doing something soon.

[@cjcro6456]

Fantastic!

[@dislikecounter6392]

@@CodesEasy Thank you never used php before but with this video I was able to get the updated mslqi and post code for people to use with this tutorial still to get an understanding of a basic database connection

[@SatinderSatsangi]

Really Easy to understand, good work

[@CodesEasy]

Happy that it helped you

[@javadbarghamadi2768]

bravo..thanks..it was WONDERFUL

[@CodesEasy]

Happy that you liked it

[@GuruPrakash745]

please make a video on information about MySql, Sqlite what is the need and difference between and what is php plugins?

[@CodesEasy]

Sure. 👍

[@carloseduardopaladinoalvin3816]

Excellent explanation, workd prettu fine, thanks a lot !!

[@CodesEasy]

Happy that it helped you

[@Pankajsingh-fo6tu]

Well explained.. thanks..hoping for more videos on php

[@CodesEasy]

Sure 👍

[@Addicted2OILau]

GREAT VIDEO Short and To The Point

[@CodesEasy]

Glad it was helpful!

[@rodrigodifederico]

1. PLEASE avoid Select *, internally the database will need to make 2 selects because of the "*". Always give the columns names for a select. If its too many columns, use an array then. 2. You can simply return the fetch_all results, you dont need a loop nor output variable. Your code will be way cleaner, and won't affect database performance.

[@CodesEasy]

Sure, will post videos on creating a complete secure and efficient way of creating api soon. This is a complete beginner level, trying to make things easy as possible.

[@anjalidogra9675]

Best video, short and up to the point.

[@CodesEasy]

Happy that it helped you

[@gabposts3144]

OMG thank you very much!!!

[@yeswanth2813]

Bro i have my own db idk how to access it in android studio can you help me

[@symsth16]

Thanks a lot broo!

[@CodesEasy]

Happy that you liked it

[@poonambanasode891]

Thank a lot for saving time!!!

[@CodesEasy]

Happy that it helped you

[@samnayakawadi]

Easy Pissy, Thanks. Subscribed

[@CodesEasy]

👍

[@felipemedina2279]

Thank you dude. It helped me a lot

[@CodesEasy]

Glad it helped

[@sadiqali3593]

Thank you so much, dear :)

[@CodesEasy]

Happy that it helped you

[@kazimdrafiqulislam7420]

Thanks It help me a lot

[@CodesEasy]

Glad it helped you.

[@Hadeszion]

this method support 10 million data of mysql? how to search for specific data in the url

[@jabrawiofficial8839]

Thanks dear sir

[@CodesEasy]

Happy that you liked it

[@pavankumar-of4ew]

i was looking for creating api, now i got with simple concept,thank you,but how to embed from libraries and create

[@CodesEasy]

There are other videos on our channel check them

[@restuaverian4183]

Thank you !

[@CodesEasy]

Happy that you liked it

[@KapitanOppa]

do you have an actual tutorial that connects to a thrid party api

[@CodesEasy]

Third party api integration is different, not like this. What api you are implementing

[@KapitanOppa]

@@CodesEasy Clio, Bigcommerce, Shopify, Mailchimp something like that

[@CodesEasy]

Each service will have its own documentation. Check their website for that. We could try to create a video on any one specified about. But each of them will be having difference. Some might me having SDK's and some will be providing api end points. So their implementation will be different

[@christbryan2521]

Thanks for your tutorial very easy to understand.

[@CodesEasy]

Happy that you liked it

[@jainamshroff4998]

Wow, Thank You !

[@jainamshroff4998]

Just One Suggestion, Please Provide Source Code In Description For Easy Access. Thank You

[@noumanashraf9336]

Please make a video and attached this php code with android studio and fetch data in app

[@CodesEasy]

All the necessary files are there in the description.

[@Zen-lz1hc]

Perfect Thanks

[@CodesEasy]

Happy to hear

[@user-qh7er8fp2o]

thank you bro

[@CodesEasy]

Happy that you liked it

[@gabrielfono844]

why dont u use the prepared statement to avoid sql injection in your database??

[@CodesEasy]

In this video we are not inserting any data so there was no need, also it's for beginners.

[@gabrielfono844]

@@CodesEasy right

[@muhammed4d]

How can I create a very secure API?

[@aigars2026]

If I want to display 6 tables, and make some queries, I have to create multiple files or?

[@CodesEasy]

You can do all in one file too it depends on your needs

[@aigars2026]

@@CodesEasy Thanks for info! Yeah I just have task for school, to make web api, from workbench (it's connected in phpmyadmin ...) and I think I should be fine with this as I need only screenshots not actual files.

[@banban7705]

Do u have a tutorial on how to get the data on two different database using API?

[@CodesEasy]

You will have to change the connected database and then to the operation on second db.

[@retsamgraphics7407]

as a beginner the question i have is why do we need to create API like this..why can we access the database directly and get values.

[@CodesEasy]

If you are referring to android apps, yes you need APIs for making everything easy and fast.

[@progtom7585]

Thanks for the really short simple video. A few questions; Should the API request all fields from all tables or just those fields that will be exposed to the public? Does the API filter the data at all, or does it always just dumb request everything and the client side just requests what it wants? How do we filter this data (i know this is done in the URL request by using the API keys, but if my API isnt filtering the data returned (checking in the postman application), whats going on?

[@CodesEasy]

Just use data that are necessary, select necessary data and display.

[@progtom7585]

@@CodesEasy thanks!

[@frontendprodesigner4299]

BRO I GOT THIS PROBLEM Warning: json_decode() expects parameter 1 to be string, array given in line echo json_decode($response, JSON_PRETTY_PRINT).. so how to solve this problem i see your code doesnt show error but when i try to practice i got the error above

[@CodesEasy]

It's not json_decode() it's json_encode()

[@frontendprodesigner4299]

@@CodesEasy thank you sir i solved it now its working

[@mtsalur]

thank you

[@CodesEasy]

Happy that you liked it

[@kenan336]

Fatal error: Cannot use temporary expression in write context in C:\xampp\htdocs\

[@CodesEasy]

Some error with your scripts.

[@tahmeenakhan6]

What to do if we want to fetch pdf data from website in android ap.please respond

[@CodesEasy]

if you dont have access to an api, you can scrap the html and take the pdf links then generate and api your self. Check if its allowed mt the website owner first.

[@jayeshpatil5726]

How to retrieve this Jeson data in android studio .???

[@jayeshpatil5726]

@@CodesEasy ok , I done data insert ,update , delete successfully . With some additional. Code in yours 👍

[@AtomTCP]

This is good but how to protect of other people, every guy who know how to use fetch in javascript can get data from db using this method. This isnt secured bro.

[@CodesEasy]

You can implement basic auth for that.

[@amajunrieldamalan2387]

when I run the file, it says "Not found". why?

[@CodesEasy]

Local host address will be wrong

[@amajunrieldamalan2387]

@@CodesEasy I tried running it on cmd and it works. But I still trying to figure out what's wrong with my localhost. Thanks for answering

[@usmankhawar888]

Good Tutorial Bro. Is there a way that instead of calling all the data. We can only get one we required. Creating an API that somehow asks to enter the name and will only return data containing that name Thanks

[@CodesEasy]

Yes, just change the SQL query like select name from tablename;

[@usmankhawar888]

@@CodesEasy Thanks For Replying. What I am trying to ask is creating an API that asks for name then searches for it. Actually I am trying to create an APP that asks for name and when you press search it will search mysql database and return all column values by that name. Is there a way to create an API that asks the user and then alter the code you made like this SELECT * FROM database WHERE name LIKE + "here it gets the value from client side" Currently I am returning all the data as you described here and then Re-Search the values in $response array. And then output the values I required but as the database contain 300,000 entries it took 1 min to give response Sorry if I am unable to express my question. Still glad you replied

[@CodesEasy]

Since you have that much data, you have to use an algorithmic approach to search, to get better speed.

[@CodesEasy]

Right now your SQL query can be like select name from table where name like 'Codes%'; Now this returns everything that starts with codes

[@usmankhawar888]

@@CodesEasy @Codes Easy YES. name like 'Code%' (that code) currently the code is SELECT * FROM database. It returns all the values in the database. I dont know how to insert value here, SELECT * FROM database (WHERE name LIKE (get value from client side))

[@justnow7263]

Please I need little bit explanation, what can i do this api or what he can do.

[@pankajs271178]

Accept this data in any frontend JS library. These API's are especially meant for asynchronus data extraction / posting

[@gabasanjeev]

Thanks a lot Sir no words to express my gratitude!!!

[@CodesEasy]

Most welcome

[@sannsantiago7425]

Would you help me with a small project, that is to link an api to another?! How much would you charge me?

[@CodesEasy]

Sure, contact whatsapp.codeseasy.com

[@aritrochakraborty8122]

sir its not showing any output, when I opened it in localhost.... can you please help me..??

[@Pankajsingh-fo6tu]

Goto localhost/yourFileName/api.php

[@mulhamalamry]

how to do a post rquest?

[@CodesEasy]

Check this. kzbin.info/www/bejne/eZuoiKeXj7xoec0

[@mulhamalamry]

@@CodesEasy i want to do it in javascript

[@CodesEasy]

kzbin.info/www/bejne/foDCmJelq9SEg7s for js

[@mulhamalamry]

@@CodesEasy thank u

[@mulhamalamry]

@@CodesEasy sub added

[@chandrashekarkankanala1600]

where is the code

[@CodesEasy]

Check the description. If the video is too small we might not provide the source code some times. Check the video description always for the source code

[@jayakumarmhk2486]

Thanks alooot

[@Yuh--]

how doing this with post method?

[@CodesEasy]

This is an api creation demo

[@fmohtadi99]

Is this API???? you've just connected mySql. Api is different :)

[@CodesEasy]

This video is mainly for connecting android to MySQL

[@khadijah-tul-qubrar2371]

Nice

[@ciscop2000]

I love you

[@CodesEasy]

❤️ Happy that it helped you.

[@igu642]

❤❤

[@spiderangelo]

Why this is called API? This is just querying a MySQL database!!!!!

[@CodesEasy]

It's a very simple and basic level, we use the output on mobile apps.

[@arpitasaxena7533]

Bro this is not a API its just a Database query

[@CodesEasy]

It's a video on how to fetch data and display it in json format. Mostly for my android tutorials, so that I could refer this

[@CodesEasy]

What where you looking for. We would like to make a video on that too if you could explain.

[@sjn_]

Ok seriously who uses mysqli in 2020? Why don't the tutorial makers ever encourage their viewers to use PDO with anonymous query parameters?

[@CodesEasy]

Sure. Will make tutorial on it too.

[@superjp335]

PDO is for object orriented programming...

[@Jeff-zc6rr]

This is not an api... lots of paid commenters.

[@CodesEasy]

It's to read from database and print in json format.

[@rydercarter7035]

Noob. This wasn't an example of a rest API. You just fetched data from the database using Mysqli functions and outputted it in the browser in a json format.

[@CodesEasy]

It doesn't matter much, it's basically for beginners and is optimised for commonly used keywords. If you would like to have a detailed video on REST, Restful and web api we will post something about it soon. 👍

[@augustinantony7085]

Wow 😍😍