Page 1 of 1

sql layout

Posted: Tue May 22, 2007 2:48 pm
by ashleyallisson
if I have to create a php module and a result must be
1) codefiles,
2) style files,
3 sql layout,

then what does the third item mean? What do I have to do I mean? Do I have to create a file or sth?

Posted: Tue May 22, 2007 3:07 pm
by toby_c500
SQL (sometimes expanded as Structured Query Language) is a computer language used to create, retrieve, update and delete data from relational database management systems. SQL has been standardized by both ANSI and ISO.

SQL is commonly spoken either as the names of the letters ess-cue-el (IPA: [ˈɛsˈkjuˈɛl]), or like the word sequel (IPA: [ˈsiːkwəl]). The official pronunciation of SQL according to ANSI is ess-cue-el. However, each of the major database products (or projects) containing the letters SQL has its own convention: MySQL is officially and commonly pronounced "My Ess Cue El"; PostgreSQL is expediently pronounced postgres (being the name of the predecessor to PostgreSQL); and Microsoft SQL Server is commonly spoken as Microsoft-sequel-server.


Not sure if that has been any help to you.

Posted: Tue May 22, 2007 3:46 pm
by RobertGonzalez
I would guess it means the database schema. Basically, when you begin a project that involves a database, you want to pay careful attention to the overall structure of that database to make sure it works well with the codebase and that it is optimized.

Posted: Tue May 22, 2007 4:22 pm
by ashleyallisson
feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


so, it means I have to create a *.sql file, where all information about the database is stored.

Like this?

[syntax="sql"]-- phpMyAdmin SQL Dump
-- version 2.9.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: May 20, 2007 at 11:26 PM
-- Server version: 5.0.33
-- PHP Version: 5.2.1
-- 
-- Database: `db_we`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `wetable`
-- 

CREATE TABLE `wetable` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(25) character set utf8 collate utf8_unicode_ci NOT NULL,
  `password` varchar(32) character set utf8 collate utf8_unicode_ci NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `wetable`
-- 

INSERT INTO `wetable` VALUES (1, 'we', 'ff1ccf57e98c817df1efcd9fe44a8aeb');


But it doesn't give anything, does it? Do I have to use that file every time some user wants to enter the database on the Internet?


feyd | Please use[/syntax]

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]

Posted: Tue May 22, 2007 4:47 pm
by RobertGonzalez
No, what you just provided is a SQL, or database, dump. That is, in essence, the structure (and maybe data) of the database that you are working with. Based on your initial post
if I have to create a php module and a result must be
1) codefiles,
2) style files,
3 sql layout,
Number 1 would be a combination of the markup document (HTML), the client side scripts (Javascripts) and server side scripts (PHP, ASP, CF, JSP, etc). Number 2 would be the stylesheet (CSS). Number 3 would be the database schema (SQL layout, table structure and field data types).

May I ask what this is for? This sounds almost like a homework assignment.

Posted: Tue May 22, 2007 4:57 pm
by ashleyallisson
It's not really a homework. I'm neither a student or programmer. More like a freelancer.
I'm trying to create a webpage 'professionally' or by the standards, OOP and all.

I have done everything but the third item, because I don't understand, what do I have to do...

Posted: Tue May 22, 2007 5:16 pm
by RobertGonzalez
So what have you got done so far?

Posted: Tue May 22, 2007 5:25 pm
by ashleyallisson
http://www.kristoaun.eu/php/katsetused/ ... stbook.php

I'm working on a commentbook at the moment.

it includes php files and a javascript function file and a CSS file.


Do I have to create some kind of pdf or excel file with the visual structure of the specific database?