A simple answer is that PHP is a language while MYSQL is a software.
PHP
PHP is a interpreted language used mostly for server-side scripting. It uses an interpreter given by PHP.net website used along with apache or anyother server.
It is similar to languages as asp , jsp , python scripts as they nearly perform similar function of serverside scripting.
MYSQL
MYSQL on the other hand is a database server / client (depending upon which one you get)
The MYSQL uses SQL (structured Query Language ) Pronounced as Sequel, To store and retrieve data.
Most developers in web specially php use mysql on server side, but it is not limited to php it can be used along with almost all the languages to store and retrive data.
That is text where we put only character type value and that is varchar where we put all data type value
Well their is a quite big difference between them. a mark-up language um i wouldn't call it a actual programming language, to basic. It deals mostly with the visual aspects interface of a website, where php deals with the side server aspects, which process information which control the processing of information and data accross your a website etc... so i guess the main difference is... mark-up language is used to show the visual interface of a website, php is for functionality. i don't consider mark up languages as a actual true programming language
She enjoys doing 'spot the difference' puzzles.There is a difference between happy and sad.What is the difference between these two cakes?
what is the difference between ERD and UML Flowcharts.
what is the difference between commutative and symmetric properties
mysql client library
Janet Valade has written: 'PHP & MySQL' 'PHP & MySQL web development all-in-one desk reference for dummies' -- subject(s): Computer Technology, Nonfiction, OverDrive, PHP (Computer programming language), SQL (Computer program language), Web site development 'PHP et MYSQL' 'PHP and MySQL for Dummies'
One can find more information about the php mysql tutorial on Tutorials Point, Tizag, and W3 Schools. More information about the php mysql tutorial can be found at Site Ground.
Any of the millions of web developers using PHP and MySQL around the world. Either that or teach yourself!
The difference between connect() and pconnect, it is simply like a shop when u entering in shop you will open the door and take your iteam come out and close the door that is called connect() in mysql the connection to the mysql database will be automatically closed when the script terminates. when the door of the shop is already opend and never close it is called pconnect(), open a connection with mysql_pconnect(), the connection will not be closed and will "persist" for future use.
Yes.
Both return a row in a MySQL database and in most applications can be used interchangeably. The difference is that mysql_fetch_array has an extra argument called $result_type that allows the returned array to be associative (string keys) or numeric (the keys are 0..n). A mysql_fetch_array call with the numeric parameter is equivalent to mysql_fetch_row.
how do u develop software using php and mysql?
By sending messages to the MySQL server, you can communicate with the database. To submit SQL queries to the database, you use PHP functions. You don't need to know how to communicate with MySQL because PHP takes care of that. You only need to be familiar with SQL queries and PHP functions. To learn more about data science please visit- Learnbay.co
Ultimately PHP is a programming language and MySQL is a database language. Using PHP with MySQL is a nice combination with built-in support and the simplicity of it all. However, there aren't a lot of disadvantages of using PHP with a database, it just allows for better data organization and whatnot. There are definitely advantages and disadvantages to using a database other than MySQL (such as MongoDB or PostgreSQL).
You don't. PHP does not required MySQL to function. But because PHP is one of the easiest language with more built-in functions than you would ever need, and MySQL is free and easy to manage; people often use them together :)
WAMP is an abbreviation of "Windows, Apache, MySQL, and PHP", so it uses MySQL database server.