Question

I want solution by wampserver

4. Database Programming [8 Marks) a. Create a database in wampserver with your National ID. b. Create the table structure with your college ID Number, for the all fields with the proper filed name, data type, size and constraint. c. Modify your php program with necessary mysql database connection. d. When you click register button [in the registration form], save the record into the database and display the result in table format. c. When you click cancel button, the registration will be delete from the database. f. When you click modify button, the data will be update to the database, g. Take a screen shot of your database and table with two sample records on it in Word document/ pdf

Answer 1

a) Assuming that you had already installed wamp server and opened it. In, wamp server there is 3 services named as "php", "apache", "mysql". for time being, i am creating database in "phpmyadmin", steps are discribed below:

1) first of all, u have to complete login session containing "username" and "password" when you open phpmyadmin service in wamp server software.

2) after login, at left hand side there is "database" option, click on it, name it and press "create" . by doing this, database created, to add user to it follow below steps.

3) now, add user to database. click on "privileges". initially, privileges contains a local host id for the user but if the user want to add new user, then press on "add user account". after that, fill the details containing "USER name",  "Host name", "Password" and many more.

4) then check on the option "grant all privileged to database "database_name" ".

5) at last click on "GO".

b) first create database then to create table in that respective database in the phpmyadmin service of wamp server. follow the below steps.

1) Right click on the "database" in which we are required to create tables with necessary details. after clicking that, page is displayed in which user have to fill "name" of the table and "no of columns" of the tables and click on "go".

2) on next screen, user have to fill name of the column, type, length and many more. after filling one column details, click on "save". now to add further columns, use below information.

3) then on left side, you see the list of the databases. right click on the database where your table was created. then, you see list of available tables in that database. right click on your table name.

4) then, a screen is displayed containing "add" (enter no of columns), check on column(s) option, check on at the begining/ at the end, then fill "after info"(aftre which column you need to add column) by drop down then click "Go". then a screen is displayed where you have to fill column name, type, and more details.

5) click on save.

c) there are three types of methods in PHP to connect mySQL database i.e. MYSQL, MYSQLI and PDO. now to connect the php with the mysql database is defined below:

1) you have to follow below program:

1. <?php
2. function OpenCon()
3. { // set variables
4. $dbhost = "localhost"; // database host
5. $dbuser = "root"; // database user id
6. $dbpass = "1234"; // database user password
7. $db = "example"; // database name
8. //create connection
9. $conn = new mysqli($dbhost, $dbuser, $dbpass,$db) or die("Connect failed: %s\n". $conn -> error);
10. return $conn;
11. }
12. function CloseCon($conn)
13. {
14. $conn -> close();
15. }
16. ?>

2) to check the whether the connection correct or not, below is the demo code: after below code succes, we can modify the database in which we wish to make changes

1. <?php
2. //check connection
3. include 'db_connection.php';
4. $conn = OpenCon();
5. echo "Connected Successfully";
6. CloseCon($conn);
7. ?>

d) to add data in tabluar format after adding data in database, we can use php and sql connection. it means that using php connection fill data in sql tables. follow below code:

<? php

// set variables from above code

// create connection as mentioned above

// check connection as mentioned above

//insert data

$insertRecordQuery = "INSERT INTO table_name ("first", "last") values ("a","b")"

if(mysqli_query($connection, $insertRecordQuery)){ //behave as button

echo "saved";   

}

else{

echo "error".mysqli_error($connection);

}

?>