Setting Up Your MySQL & phpMyAdmin For The First Time
This tutorial will show you how to set up your MySQL and your phpMyAdmin with ease, regardless of whether you are going to be using PHP Nuke or PHP Nuke Platinum. The process is still the same.
-Log into your CPanel with your User Name and Password.
-Click on MySQL icon
-Now, we need to create a database also known as Db , Your User Name will make up part of the necessary details, but you don't need to do this as it will be done automatically. The User Name Is the same as the one used to log into your CPanel.
-In the box indicated, add a name for your Db.
-now click add db
-Okay, now that’s done, we need to create a specific Db Username & Password
thats right below fill in info and click create
-Now make sure that in Privileges, that the "All" box has been ticked,Once that is done, you can now click on the "Add User to Db" button,
-Okay, now we have phpMyAdmin open
-Now click on the named Db
-Now click on the "SQL" tab
-Depending on whether you are using Nuke or Nuke Platinum, this file be called nuke.sql or platinum.sql. This file should be located in the sql folder of the extracted application you previously downloaded. Click the "Browse" button and find the said file
-Now click the "Go" button to upload the file
-If all goes well, all the tables that are contained in the sql file will now be uploaded
-then edit config.php with details from ur db that u created !!!
Than just upload the nuke via ftp to your server and boom your done!
This tutorial is about how to setup a website after you have setup a forum. That means, you have a
forum, and are wanting to add a website. This tutorial will show you how to create the website in
your root directory(Example: http://domainname.com) , while your traffic gets redirected to your
forum while you are creating it, until you're ready for guests to see it. This method is
opposed to setting it up in another directory, then moving it(particularly more time consuming if
you're site is PHP based). First of all, you are going to want to setup a redirect ....
Requirements: PHP Support MySQL Database access I am going to use a news program as an example.
Ok, first you are going to need to connect to the database. Do so by using the code below. I have
added some comments where you will need to edit to fit your server's specifications. Create a
new file with notepad and call it config.php QUOTE //Change root to your database
account's username $dbusername = "root"; //Add your account's password in between the
quotations $password = " "; //Add the name of the database you are using in between the qu....
Hey! Maybe you've seen my other tutorials...or my signature.. Anyways I'm going to show you
how to make a system so users of your site could register accounts and you could have protected -
user only - pages on your site /smile.gif" style="vertical-align:middle" emoid=":)" border="0"
alt="smile.gif" /> Ok, so we start by creating a config.php file. CODE $dbhost =
'database host'; $dbname = 'database name'; $dbusername = 'database
username'; $dbuserpass = 'database password'; mysql_connec....
Ok, so I'm going to show you how to create a very basic shoutbox which is driven with PHP and a
MySQL database. So, lets start - open a database management program like PHPMyAdmin and run these
queries. SQL CREATE TABLE `shoutbox` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `name`
VARCHAR( 255 ) NOT NULL , `mail` VARCHAR( 255 ) NOT NULL , `time` VARCHAR( 255 ) NOT NULL ,
`message` TEXT NOT NULL , `ip` VARCHAR( 255 ) NOT NULL , PRIMARY KEY ( `id` ) ) TYPE = MYISAM ;
CREATE TABLE `shoutbox_admin` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `name` VARCHAR( 255....
This tutorial is an extension to my 7 tutorial series about the Cpanel. The 7 different Cpanel
tutorials can be found below. Part 1: E-mail Management Part 2: Useful Site Management Tools
Part 3: Useful Site Management Tools2.1 Part 4: Analysis/Log Files Part 5: Advanced Tools Part
6: PreInstalled Scripts, Extras, and Cpanel Options Part 7: Fantastico Detailed Cpanel
Tutorial Part 2.1: MySQL Management In this tutorial, i will explain how to add, edit, delete
and over-all manage the MySQL Feature in the Cpanel. Creating a MySQL Database 1) ....
Hi guys, this is a litte tutorial about how we start and stop the Apache and MySQL in Windows NT
(2000, XP, 2003) via a batch file script. As we know in Windows NT based system Apache and MySQL
installed as Windows Services. So we can stop and start it using NET command. For more information
about DOS command, type HELP at command prompt. I assuming that your MySQL service name is "mysql"
and your Apache (Apache 2.0.x) service name is "apache2". If you want to chek it click Start > Run >
services.msc > OK. Windows IS NOT Case Sensitive. Let's get started!. 1. Open....
Check Referrer Using Php To Prevent People Linking To Your Downloads From Other Sites Ever
find that found some people are listing items, images and tuts and linking directly to the download
url (those that are like my photoshop tutorial.php?id=0), which is a .php to count the number of
downloads. To prevent this, you can add a piece of code to the download pages that checks which page
referred them to the download page: if it's my domain, it downloads the file normally, if
it's not, it will redirect to my home page instead. Important : Not all browser....
Ok let`s start! Once I wrote it for school: At first we need questions (php) CODE $form_block =
" Quiz What's The Capital City Of England? How Many Letters Are There In The
Alphabet? WHat's 3+10? "; That takes the form of a form... You can, of
course edit the questions. I will now break that code down and explain the different parts. CODE
The reason that any "s (Double quotes) are shown after a \ (Backwards slash) is becouse the
PHP Parser will spew out errors if you forget to do this. "POST" Means that it will ....
QUOTE phpMyAdmin lets you control you MySQL database from a web browser. Steps: 1. If you
haven't done so already, download the phpMyAdmin Database Manager - You can download the
software from the phpMyAdmin website. Be sure to download the phpMyAdmin-2.6.2-pl1.zip file. Save
the file on your Windows Desktop. ... ... ... Go to for more info. Post Copied. Member
Banned ....
Searching with PHP and MySQL is pretty easy when you think about it, especially if you're doing
it the simple way (without boolean or whatever) /tongue.gif' border='0'
style='vertical-align:middle' alt='tongue.gif' /> It consists of a few forms, a query and an
output. As I said, simple! CODE \"> The form that you just made
contains a text input that people will type into, the next code will extract the form data and then
search it.. Form processing /wink.gif' border='0' style='vertical-align:middle' alt='wink.gif' /> ....
hi, all php 5 is new to all people a long time( actually, I forget how long...). it introduced a
more object-oriented design to developer. like, access type(public, private, protected), abstract
type(classes that can't create objects), interface support, and more . althrought it is
widerly available, someone still can't get it running with mysql. every time the php is starting
up. a message prompted stated that some xtensions can not be found, and therefore, not loaded. so, I
have written this to help other and newbie get it start quickly. note: thi....
I made this and its not very hard at all just fill in the info and it willl see if your mysql is up
or down CODE Mysql Connection Test // On this you need to put your host most of
the times localhost username and password. $conncect = mysql_connect ( "host", "Username",
"password" ) or die (" Sorry your server can't connect to your mysql server Check to see you
have put in the Username and password and if this is the 1st time you have got this And it has
worked before That means you need to contact your hoster and tell them my MySql server is....
PHP Dynamic Signatures using the GD Module After much scowering on the internet to find a
suitable tutorial on this subject, I came up empty-handed. So I was forced to learn it on my own
through trial & error. And since I had discovered a lack of tutorials on this subject, I dediced to
write one! Working Example: Abstract : Using the GD Module of PHP allows a developer
to build custom Images with Dynamic Content. Such content could be the Requesting Users IP Address,
Web-Browser Type, Operating System, even the number of times the user has seen th....
If you're an Administrator on a Forum, you probably know the importance of regular data backups.
My Forum is always being hacked by someone and they always delete our SQL Databases. Well this
tutorial is for all of you who want to protect your data and restore it if necessary! Okay, backing
up your data is the first part. I use Cron Jobs in my cPanel to automate the backup process. Just
use this code for backing up all your SQL Databases: CODE mysqldump -u root -psecret
--all-databases > backup.sql OR if you wish to backup only a single database: CODE ....
How to install php scripts using MySQL,phpMyAdmin on Trap17 using preinstalled script/auto
installation cPanel > Preinstalled scripts > "Addon Scripts" or "Fantastico" or "phpBB" or the
scripts which you wanted to install screenshot - >
http://i6.photobucket.com/albums/y222/haalaaluu/5.jpg explaination: this method is auto install
the scripts in public_html folder, database name and granted database user respect to its database.
note: by Addon Scripts, you can not choose other folder structure. by fantastico you can choose the
folder structure and it is good ....
How To Setup Your Own Dns (Domain Name Server) This is only a quick tutorial, there are literally
hundreds of little tricks you can do with a DNS, but this will get your basics up and running.
I'm assuming you want to setup a windows DNS server, but the principals will work for most
servers. You will need.. 1) A domain name over which you have full control 2) DNS server
software(Windows server always comes with one of these) 3) At least one fixed IP address, allthough
two is highly desirable 4) An idea of what services you want on your server The first thing you ....
Ok, so you want to have a php nuke site. First of all, what is this "PHP nuke", and why is it so
special? Php nuke is a web portal system. It is expandible, and can be very usefull. You can find
an example here. Yes, it is that good. So, lets take a closer look. It's pre-packaged basic
features are: *forums *a login system *weblinks *downloads *news *polls *faqs *content You can
allways de-actuvate some features, but it's near-imposible to remove them. Kinda annoying, but
you know. Some people may not need phpnuke, or cant have i period. You need: *some ....
Start register code. Register.php CODE Username: Email: Pass: Verify
Pass: //Login to your database. Make the fields of course..
mysql_connect("localhost","user","pass"); mysql_select_db("database"); //end //if registering,
check fields. if ($action == register) { if (!$user || !$pass || !$email || !$vpass) { print
"You must fill out all fields."; exit; } $dupe1 = mysql_num_rows(mysql_query("select * from
table where user='$user'")); if ($dupe1 > 0) { print "Someone already has that
username."; exit....
kLogin 0.1 QUOTE(readme.txt) Readme file to kLogin 0.1 To use the internet explorer fix:
download the latest IE7 ZIP file
(http://sourceforge.net/project/showfiles.php?group_id=109983&package_id=119707) Extract the ie7
zip file to the root directory of your web server. Example, if you are using a unix/linux server,
it's on "public_html/" or "home/public_html" Open kLogin.php file with your editor and edit the
$info_text or $info_txt variable. Then, extract the kLogin.php file in to the root directory of
your web server also. Just run kShoutBox.php If ....
QUOTE Run you're own server for testing phpmysql or just to host you're own website or
for you're friends. -needS: a PC that's all 8) - How to ? download : CODE
http://server.paehl.de/apache20.zip : 30 seconds Installing:---> 1 minute
*********************************** Unpack the exe where ever you want. after unpack run
serverinst.exe and change Servername and your e-mail. Start the following files one time:
start_apache.cmd --> start apache as service mysql_start_as_service.cmd --> dito for mysql
mysql_first_start.cmd --> start m....
Just create a PHP file named "kShoutBox.php" CODE /* ******************************
kShoutBox 0.1 ****************************** */ /* ****************************************
This ShoutBox script was created by Juan Karlo Aquino de Guzman DO NOT MODIFY THIS CODE AND
DISTRIBUTING IT WITHOUT ANY PERMISSION. E-MAIL THE AUTHOR FIRST. Email: 01karlo@gmail.com DO NOT
REMOVE THE "POWERED BY". FOR SUGGESTIONS, COMMENTS, ETC, SEND AN EMAIL TO 01karlo@gmail.com
HOPE THAT YOU ENJOY THIS SCRIPT! MY FRIENDSTER: karlo@*BLEEP*it.com ***************....
Well, in this tut, I'll show you how to do an simple link counter, with only one count for each
IP and the date when the link were clicked. Just remember, this is only one way to do it. First,
create an mysql database called 'links', with 2 table: first table will be called
'links', with the columns: id, title, ref and clicks. The other one will be 3 columns and
will be called links_info: id, ip and date. Just remember that the columns 'id' of this
second table IS NOT auto-increment. Here is the code of the file which will count the clicks, ....
Its an complete login sistem made and tested by me and I think itwill be very usefull for people who
are tryn to learn PHP. First, let's make register.php: CODE include("conn.php"); //
create a file with all the database connections if($do_register){ // if the submit button were
clicked if((!$name) || (!$email) || (!$age) || (!$login) || (!$password) || (!$password2)){ print
"You can't let any fields in blank.\n"; // if the user did not put some field exit; } $name =
stripslashes($name); $email = stripslashes($email); $age = stripslashes($age); $login = s....
I thought I'd submit this little guide of mines, after I gave my friend an impromptu
introduction on this. I hope those who are new to PHP and MySQL will fin this usefull. What is
PHP? PHP is a scripting program, you install PHP into your server, BUT, you can only do it if you
have "physical" access to the server, (i.e. - you can close the server, add stuff to the server,
clear the server, remove the server). People who have web hosting accounts CAN NOT install PHP,
because, they only "own" a part of the server. You must be the server administrator in order to ins....
