Creating our Table First we are going to create our database which stores our data. To create a database: 1. Open phpmyadmin 2. Click create table and name it as simple_login. 3. Then name the database as "simple_login". 4. After creating a database name, click the SQL and paste the below code. CREATE TABLE IF NOT EXISTS `member` ( 1. `mem_id` int(11) NOT NULL AUTO_INCREMENT, 2. `username` varchar(30) NOT NULL, 3. `password` varchar(30) NOT NULL, 4. `fname` varchar(30) NOT NULL, 5. `lname` varchar(30) NOT NULL, 6. `address` varchar(100) NOT NULL, 7. `contact` varchar(30) NOT NULL, 8. `picture` varchar(100) NOT NULL, 9. `gender` varchar(10) NOT NULL, 10. PRIMARY KEY (`mem_id`) 11. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; Creating The Form Next step is to create a form and save it as index.php. To create a form, open your HTML code editor and paste the code below after the tag. 1. 2. 3. 4. 5. 6. 17. 18. 19. 20. First Name: 21. 22. 23. 24. Last Name: 25. 26. 27. 28. Gender: 29. 30. 31. 32. Address: 33. 34. 35. 36. Contact No.: 37. 38. 39. 40. Picture: 41. 42. 43. 44. Username: 45. 46. 47. 48. Password: 49. 50. 51. 52. 53. 54. 55. 56. Creating our Connection Next step is to create a database connection and save it as "connection.php". This file is used to connect our form to database. This file serves as a bridge between our form and our database. 1. Writing Our Save Script Next step is to create our script that save our input data to database and save it as code_exec.php. 1.
Posted on: Wed, 07 Aug 2013 14:48:36 +0000
Trending Topics
Recently Viewed Topics
© 2015