Backup your php.ini file before you do anything. Then open the php.ini file so that you can edit it. Check that file_uploads is set to On (needed to upload files via a PHP script). Set upload_max_filesize to 64M (or less). Set post_max_size to 64M (or less). Set memory_limit, to 64M (or less). Set max_input_time to 600 or less. Set max_execution_time to 300 or less. Save your php.ini file. (or minimal modifications): upload_max_filesize = 500M post_max_size = 500M max_execution_time = 500
PHP automates inserting data into MySQL table by using INSERT command within PHP code.
Use asterisk character in the SELECT statement like this: SELECT * FROM name_of_table
SELECT field_name, another_field_name FROM table_name
INSERT INTO table_name (column_name1, column_name2, …) VALUES (‘value1’, ‘value2’, …) Important: there should be no comma after the last element within both sets parentheses; single quotes must be used for any string values; order of columns should correspond to the order of values.
mysql> CREATE TABLE `name_of_table` ( `first_field_name` varchar (100), `second_field_name` varchar(100), `and_s0_on` );