Related Articles
Search and Retrieve Data from MySQL DB Using PHP
Below is the Simple PHP and MYSQL Search Program. Use below database queries: CREATE TABLE IF NOT EXISTS user (id int(10) NOT NULL AUTO_INCREMENT,Name varchar(20) NOT NULL,PRIMARY KEY (id)); INSERT INTO user (id, Name) VALUES (‘1’, ‘vicky’), (‘2’, ‘vivek’); Below is the sample program:
Open a Url onload of a Website or Pagee
You can able to load a webpage while accessing a particular Website using Javascript, see below for code. <script> function openWindow() { window.open(‘http://www.google.com‘,’a’,’height=300,width=600′); } </script> <body onload=”openWindow();”> </body>
Export to Excel Using PHP and Mysql
Below simple program will export mysql data values to excel sheet without using any PHP libraries. Export to Excel Using PHP and Mysql Note: IF you get errors or in excel all the data is in one column, then instead t tab space use, comma ‘,’.