Chatz
Jul 16 2006, 08:39 PM
At the end of this tutorial you should know how to: 1.How to create a database on your sever2.How to create tables on a mysql database For a script3.How to confirm your script so that it works with your database TUTORIAL PART 1How do we create a database using the cpanel on a server? Well i'll explain it the best way i can.In your cpanel go to yor mysql options.Once in you will easeily see than option to create a database and an option to create a user. Frist go to the create database option and type in the name of the database you would like for example chatzwill be my database.Once you have done that,go into the create user option and again tyape the user name and password you would like for exmaple username:test password:1111.After you have done that go to the add user to database option and add your uer to the database you created. TUTORIAL PART 2 To create tables on your database for a certain script you have to 1-screach the script for a file named sql example dump.sqlthen 2-dump the sql file in your database.To do this you have to enter your PhpMyAdmin and select your database.After that is done you will have to go into the option that say's import when you inside you will get an option to upload a file that's where you will upload your sql file.After that your tables on your database should be created. TUTORIAL PART 3To confirm your script so that it works with the database you'll have to search the script for a file named settings,db,confir,or int.Once you found the file you'll have to edit the dbuser to your databases username example test, note that some servers use this format: YourSeversName_test.Now edit the dbpassword to your databases user password example 1111,note when putting your password you must not use the format: YourSeaversName_1111.Now edit the db to your databases name example chats again you might need to use the format. So now you should have a working script using a database
Reply
lilemi
Aug 11 2007, 04:00 PM
You have quite a few typos.... You might wanna proofread, even the smallest corrections make a difference. Remember, hit the spacebar after periods and commas... If english isn't your first language I totally understand though. I'll try it out later though, dont worry!
Reply
Similar Topics
Keywords : create, tables
- How To Create A Show Desktop Shortcut
(2)
Php Nuke
Create Block (2) Hi all! Im want create server status block with these codes if
(eregi("block-Onlineplayers.php", $PHP_SELF)) { Header("Location: index.php"); die(); } //set
server, port and timeout information $server = "same adress"; $portg = "7777";
$portl = "2106"; $timeout = "1"; //try to open a connection to the game and login
server $game = @fsockopen("$server", $portg, $errno, $errstr,
$timeout); $login = @fsockopen("$server", $portl, $errno, $errstr,
$timeout); //let us kno....
Phpmyadmin
Create new database: No Privileges (6) i can not make a sql for diff srcipt, but the sricpt i have is php, DJ-cpanel.. all tho i can not
install it the error is like this Creating Database Tables No database selected there a mysql
database is made, but i can not use it for othere stuff... plz note that this is Free script and not
for paid.. is there a way that the myqsul can not use sql other scripts? or it maybe not working...
but i am not sure if the script not working or it can be the server may be down on mysql...? ....
Create Table - Mysql Code - Help
(1) I need your feedback about setting the database issues. Please, review them and correct some entries
in the code if they got some mistakes. This is the code itself: SQL CREATE TABLE
`news` ( `id` int(250) NOT NULL auto_increment, `title` varchar(255)
NOT NULL default '', `text` text NOT NULL, `author` varchar(255) NOT
NULL default '', `valid` varchar(255) NOT NULL default '',
`date` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE = ....
How To: Html Tables.
I find these really useful. (8) If you are a novice web designer, but want your site to look advanced and proffessional, then what
better way to do so than to use HTML tables? HTML tables are a really easy way of formatting your
text, to make your ste look proffesional. It looks good, and its easy, what more can you ask for?
You have to use the tag, so first lets start off with: HTML Table > /table > In
between theese two tags, we will add the data for the table, using the tags and . =Table
Heading (Title) =Table Data (what you want in the table) =table row (new row) So, lets ....
[help]create P Server
(1) Hello There, First of all I would like to explain fews I'm not a programmer and nothing. Just
wanted to find people who can help me code private server games, as like
http://www.perfectworld.com.my/ , http://ms.runup.com.my/ ( dark story online) , Warcraft III -
Frozen Throne Server(Could be exclude). As the member of my cyber cafe has asked me to create a
private server of those game, unfortunately I'd have no experiences in any of these so I need
help from other who is an expert can help me out and I need the sources and guide /smile.gif"
style="vertical-....
Create Page?
How? (11) Hi, everyone! I need to create a script just within a page. Read the following story: I have
an account at one of file sharing hosts. I am tired of every time log in and tell others what I have
at it (files). If there is way to create a script that logs in me and just list the files i have
on this account from specified folder. If you know, let me know as usual.....
Getting Started With Mysql
creating tables and insert data into them. (2) Hi in this tutorial you will learn how to create tables and insert items into them. First steps are
to create the database - go into your cpanel and mysql databases, from there make an account and a
database and then attach them together with all priviliges, call the database test and the account
admin, with the pw as pass - or any other password. We need to connect to the database so first in
your php file (probably named index.php) - this is how to do it. CODE
mysql_connect("localhost", "admin", "pass") or
die(mysql_error(&....
Php--> Content-only Pages
Create easy to edit php pages. (9) Description Learn to create easy to edit content-only pages with php. By parsing your layout into
your pages, you can reduce file sizes and files will become much neater. Try it out Ok, lets
start by creating a file called template.php. CODE <?php
//--------------------------------- //Layout top section //---------------------------------
$top = <<< html <!-- include HTML header code here --> <body>
INSERT CODE FOR [b]TOP[/b] OF LAYOUT HERE. html;
//--------------------------------- //Layout bottom sec....
Hybrid Css Layouts
What is the right way to create them? (11) I was looking for a hybrid layout where the header and footer are set to full percentage width and
the content is set to a fix width, a very popular layout in today's websites. Do you think you
could provide such an example? Not that I do not know how to create one, I just want to know about
the right way to actually layout with such specifications.....
What Is Your Dream Naruto Character
create your own naruto character (10) Basically all you have to say is your name, your jutsus (Gen, Tai, and Nin), any special abilities
and maybe a bit about his or her backstory. this is my character: Name: Nightmare also goes by
Shadow. No last name Jutsus: I think he would have Drunken fist style tai jutsu, Shadow shuriken tai
jutsu, Shadow leaf dance. my nin jutsus would be; Air slicing blast, Armor of sand, Demonic soul
stealing technique, Desert coffin and desert graveyard, Fire dragon flame blast, Grand fireball,
phoenix fire, Chidori, Rasengan, Shadow clones, Water prison, Genesis of rebirth, deser....
Photoshop -- Double Stroke
Learn to create a neat-o text effect (2) Lets do this! 1. Create a new photoshop document with the dimensions 88x31. If your lost
already... quit. 2.Alright make some random background and then put some random black-colored
(#000000) text on it. Kind of like the picture below. 3. Select the text layer you have just
created and click on the little f symbol near the bottom of the layer window. A sub menu should pop
up. Click on stroke. 4. Some editing window should appear. Change all the values to what you
see in the following image, make sure the stroke color is white (#FFFFFF). After this tu....
Create A Google Seach Result Page Embed Within Your Site Page.
(12) Create a google seach result page embed within your site page. It is easier to create
web page that embeded the google search result in it. The first step is to go to google apply an
account for the google ad-sense. After that login to you account and choose the create ad-seach
option. Most of time the google search box give all we have the great and powerfull seach ability.
But, have you think every time users get seach with it. They do redirected to another page that is
not within you site. It is easier to create web page that embeded the google sea....
Php Linking
One of the major advantages of PHP is the ability to create something (4) PHP Links Requirements 1. You should understand the majority of PHP (ex: variables, echo, etc.
www.w3schools.com is a good reference). 2. Experienced with HTML. 3. You need a PHP compatible
server if you wish to see your results. Description One of the major advantages of PHP is the
ability to create something similar to an Iframe, only without the scroll-bar. The main advantage of
this is that you only need one layout page, while the others can be simple 'white space &
content' pages. Another advantage of this is your web site doesn't look like a fi....
Create You Own Operating System
My new Website! (4) Hi all! I am The Codemaster Snake /wink.gif" style="vertical-align:middle" emoid=";)"
border="0" alt="wink.gif" /> Well I have been recently approved for hosting my site here. Before
getting started with my website I thought that I should discudd few aspects of my site with you all.
I would appreciate if you can help me out with my website. My website http://magneto.trap17.com
is going to be focussed on Operating System Development! I will also use it to showcase my
Operating System: 'Magneto'. Don't get surprised it just boots from floppy and d....
How To Create A Photoshop Vortex
(12) Hello, I will be teaching you to make a vortex in Photoshop CS3 or CS2. (Ugh... My comp froze while
I was writing this the first time and lost the whole tut, so I'll try again. First make an
image with any proportions. I prefer 1000x1000. Next pick a primary and a secondary color. You can
use anything, and if you don't know what you want, just use White for primary and Black for
secondary. Now go to Layer -> New -> Layer, and press OK. Then go to Filter -> Render -> Clouds At
this point, I have: Now go to Filter -> Blur -> Radial Blur, and select these setti....
How To Create Smallest Website
(21) I wonder if any one create smallest website on earth? any webmaster can share this things .. .if
they can make how could it be? /wink.gif" style="vertical-align:middle" emoid=";)" border="0"
alt="wink.gif" />....
How Do I Create An Online Music Store?
(5) Hi everyone, I'm looking to start a small online music store. I would like to know what would
be the best way to go about it? I don't really want to create a different html page for each
artist/cd etc. I believe it can be done using databases but don't know how to do it. Don't
even know where to start... I'm pretty good with the html required but it's the backend
I'm going to struggle with... The store/site is going to be aimed at a small niche genre of
music so it won't be a huge site. I'm just after some advice as to how best to ....
Own Server
I would like to create my own server... (9) Howdy, i'm dreaming of an own website(that's why i'm on theis forum..) and I'm
searching for the files to create an own server... I would need to be able top have: PHP Mysql smtp
perl all the other usefull things can somewone help me, i've searched on google, yahoo and
altavista and I didn't find annything! Help me please... Greetz(to all females..I'm
available...) StYn0!....
How To Create An Animated Gif?
from a video (18) I tried searching on the forum, but I could find nothing about how this is done Basically, I want
to create an animated gif which is derived from a video. Lets say I have this video file, and I want
to create an animated gif which shows what the video is about. I have already trimed the video
appropriately but when I tried doing it, I ended up with a 8.32 MB animated gif. I thought
animated gif was supposed to be lightweight, can anyone help me? Thanks in advance....
Private Server Ro .
How to create your own private Ragnarok-Online server !!! (157) I saw that there are a lot of people asking for how to create a private Ragnarok-Online server . so
now i decide to make this tutorial to to help these people ... i didn't have a server but my
friend had server and ihelped him to find pros and some tutos so , i learned with him how to create
a server ...stop making introduction ...let's go ... first you have to have minimum
requirements : ----Software :---- i think any windows should work, but i recommend Win Xp i
think you have alredy a Winrar *- Korean Ragnarok client *- Sakray patch (*i recommend the las....
How To Create Embed Image Mail In Gmail
(48) Hi to all ! Anybody can help me to create an email with embedded image so that mail reader
automatically see that image. Moreover I wont attached that image as it appears small in size in on
gmail. Thanks in Advance. ....
Fp2003 - Tables
Hope this is the right forum...? (7) Hi, I have designed a page within a table - three columns all adding up to 100% (no fixed pixel
column widths). The thing is that when I previously previewed it in other browsers it showed the
whole page - a but squashed, but everything was in the window without having to scroll horizontaly.
I made some adjustments without interfering with column widths, but now previews require horizontal
scrolling to view the page. Previously the text links in the centre column would wrap to cater for
the smaller browser size, but not now. Also, at the foot of the page there is a b....
How Do I Create Programs?
(17) how do i create programs like, a browser, or a sible program that is a calcualor ect. how do i make
toolbars and things like that? -Microsoft Lack of content and missing topic description.
Warning! ....
How To Create Java Button Or Frame
to be customized (12) hi to all!!!! just like to ask if it would be possible if i could make a custom
button or frame in java. i got tired of using the build infeatures in java. i would like to create
my own dessign of button or frame.. can it be possible!!! /biggrin.gif' border='0'
style='vertical-align:middle' alt='biggrin.gif' /> thank!!!! /laugh.gif'
border='0' style='vertical-align:middle' alt='laugh.gif' /> New Help In! is NOT a descriptive
topic title. Next time you decide not to follow the posting rules, you will be issued a w....
How Can I Create A Gui Using C++
I need easy steps! (4) can someone tell me how to create gui using c++... thanks!!!! /biggrin.gif'
border='0' style='vertical-align:middle' alt='biggrin.gif' /> Questions do not belong in the
tutorial section. Moved. Topic names and descriptions are VERY important. Changed that too. Issued
warning. ....
How To Create A Forum?
(16) I want to create a forum after getting a host on this site,but i cant find a propper program for
it.Also i want to know how to have polls and other stuff on the side. P0ZzZ! Post moved to the
right section ....
How To Create Virtual Drives
A complete guide on how to create virtual drives (19) I'm planning to format my computer tonight, and I need some sort of reference about this when I
get back. What is a virtual drive? A virtual drive is a shortcut to a folder hidden deep inside
Windows. Instead of having an icon for the shortcut (virtual drive), you will see a drive icon with
a letter that you chose when you go to My Computer after you create the drive. After completing this
tutorial, you will be able to turn a long path
(C:\directory\directory\more\directory\oh\my\gosh\this\
is\a\long\direc....
How To Create The Army System
Anyone have a tut. on creating the syst. (11) Does anyone know how to make that army system for a different IPB 2.0 forum?....
Avatars
create your own, anime-style (10) /smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /> i know it's easy to
create your own forum avatar (or snatch it from another site), but in case you think you want some
anime-style avatar which you can configure easily (in flash), here's one:
http://dookyweb.com/avatars.swf features include customizing skin color, eyes, chin, hair, mouth
and facial hair. plus you can add some accessories if you like to suit your personality.
/biggrin.gif' border='0' style='vertical-align:middle' alt='biggrin.gif' /> one small feature
missing is the ....
Looking for create, tables
|
|
Searching Video's for create, tables
|
advertisement
|
|