It is basics of PHP, here we are going to see about How to create database and how insert the field values in the database table. for that just follow the below instruction what i given below. as per this just follow to create database and insert in it,

Database Creation:
Here I’m using WAMP sever, so just go to the localhost as url, and choose phpmyadmin and click on the Database, and fill the name of your database, and click Create.

And the database will be created as the name what we given,

After the database created, we have to create a table. Name of the table and number of columns we want, and click Go.


The above field will be comes like, how many columns we want. fill all the fields without fail.

We have to fill the fields, and click save to finish the table creation

And the database and table creation work is over.
Sample form image

Here we are going to insert values so here we need db.php file mainly,
refer all the above for the database name, database table name, and column name and types. now just follow the coding.
DB.PHP
<?php $conn=mysql_connect("localhost","root","")or die('Database not connected'); $db=mysql_select_db("downdrop")or die('Database not connected'); ?>
And the insert coding comes on the main page
INSERT.PHP
<?php if(isset($_POST['submit'])) { $name=$_POST['namename']; $number=$_POST['numbername']; $address=$_POST['addname']; $insert=mysql_query("insert into ddtable(name,number,address)
values
('$name','$number','$address')"); } ?>
All finished, click on the submit button the result will be comes like,

And finish of Creating Database and Insert coding here.
RELATED POSTS:
Marquee style in different manner with PHP and MySql
Detect Operating System and Detect the Browser using Php
Simple Pagination with loading effect using Qjuery, PHP and MySql
RELATED POSTS:
Marquee style in different manner with PHP and MySql
Detect Operating System and Detect the Browser using Php
Simple Pagination with loading effect using Qjuery, PHP and MySql
Nice
ReplyDeleteyou are great, continue to rock
ReplyDeleteThanks a lot, Nice Tutorial
ReplyDeletewow ! very nice ,thank you
ReplyDeleteVery nice snippets, thanx a lot
ReplyDeleteI dont get it.
ReplyDeleteI dont get it.
ReplyDeleteThanking you for this valuable tutorial.Very nice snippet.Keep sharing.
ReplyDeleteThis article is right for my husband to read, he is a programmer and he needs it for his job project. Look in here write dissertation Thanks a lot!
ReplyDelete
ReplyDeleteI appreciate it!. I really like it when people get together and share ideas. Great website, continue the good work!. Either way, great web and I look forward to seeing it grow over time. Thank you so much.
super smash flash 2
Every change you make that deviates from the original will construe the intention of the message.
ReplyDeleteI would like to have new experience and be pleased with the things that are here.
ReplyDeleteThat is always good to have the site like that. I can find the infroamtion that I need/
ReplyDeleteI like the post format as you create user engagement in the complete article. It seems round up of all published posts. Thanks for gauging the informative posts.
ReplyDeletecara menggugurkan kandungan
Creating a database is a very painstaking and complex exercise that will require you to earn a lot of knowledge and time.
ReplyDeleteWow! This can be one particular of the most useful blogs We’love ever arrive across on this subject. Actually Excellent. I am also a specialist in this topic therefore I can understand your effort.
ReplyDeleteYou see there is a lot of infomation that can be used. It will be good to use it.
ReplyDeleteInstructions of this type are very useful so that you completely step by step describe all aspects of the work so that we do not make mistakes.
ReplyDeleteNice blog, the article you have shared is good.This article is very useful. My friend suggest me to use this blog
ReplyDeleteGood Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging
ReplyDeleteDot Net Training in Chennai | Dot Net Training Institute in Chennai
Software Testing Training in Chennai | Software Testing Course in Chennai
Java Training Institute in Chennai | Core Java Training in Chennai
PHP Course in chennaia | PHP Certification
You should continue writing such blogs, it was informative. Also, within your appreciation, I just want to add that you can buy World Zip Code Database from World Cities Database at very reasonable prices.
ReplyDelete