Solved

Using Script to create tables...

Posted on 2002-04-22
15
202 Views
Last Modified: 2006-11-17
I am really just learning MySQL and PHP, and also have a project I need to get done with the deadline coming up soon.

The server that hosts the website does not allow me to use a command line, so I think I need to use scripts to create my tables. Andriv offered me the following code in another question:

$dbconnect = mysql_connect("host","user","password");
$mysql_select_db("dbName",$dbconnect);
$Query = "Create table tableName (prodid int(10) not null auto_increment,next field,next field)";
mysql_query($Query);


My question is, what do I surround the code with? HTML? PHP?

If PHP I would assume it would look like the following:

<?
   code from Andriv, to build table and columns
?>

Then would I need an HTML form to run the PHP, like this?

<html>
<head>
</head>
<body>

<form action="xxxx.php" method=post>
<table border=0>
<tr>
  <td colspan=2 align=center><input type=submit value="Submit Order"></td>
</tr>
</table>
</form>  

</body>
</html>


I really appreciate the help.



0
Comment
Question by:GaryZ
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
15 Comments
 
LVL 1

Expert Comment

by:bowker
ID: 6961609
Download phpMyadmin (http://sourceforge.net/project/showfiles.php?group_id=23067 then select the last entry under 2.2.6 which is phpMyAdmin-2.2.6-php3.zip) ... that's a group of scripts which forms a GUI frontend  to MySQL.  Edit the config.inc file to embed your MySQL username and password, then upload all the scripts to your shared server using FTP.

You will probably want to password-protect the subdirectory where you put the program - if you have Telnet access, you can do this with an .htaccess and .htpasswd file ... otherwise, look for another project on SourceForge called "phpaccess" -- put this script in the same subdir as phpMyAdmin and run it to create the password protection you need.

This is an overview - please let me know if I can give you any other details ...

Bob.
0
 

Author Comment

by:GaryZ
ID: 6961675
Will this run on Windows 2000 or only on the host server?
0
 
LVL 4

Expert Comment

by:lokeshv
ID: 6961811
u have to upload that t ur server..


u can try this also...

<?
if($submit){
$dbconnect = mysql_connect("host","user","password");
$mysql_select_db("dbName",$dbconnect);
$Query = "Create table tableName (prodid int(10) not null auto_increment,next field,next field)";
$result=mysql_query($Query);
if(!$result){
    echo "Error:".mysql_error();
}
}
else{
?>

<html>
<head>
</head>
<body>

<form action="<?=$PHPSELF?>" method=post>
<table border=0>
<tr>
 <td colspan=2 align=center><input type=submit name=submit value="Create Table"></td>
</tr>
</table>
</form>  

</body>
</html>
<?}?>


Hope this helps...

LK

0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Expert Comment

by:peebody
ID: 6962229
And please always use <?php ?> to embedd your php code, because not every environment accepts <? ?>

PP
0
 
LVL 1

Expert Comment

by:bowker
ID: 6962820
GaryZ -

phpMyAdmin runs on the server ... it's a GUI frontend to MySQL, enabling you to add/edit/delete tables, add/edit/delete records, - in short, control the whole database.  On your local machine, edit config.inc (to add your username, password and database name) then use FTP to upload all the files to your server, for example, into a new subdirectory (under the web root dir) called "phpmyadmin".  Then point your browser to http://www.yourdomain.com/phpmyadmin/index.php3 and you're off and running ...

PHPAccess is a similar process, although there's nothing to edit ahead of time.  Use FTP to upload the file intpo /phpmyadmin, then point your browser to http://www.yourdomain.com/phpmyadmin/phpaccess.php to run the script.  This script allows you to add/edit/delete Usernames and Passwords controlling access to all files in the subdirectory /phpmyadmin where it's located.  Now, when you go to phpmyadmin/index.php3 you'll be challenged for your username and password ...

Let me know if I can help you walk through all this ...

Bob.
0
 

Author Comment

by:GaryZ
ID: 6967219
OK. I have downloaded the file and unzipped it into a directory. Now I need to configure the config.inc.php3 file.

It says to change host,user, password, and authentication mode.

The ISP sent me the name of the database they created, plus the username and password. Is the host the domain name? What about the authentication mode?

It also appears that these have to be changed in more than one spot?

The database will contain inventory information and will be accessed by a search form from the internet. There is not special login needed, anyone should be able to do the search.
0
 
LVL 1

Accepted Solution

by:
bowker earned 150 total points
ID: 6967420
Gary --

You only have 3 changes to make ... leave the rest as-is:

$cfgServers[$i]['host']          = 'localhost';              // leave as 'localhost'
$cfgServers[$i]['port']          = '';        
$cfgServers[$i]['socket']        = '';        
$cfgServers[$i]['connect_type']  = 'tcp';      
$cfgServers[$i]['controluser']   = '';        
$cfgServers[$i]['controlpass']   = '';      
$cfgServers[$i]['auth_type']     = 'config';    
$cfgServers[$i]['user']          = '';                                // enter your username
$cfgServers[$i]['password']      = '';                          // enter your password
$cfgServers[$i]['only_db']       = '';                             // enter your database name

If you still have problems, send me your telephone number bowker@inetwebinc.com and I'll talk you through the process ...

Bob.
0
 
LVL 1

Expert Comment

by:bowker
ID: 6967429
Gary --

Sorry, the code I quoted starts at line 46 of config.inc.php3 ... you can safely delete lines 69 through 99 inclusive, as you'll only be using this installation for 1 database.

Bob.
0
 

Author Comment

by:GaryZ
ID: 6973646
I have it loaded and renamed the php3 to php, I get the following error when I try to run index.php. It appears that maybe the hosting domain does not have something set up of I need to get a path from them

Fatal error: Failed opening required './libraries/grab_globals.lib.php' (include_path='')
0
 
LVL 1

Expert Comment

by:bowker
ID: 6974113
Gary --

It's referring to a file that should be in the dir /libraries under phpMyadmin ... did you create the dirs phpMyadmin/libraries, phpMyadmin/lang and phpMyadmin/images on the server and upload the files in those corresponding subdirs from your drive to the server?

Bob.
0
 

Author Comment

by:GaryZ
ID: 6974885
I have to chagne all references to php3 to php. PHP3 does  not work on the server.
0
 

Author Comment

by:GaryZ
ID: 6974940
Yep, that was the problem, came right up (Oh, you also have to configur the line that has the path to the mySQLAdmin directory).

One last question. I downloaded the phpaccess and unzipped. There is no documentation, do I just load the script htaccess.class.php to the server and run it to set the username and password?
0
 
LVL 1

Expert Comment

by:bowker
ID: 6975115
Gary --

Yes, that's it ... but the file I downloaded has just 1 PHP script named phpaccess.php - no associated class, just the script.

This script creates and manages access to the subdirectory in which you place it, and from which you run it.  Should you ever need to get rid of challenge-response access to that dir, delete the files .htaccess and .htpasswd, which phpaccess creates and manages for you.

You do need to protect this directory, and phpaccess is the easiest way to do that.

Bob.
0
 
LVL 1

Expert Comment

by:bowker
ID: 6975125
Gary --

You can make your PHP installation handle files with .php3 by adding the following line to the .htaccess file in the main directory:

AddType application/x-httpd-php .php3

If the main dir does not already have a file named .htaccess, then create one with the single line and upload it ... the line forces Apache to hand files named .php3 off to PHP.  Obviously the line

AddType application/x-httpd-php .html

... would do the same for all files with .html, too.

Bob.
0
 

Author Comment

by:GaryZ
ID: 6975144
Thanks for the help. I will probably be back for more.
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to count occurrences of each item in an array.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question