Downloaded 42 times
Php connectivitywithmysql
- 1. 11-Sep-2014 Thursday Connectivity With MySQL
- 2. Points of Discussion • Introduction • What is MySQL • Create Database • Basic MySQL Operations • Basic MySQL Functions • Benefits • Drawbacks • Conclusion 2
- 3. Introduction 3 •A database is an application that manages data and allows fast storage and retrieval of that data. A database is a collection of information that is organized so that it can easily be accessed, managed, and updated.
- 4. Example of Database • Sql Server • Oracle • FoxPro • MongoDB • Microsoft Access 4 MySQL
- 5. What is MySql MySQL
- 6. MySql 6 •MySQL is a database. • The data in MySQL is stored in database objects called tables. • A table is a collections of related data entries and it consists of columns and rows. • Databases are useful when storing information categorically.
- 7. Continue • DownloadMySQL Database • If you don't have a PHP server with a MySQL Database, you can download MySQL for free here: • http://www.mysql.com/downloads/index.html 7
- 8. Continue • MySQLworks on many operating systems and with many languages including PHP, PERL, C, C++, JAVA etc. • MySQL is very friendly to PHP, the most appreciated language for web development. 8
- 9. MySQL How toCreate Database?
- 10. How to CreateDatabase 10
- 11.
- 12. Give Table Name& No of Columns 12
- 13.
- 14.
- 15.
- 16. Basic MySQL Operation MySQL
- 17. Basic Operations •Create table • Insert records • Retrieve records • Update records • Delete records • Modify table • Join table • Drop table 17
- 18. MySQL Basic MySQL Functions
- 19. Basic MySQL Functions • mysql_connect() • mysql_select_db() • mysql_query() • mysql_featch_row() • mysql_featch_array() • mysql_affected_row() • Mysql_close() 19
- 20. Mysql_connect() • Purpose:- »This Function is used to connect your application with database. • Syntax:- 20 Bool mysql_connect(“servarname”,”userna me”,”password”);
- 21. Mysql_select_db() • Purpose:- »This Function is used to select particular database from phpmyadmin database. • Syntax:- 21 bool mysql_select_db(“Databse Name”);
- 22. Mysql_query() • Purpose:- » Sends the specified SQL query to the database specified by the resource identifier. The retrieved data are returned by the function as a MySQL result set. • Syntax:- 22 Record set mysql_query(“sqlquery”);
- 23.
- 24. Benefits • OpenSource • Easy, Fast and High Performing • Cross Platform Supports • Occupies very less disk space. 24
- 25.
- 26. Drawbacks • Developersaccuse MySQL for not having a good developing and debugging tool compared to paid databases. • MySQL cannot work efficiently with large databases. 26
- 27. Conclusion MySqlis an Open Source database Management System and Support Major features of the RDBMS. There is no need of Purchase any other thing, we have to just install and done. 27
- 28.
- 29. Reference www.mysql.com www.slideshare.com www. Wikipedia.com 29
- 30. MySQL That’s Allfor PHP With MySQL Thank You…!!!