← Back to branch summary

~dani.behzi/pfcm/pfcm

« back to all changes in this revision

Viewing changes to first_run.php

  • Committer: Danial Behzadi
  • Date: 2011-09-14 12:40:21 UTC
  • Revision ID: dani.behzi@gmail.com-20110914124021-a7txxvsw6u81jt6p
created base files

Show diffs side-by-side

added added

removed removed

Lines of Context:
first_run.php
 
1
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
 
2
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
 
3
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
 
4
 
 
5
<head>
 
6
        <title>FSUG Movie Manager - Initialize database and table</title>
 
7
        <meta http-equiv="content-type" content="text/html;charset=utf-8" />
 
8
        <meta name="creator" content="Danial Behzadi" />
 
9
        <link rel="stylesheet" type="text/css" href="css.css" />
 
10
</head>
 
11
 
 
12
<body>
 
13
        <?php
 
14
        
 
15
                // Create Connection
 
16
                include 'connect.php';
 
17
                
 
18
                // Create DataBase
 
19
                $sqldb = "CREATE DATABASE collection";
 
20
                echo "<p>hio</p>";
 
21
                if (mysql_query($sqldb,$con))
 
22
                {
 
23
                        echo "Database my_db created";
 
24
                }
 
25
                else
 
26
                {
 
27
                        echo "Error creating database: " . mysql_error();
 
28
                }
 
29
                
 
30
                // Create table
 
31
                mysql_select_db("collection", $con);
 
32
                $sqlt = "CREATE TABLE Movies
 
33
                (
 
34
                        ID int NOT NULL AUTO_INCREMENT,
 
35
                        PRIMARY KEY(ID),
 
36
                        Name varchar(25),
 
37
                        Year varchar(4),
 
38
                        Director varchar(15),
 
39
                        Genre varchar(10),
 
40
                        Tags varchar(50)
 
41
                )";
 
42
                
 
43
                // Execute query
 
44
                mysql_query($sqlt,$con);
 
45
                
 
46
                mysql_close($con);
 
47
?> 
 
48
        
 
49
</body>
 
50
 
 
51
</html>