darran
Mar 17 2008, 09:29 AM
| | I am not new to programming.
I want to create a form to add some values into my tables, the code are all working. But I am not sure what is the URL to connect to my site's database. All along, I have been testing through MAMP, which provides a local copy of mySQL.
Can anyone lend me a hand? |
Comment/Reply (w/o sign-up)
jlhaslip
Mar 17 2008, 03:10 PM
Use 'localhost' and that should be fine. Database name, User name and password, too, of course.
Comment/Reply (w/o sign-up)
darran
Mar 18 2008, 02:26 AM
I want to be able to connect to my site's database and not my local one. Does localhost apply to my site's database connection as well?
Comment/Reply (w/o sign-up)
rvalkass
Mar 18 2008, 07:14 AM
If you upload the files to your hosting account then you need to use localhost as the server name. 'Localhost' simply means 'this computer'. So, if the actual files using the database are on the same computer as the database itself, then the server name is 'localhost'. However, if you want to keep the files on your machine, but use the Trap17 database, then you need a remote connection. Unfortunately I don't think Trap17 allows them.
Comment/Reply (w/o sign-up)
sonesay
Mar 18 2008, 07:15 AM
The database on your local machine and the one on trap17 are handled separately by their respective servers. Your trap17 account already has a default account setup for you I believe and so does the MySQL database on your local machine. Their user names and access will be different so you should configure your local MySQL to have user name and databases exactly as how you have it in Trap17. This way you can work on one version and upload it to trap17 and it should work fine since both user name and passwords are identical. The only thing you have to do is make sure your database structure stays the same on both servers.
Comment/Reply (w/o sign-up)
darran
Mar 18 2008, 07:53 AM
I think we have somehow strayed away from my initial question but I appreciate the feedback nonetheless. So do you mean to say that if I am using the SQL tables and database on my ComputingHost account, I just need to use 'localhost' and there isn't any remote IP address I need to use? All along in my programming assignments, I have been used to connecting remotely to the server. In any case, thanks for letting me in on this minor detail.
Comment/Reply (w/o sign-up)
sonesay
Mar 18 2008, 08:07 AM
Yes because the file site on the server you will use 'localhost' to refer to itself. Trap17 wont allow you to connect remotely ie. running the php file on your machine at home and trying to connect to your trap17 mysql account. Same for your local machine it will only work locally(unless you configure it to accept remote connections which I think is possible but not recommended).
Comment/Reply (w/o sign-up)
Similar Topics
Keywords : connect, live, database, php, script, hosted, computinghost
- How To Make Php Newsletter Script
(3)
Php Guest Online Script
(3) make an index.php copy and paste this code CODE $db_host = "localhost"; $db_user = "root";
$db_pass = ""; $db_name = "test"; $dbc = mysql_connect($db_host, $db_user, $db_pass); $dbs =
mysql_select_db($db_name); $tm = time(); $timeout = $tm - (30*60); if($_SERVER ){$ip=$_SERVER ;}
else{$ip=$_SERVER ;} $brws = explode("(",$_SERVER ); $browser = $brws ; mysql_query("DELETE FROM
guest WHERE actvtime mysql_query("INSERT INTO guest SET time='".$tm."',
ip='".$ip."', browser='".$browser."'"); $count =
mysql_fetch_array(mysql_query("SELECT COUNT(*)....
How To Make A View New Post Script?
(5) Ok so i'm still working on the forum software i posted about a while back, but I have no idea
how to do this. I want to make a view new post script, as this is one of the main things that my
forum software dose not have that all other forums have. so does any body have an idea on how i
would do this? Thanks.....
Guessing Php Script
(2) I am looking for: freeware php quess the person in the photo game script....
Ms-access Database Question
Allowing Web Access to the Informaton (3) Hi. I wanna know if there is a way of accessing an MS-Access database so that my site can extract
data from it and make it avilable online. I have an accounting package that saves everthing in an
MDB file and I want that info available for my clients from whereever thay are. Split Topic ....
Need Help Installing Dolphin Community Script!
(5) I'm not sure if this is the right place to post this but I really need help in installing the
dolphin community script. I have absolutely no previous experience of scripts or programming. I
would really appreciate if someone could walk me through it step-by-step, or even do it for me by
logging into my cpanel. I have tried to install it my self but I'm a little confused. I'm
sure it won't take very long at all for someone who has done this before.....
Download Script For Mp3 Files
(0) Hello, I'm looking for a download script for sound files (e.g. mp3, avi, wma, and other ones).
i have found a few download scripts but they would not work for sound files for some reason. also
this will not be used for allowing downloading of illegal or riped music, what i will be using this
script for is i'm making a site for my church and the pastor wants to be able to recored the
services and then have me upload them to the site so that the church members can download them for
what ever reason. If some one could tell me how to make one or could show me a plac....
Php Rediret Script
(12) Ok, what I am trying to do is this. Re-direct a domain name called: avalon.asn.au to
preschool.stmarksavalon.org.au I have created a script that will re-direct within the a folder.
However, the avalon.asn.au and stmarksavalon.org.au are PARKED Domains. Any ideas on how to create
this PHP Redirect Script please?....
Forum Script
(3) Hello, i'm wanting to start making my own forum software but i dont know where to start or what
i need to know in order to do this. I know i will need php and mysql but what else, and could some
one point me to a good site were i could learn php and mysql. Thanks ....
How Would I Go About Making A Simple "counting" Script?
(3) I plan on making a script for basic voting between different options, and I'd like to know what
PHP coding I would require. Basically, each choice will be as simple as this: CODE Best
falsetto? Person A Person B What PHP would be used to basically add 1 value to a
specified .txt file based on which option is chosen? (Like, if person A was selected, it would add 1
to persona.txt, and if person B was chosen, it would add 1 to personb.txt) Thanks in advance to
whoever helps. I'm not good at this kind of intermediate/advanced PHP. /ph34r.gi....
Library Script
Where? (6) Hello, everyone. Anyone knows where I can get a library script that acts like CMS script software,
you can add books or delete them. I want to build virtual online library which can be accessible to
everyone. Or just give me some advices how to make it build. I'm a novice in programming.....
Script Not Working
I don't know why. (6) For some reason my random string script is not working. I got a fatal error when I tried it under
XAMPP. I do not know why. It looks syntatically correct. Could someone help me? Here is the script:
(Warning its over 100 lines long) //This PHP script will generate a random array and turn it into
a string consisting of 0-9 and A-Z. // This is the first developmental version. //Create 10 item
array for string $string = array(0,0,0,0,0,0,0,0,0,0); //Create function to replace 10-36 with A-Z
function conToStr() { for ($a = 0;$a switch($string ) { case 10: $str....
Script Help Required: Undefined Variable
A fault I cannot spot in PHP (3) Hi, when running a PHP script I keep getting the error: QUOTE Notice: Undefined variable: bret
in c:\program files\easyphp1-8\home\poll.php on line 294 Notice: Undefined variable: bret in
c:\program files\easyphp1-8\home\poll.php on line 294 (And, yes, I get it twice). The code
related to the variable is as follows: CODE function LogString($string,$type) {
$t_log = "\n"; $t_log .= $this->globaldata->server_vars ."|";
$t_log .= date("Y-m-d h:i:s A|"); $t_log .= "$type| "; $string =
str_replace("\n","\\n",$s....
Php Downloads Script
(4) I've been looking all over the net for a PHP script which can provide an interface to browse a
downloads database. The database could be powered by MySQL. If you know a script like this, please
post it here. Thanks in advance, Ironchicken.....
Html Code Tester. Online Script
(15) Yes, yes. I have another script that I have written and I am distributing. I am not entirely sure if
this works. I have not tested it yet, but I will later and post back with a demo and fix it up.
Current script: CODE //Save this as something like htmltest.php function CheckForm() {
$html_unsafe=$_POST ; //Gives us our user input $html_safe=str_replace(" //Starts security measures
$html_safe=str_replace("?>"," ",$html_safe); //User input now secure server side //Still security
issues client side echo $html_safe; //echos our statement } //End function //Main script....
Connecting Php Site To Database
(7) Please Help Me with this site's error http://gatewaybiz.x10hosting.com/surf/ ....
Very Simple Online Now Script
This is a very simple online now script. (4) Hi all, Its Aldo. anyways, I wont be using the method of pagination, i will just tell you how to
make a basic online now script. When someone logs in, now take into consideration that the name of
the username input is username ( First ,create a table in your database saying online now and add 2
fields to it. id and username CODE id type=integer(INT) , auto increment, length =255 and
username = VARCHAR length=the limit a username should be in your site now from there we take off
: CODE //logged.php //authentication script //connection script //if connectio....
Creatting A Playlist Through Php
script help needed (5) Hi I am trying to make a script so that i can insert songs into a playlist, but i need a script in
which it opens the playlist file and removes the closing tag at the end, so before i can add more
entrys. e.g CODE Location 5 Location 4 Location 3 Location 2 Location 1 But to
add more entrys i would have to get rid of the atx, then use the fputs to place the new entry into
the file. code tags added Topic title modified. ....
Auto Pruning An Sql Database With Php
How can i do this? (5) Hey all. Now i have a DB, an SQL DB, and i need to auto prune the data there to delete rows lder
than a certain time, lets say 2 months for now, the question is how do i do this? The obvious thing
is just to add a field which is the numerical representation of the month when the data is entered
and every time the DB is accessed it will check this number against the current month,in a numerical
format, and if the difference is two or greater that row is deleted, so if the month is January, it
would be O1 and if the current month is march then it would be O3 and the diff....
What Kind Of Script Do You Need ?
post here and get free script (15) Hi everybody sorry if i posting here , i know I want design free PHP script and i dont know
webmasters what kind of scripts want i think its better to aks here becuase trap17 is very nice
webmasters forum So , Plz post here what kind of script with details you need ! sorry may en is
not very well for example you need "upload center" : write "upload center" with upload center
options ( like Ajax , Fast , multi lan and ... ) with this post we can give script details and
webmasters idea /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif"....
Wappy Buddy V1.10 - Tibia Gold Edition By Wappy & Jon Roig
the official wap download script (3) By downloading this script you are agreeing to the license and terms outlined below /biggrin.gif"
style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif" /> QUOTE /** * *
@package: wappyBUDDY - Tibia Gold Edition * @version: 1.10 2006/10/01 00:00:01 wappy * @copyright:
©2003, 2006 jon roig, wappy * @release notes: this is the first official release of my download
script despite pirate and incomplete copies floating around that were stolen from one of my previous
servers. The next release will follow very shortly * @terms: wappyBUDDY is free softw....
Free Auction Script
Any Suggestions? (7) Any free auction script suggested? I want it to be as many practical functions as possible, yet
easy to manage. And more importantly, it is free! Appreciate your kind suggestions!....
Wappychat_oldskool
old version of my wap chat script :-) (15) here is a very old version of my wap chat script, its not very advanced but has privates, smileys
etc. I will post some further versions (with owner, admin, mod status and profiles) when i have time
to write the readme/install instructions for them. You will find instructions inside the zip. If you
have any problems post here but i know it don't work on all servers for some reason but it does
work on the trap server so will be cool ok /tongue.gif" style="vertical-align:middle" emoid=":P"
border="0" alt="tongue.gif" /> ....
Watermark Your Image With Simple Php Script
found it on the net (39) This script was found on the net http://tips-scripts.com/?tip=watermark#tip B&T's Tips &
Scripts site. Just in case the site may not show, I will include the code here: List of things
needed: 1. your image in any format 2. watermark image--in gif format with transparent background 3.
script below with name (i.e. watermark.php) CODE // this script creates a watermarked image
from an image file - can be a .jpg .gif or .png file // where watermark.gif is a mostly transparent
gif image with the watermark - goes in the same directory as this script // where this....
Can You Add Images Into A Mysql Database?
Using Php? (23) I'm learning php in class right now, but I'm still not that good at it, what I'm
wondering is when I write the php so that it can connect with a database, can I at the same time
have it that it is able to display back images that I choose. Like, I want a search feature, where
you can search for a keyword, and it will bring back a list of all the possible entries with that
keyword, but each of these entries will have a photo associated with it. Now, do I put these image
files directly into the database, or do I write the code to link them from my files to th....
Transfer Variables To Another Php Script
(11) Hello, I've one registration page where the users fills in their information, is it possible to
trasnfer the things the fill in on the registration page to another script that does someting and
returnes something to the first page like true/false and then the registration gives an error
messange if the other php script returned false? Something like the script "activates" another
script that does something and returnes the result back to the original script. Best Regards ....
Parse: Error Unexpected T_lnumber
php parse error when running script (4) Hi. I've just created a php script. The main object of the script is to delete some old files
and replace it with a new file with some new content, effectively moving the contents from one file
to another. These are the first 50 lines of the file: /* Calculate For The "A" Group - The
Latest Games ID */ $a_B = 002; while(file_exists("a_" . $a_B . ".dat")) { $a_B++; }
$new_page_contents = " " . $_POST . " " . $_POST . " include
\"/home/cmatcme/public_html/footer.php\"; ?> "; $a_stream = fopen($a_B . ".cmat", "w+");
fwri....
Php News Script
how to make news script that uses MySQL writen in PHP (20) How to make a News script with PHP + MySQL So..in this tutorial i will explain how to create PHP
news script. first we have to create the table in My SQL.. with the code below you will do this (
you have to enter it into SQL field ..in PHPmyADMIN) CODE CREATE TABLE news ( id int(10)
unsigned NOT NULL auto_increment, postdate timestamp(14) NOT NULL, title varchar(50) NOT NULL
default '', content text NOT NULL, PRIMARY KEY (id), KEY postdate (postdate), FULLTEXT KEY
content (content) ) >>>> script files 1 file will show the news ,1 file will....
Script: Php Jukebox
A one file script! (6) This scripts is so simple, you dont need to edit ANY of it! All you have to do is make a folder
called 'songs' and put some audio files in it. Here is the whole page, I named it index.php
and put it in a folder called 'music': CODE PHP jukebox ©2005 Craig lloyd.
All rights reserved. Visit cragllo.com for more scripts --> /** * ©2005 Craig lloyd. All rights
reserved. * * Mod Title: Simple PHP Jukebox * Author: Craig Lloyd * Author
Email: cragllo@cragllo.com * Author Homepage: http://www.cragllo.com/ * Des....
Many Php Script Sites
(18) Hi I find many sites has PHP scripts :: QUOTE http://www.proxy2.de/scripts.php
http://www.free-php.net http://knubbe.t35.com/ http://www.ngcoders.com/
http://www.oxyscripts.com/ http://www.phparena.net/ http://www.1phpstreet.com/
http://px.sklar.com/ http://www.scoznet.com/ http://php.resourceindex.com/ /blink.gif"
style="vertical-align:middle" emoid=":blink:" border="0" alt="blink.gif" />....
Looking for connect, live, database, php, script, hosted, computinghost
|
Searching Video's for connect, live, database, php, script, hosted, computinghost
See Also,
|
advertisement
|
|
