Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL webpage connection problem

Status
Not open for further replies.
pepy

pepy

Technical User
Jan 14, 2004
19
US
i have made a mysql database at freesql.org
i can connect to it using different myadmin progams.

but i cant for the life of me connect to it using a web page??
For "weeks" i have tried many different ways using php.

freesql.org is not my server, this may have something to do with it??
I have tried 100s of different ways to connect to it....
below is one of the ways i have tried....

Maybe one of you can see what i am doing wrong
Please help

Thank you
Pepy


<html>
<head>
<TITLE></TITLE>
<META HTTP-EQUIV=&quot;Content-Type&quot; CONTENT=&quot;text/html&quot;>

</head>

<BODY>

<?
$username=&quot;xxxxxxxxxxxxxx&quot;;
$password=&quot;xxxxxxxxxxxxxx&quot;;
$database=&quot;dbsell&quot;;

$db = mysql_connect(&quot;freesql.org&quot;, $username, $password);
@mysql_select_db(dbsell) or die( &quot;Unable to select database&quot;);

$query=&quot;SELECT * FROM t1&quot;;
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();


echo &quot;<b><center>Database Output</center></b><br><br>&quot;;

$i=0;
while ($i < $num) {

$domain=mysql_result($result,$i,&quot;name&quot;);
$code=mysql_result($result,$i,&quot;code&quot;);


echo &quot;<b>$domain $code</b>&quot;;

++$i;
}

?>

</body>
</html>

 
Sort by date Sort by votes
Have you tried using Netfirm's mysql? They say you get 10 free mysql databases, so I'd check that out. Since they offer this, they may charge more for extra databases. Therefore to get you to pay for these extra databases they probably wouldn't let you use services like freesql.org

 
Upvote 0 Downvote
i cant read german...lo Click on the one of the Falgs it will show u in English also. Besides there is mini version. it has all what is required Apache/MySql/PHP.

By the way if are using Linux orUNIX probable u have all the stuff Make ur server as web server/mysql server and start working

but i am still under the imperession that only the remote host requires the mysql, Apache and php.
and that you dont have to be a deitcated server yourself?
Yes u dont reqiure anything but then ur web pages must be at server end i.e on the web server in DocumentRoot for Web/Virtual Server.

i tried to connect from my website (presently it has no information), i was able to connecto ur website with script otheres have tried to test. it seems that some apache setting is also invloved.
u may try to test



[ponder]
----------------
ur feedback is a very welcome desire
 
Upvote 0 Downvote
philote , i think you are right.....
i even said this in my first and second posts.

&quot;freesql.org is not my server, this may have something to do with it??&quot;

as well as other posts through out.

---------------------------------------------------

I am going to stop until i find a sql php host.
i can find a much better than netfirms at 50% less cost and with unlimited MySQL Databases and ftp accounts


one example here--->

ComputerPeople.org 30-Day Money Back Guarantee

3 Months Prepay -
6 Months Prepay 4.95 (Free set-up)
12 Months Prepay 3.95 (Free)
24 Months Prepay -

Plan Features ComputerPeople
Disk Space 100 MB
Bandwidth 15 GB
FTP Accounts unlimited
CGI-BIN, Perl & SSI Yes
PHP Yes
Frontpage Extensions Yes
Raw Log Files Yes
Protected Directories Yes
Anonymous FTP Yes
Telnet/SSH Yes

Email Features ComputerPeople
Email Accounts unlimited
Forwarders (Alias) Yes
Autoresponders Yes
Web-Based Email Yes
IMAP Protocol Yes
Mailing List Yes

Software Used ComputerPeople
Platform OS Linux
Control Panel CPanel
Web Stats Webalizer, Analog Webalizer,

MySQL Features ComputerPeople
MySQL Database unlimited
PHPMyAdmin Yes

Domain Features ComputerPeople
Subdomains unlimited
Domain Pointers unlimited

Ecommerce Features ComputerPeople
Shared SSL Yes
Shopping Cart osCommerce, Interchange

--------------------------------------------------------
for a full list of cheap sites

-------------------------------------------------------

I proablity cant do much bettter that this, 3.95 a month with unlimited MySQL Databases and ftp accounts, to keep things organized,
but if you know if a host which is plz let me know......



--------------------------------------------------------
I will be back but for now i think my problem is that i dont have everything on one host and anything that can make this sql stuff easier is deafeantly a bonus.


-----------------------------------------------------------
I want to personaly thank,

tshot, philote, rgbatson, and rzs0502
for your in put and help.

I will be back when i have set this up
thank you
pepy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Gerrit Broekhuis
  • Locked
  • Question
create connection by code
Replies
2
Views
215
Gerrit Broekhuis
Gerrit Broekhuis
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
280
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with &quot;UNION&quot; 1
Replies
5
Views
244
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
177
spamjim
spamjim
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
302
dylim
dylim

Part and Inventory Search

Sponsor

Back
Top