PHP Web Development - list of MySQL Functions in PHP

Hello Everyone…!!

As we all know Mysql is one of the most powerful database available for free and its can work well in combination with multiple programming languages like PERL, C, C++, JAVA and PHP. Mst of the developers choose Mysql and PHP as a combination for web development because of its web application development capabilities.

As a web development company we know its important to improve web development skills for a web developer. So Today we are here with the list of useful mysql functions in PHP : 

1. mysql_affected_rows :  

Using this function you can get  number of affected rows in previous MYSQL operation.

2. mysql_change_user :

Using this function you can change logged in user of the active connection.

3.mysql_client_encoding :

This function returns the name of characterset.

4. mysql_close : Using this function you can close database connection.

5. mysql_connect :  

Using this function you can connect database connection.

6. mysql_create_db : 

 Using this function you can create MYSQL database.

7. mysql_data_seek :  

Help of the function you can move internal result pointer.

8. mysql_db_name :  

Using this function you can get data.

9. mysql_db_query :  

Help of the function you can send MYSQL query.

10. mysql_drop_db : 

 Using this function you can drop(delete) a MYSQL Database.

11. mysql_errno: 

 This function returns the numerical value of the error message from previous MYSQL operation.

12. mysql_error:  

This function returns the text of the error message from previous MYSQL operation.

13. mysql_escape_string:  

Using this function escapes a string for use in mysql_query.

14. mysql_fetch_array:  

Help of the function you can get a result row as an associative array, a numeric array, or both.

15. mysql_fetch_assoc:  

Using the function you can fetch result row as an associative array.

16. mysql_fetch_field:  

Using the function you can get column information from a database table and return as an object.

17. mysql_fetch_lengths : 

 You can get the length of output in a result.

18. mysql_fetch_object : 

 You can get the database table row as an object.

19. mysql_fetch_row:  

You can fetch  a result row as an enumerated array.

20. mysql_field_flags: 

 You can get flag associated with the specified field in the database table.

21. mysql_field_len:  

This function returns the length of specified field.

22.mysql_field_name:  

You can get the name of the specified field from the database table.

23. mysql_field_seek :  

You can set result pointer to a specified field offset.

24. mysql_field_table:  

You can get name of table the specified field is in.

25. mysql_field_type :  

You can get the type of the specified field in result.

26. mysql_free_result :

 Using the function Free result memory

27. mysql_get_client_info :  

Help of the function you can Get MySQL client info

28. mysql_get_host_info : 

 You can Get MySQL host info

29. mysql_get_proto_info :  

You can Get MySQL protocol info

30. mysql_get_server_info :  

You can fetch MySQL server info

31. mysql_info :  

You can receive information about the most recent query

32. mysql_insert_id :  

You can receive the ID generated from the previous INSERT operation

33. mysql_list_dbs :  

Help of the function you can create List databases available on a MySQL server

34. mysql_list_fields :  

Using this function you can create List MySQL table fields

35. mysql_list_processes :  

You can create List MySQL processes

36. mysql_list_tables :  

You can create List tables in a MySQL database

37.mysql_num_fields : 

 You can receives number of fields in result

38.mysql_num_rows :  

You can fetch number of rows in result

39.mysql_pconnect :  

Help of the function Open a persistent connection to a MySQL server

40.mysql_ping :  

Ping a server connection or reconnect if there is no connection

41.mysql_real_escape_string :  

Using this function Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection.

42.mysql_result :  

You can fetch result data

43.mysql_select_db :  

Using this function you can Select a MySQL database

44.mysql_stat :  

Help of the function Get current system status

45.mysql_tablename :  

Help of the function you can Get table name of field

46.mysql_thread_id :  

This function Return the current thread ID

47.mysql_unbuffered_query :   

This function Send an SQL query to MySQL, without fetching and buffering the result rows

If you need any Web development services ... Feel free to contact us at : Anomla Technologies.

Author’s Bio :

Anomla Technologies is one of the leading Web Development Company in United states which provides advanced IT solutions to enhance business growth of clients all around the Globe. We Have a team of passionate and dedicated individuals who loves collaborating to provide exceptional services.