sql layout
Moderator: General Moderators
-
ashleyallisson
- Forum Newbie
- Posts: 4
- Joined: Tue May 22, 2007 2:42 pm
sql layout
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?
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?
Last edited by ashleyallisson on Tue May 22, 2007 3:33 pm, edited 1 time in total.
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.
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.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
-
ashleyallisson
- Forum Newbie
- Posts: 4
- Joined: Tue May 22, 2007 2:42 pm
feyd | Please use
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]
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]- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
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
May I ask what this is for? This sounds almost like a homework assignment.
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).if I have to create a php module and a result must be
1) codefiles,
2) style files,
3 sql layout,
May I ask what this is for? This sounds almost like a homework assignment.
-
ashleyallisson
- Forum Newbie
- Posts: 4
- Joined: Tue May 22, 2007 2:42 pm
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
-
ashleyallisson
- Forum Newbie
- Posts: 4
- Joined: Tue May 22, 2007 2:42 pm
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?
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?