Adding tables to a Database...

[Random]

Is there a way to add a table to a database when I do not host the mysql databases? Like through a PHP script? Thanks in advance.

[DocSeuss]

It is pretty easy actually, as long as the user name and password has the permission to connect to the mysql server remotly.

[Random]

uh please post an example how?

[DocSeuss]

your connection in the script will be normal except your would obviously us the ip or domain name of the remote machine instead of localhost.

 

 

now on the remote machine every user has an attribute as to where they are allowed to connect from, localhost is the most common, but that isn\'t gonna work for someone from a remote machine even if they know the correct u/n and pass. What sort of admin software do you use on the mysql machine, phpmyAdmin?

[Random]

I have no idea, my friend hosts my site he lives in Arkansas, I live in Indiana.

[shivabharat]

Is there a way to add a table to a database when I do not host the mysql databases? Like through a PHP script? Thanks in advance.

 

Now there are 2 ways of doing that

write a .sql file which would carry the table insert command

 

run the script to create the database.

 

now if u want to do from a program

 

its pretty simple to what u do

 

type in the query

 

$db = mysql_connect("localhost", "admin","admin");



mysql_select_db("db_name",$db);



$sql = "CREATE TABLE test (

 id int(11) NOT NULL auto_increment)";



$result = mysql_query($sql);

 

Hope this helps!!

[Random]

Is there a way to add a table to a database

$db = mysql_connect("localhost", "admin","admin");



mysql_select_db("db_name",$db);



$sql = "CREATE TABLE test (

 id int(11) NOT NULL auto_increment)";



$result = mysql_query($sql);

 

Will this work from a PHP script that I upload and execute in the server, if I just change localhost to the IP/Domain name of the server?

[metalblend]

yes, that will work as long as your host has given your account permission to remotely modify the database.

[Random]

will it display anything, like \"Database Table Successfully Installed\" or something of that sort? And what if i goto that site over and over, it will only make one table, right?

[shivabharat]

$db = mysql_connect("localhost", "admin","admin"); 



mysql_select_db("db_name",$db); 

   

$sql = "CREATE TABLE test ( 

 id int(11) NOT NULL auto_increment)"; 



$result = mysql_query($sql) or die("Table not created");



echo "Table created sucessfully";

[Random]

im getting this error when I put in the script and changed it around to fit my needs:

 

Warning: mysql_connect() [function.mysql-connect]: Can\'t connect to MySQL server on \'random.travisbsd.no-ip.org\' (60) in /usr/home/random/pubhtml/database.php on line 2

 

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /usr/home/random/pubhtml/database.php on line 4

 

 

here is the script:

 

<?php

$db = mysql_connect("random.travisbsd.no-ip.org", "CENSORED","CENSORED"); 



mysql_select_db("random",$db); 

   

$sql = "CREATE TABLE test ( 

 id int(11) NOT NULL auto_increment)"; 



$result = mysql_query($sql);

?>

[shivabharat]

$db = mysql_connect(\"random.travisbsd.no-ip.org\", \"CENSORED\",\"CENSORED\");

 

Are u sure this is the host name \"random.travisbsd.no-ip.org\"

 

u can also try giving the IP .

[Random]

He said that the port may not be right..is that a possibility?

[Random]

update:

 

he told me to use localhost, and it worked to the point of no errors coming up, so I used a or die statement, and it went off. What could it be now? Localhost is right, and my names, etc. is all right. Thanks

[DocSeuss]

lol, so your site that you are working on is actually located on the box in Arkansas.

[Random]

yes