Why wont this work??

Barrucadu · 09-24-2005, 08:10 AM

myfileminder.com/articles/dbconnect.php

PHP Code:

  $server="---server---";

????: NamePros.com http://www.namepros.com/programming/126236-why-wont-this-work.html
$user="---username---";

$pass="---password---";

$database="---database---";

$sql="---query---";

webmaster.php

PHP Code:

  include 'http://www.myfileminder.com/articles/dbconnect.php';     

mysql_connect($server,$user,$pass) or die("Could not connect to database: " . mysql_error());

mysql_select_db($database) or die("Could not select the database: " . mysql_error());

$result=mysql_query($sql) or die("Could not query the database: " . mysql_error());

mysql_close();

When I run it I get the error

Code:

Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in e:\domains\m\myfileminder.com\user\htdocs\articles\webmaster.php on line 16

line 16 is this:
????: NamePros.com http://www.namepros.com/showthread.php?t=126236

PHP Code:

  mysql_connect($server,$user,$pass) or die("Could not connect to database: " . mysql_error());

but I cant find the problem.

aween · 09-24-2005, 09:23 AM

Code:

include 'http://www.myfileminder.com/articles/dbconnect.php';

you cant do that if you are on a different server/ip
????: NamePros.com http://www.namepros.com/showthread.php?t=126236

do this:

Code:

include 'dbconnect.php';

Barrucadu · 09-24-2005, 09:53 AM

hmm... thing is I want that script to work on other peoples sites, its an article script I'm working on, thats the script webmasters use to display the articles...

csmaster2005 · 09-24-2005, 10:57 AM

you're going to have to provide the username/pass/ip as a feed then parse it out since you're doing it remotely. Or you could also just provide the info that they're going to put on their site as a feed then you wouldnt need the whole connection issue.

Barrucadu · 09-24-2005, 11:17 AM

Quote:

provide the info that they're going to put on their site as a feed

how the hell would I do that?

csmaster2005 · 09-24-2005, 10:06 PM

You may want to research what a feed does..
basically you print all the info on a page, and then you write your script to goto your site and parse the info from that page.

09-24-2005, 08:10 AM	THREAD STARTER #1 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	Why wont this work?? myfileminder.com/articles/dbconnect.php PHP Code: `$server="---server---"; ????: NamePros.com http://www.namepros.com/programming/126236-why-wont-this-work.html $user="---username---"; $pass="---password---"; $database="---database---"; $sql="---query---";` webmaster.php PHP Code: `include 'http://www.myfileminder.com/articles/dbconnect.php'; mysql_connect($server,$user,$pass) or die("Could not connect to database: " . mysql_error()); mysql_select_db($database) or die("Could not select the database: " . mysql_error()); $result=mysql_query($sql) or die("Could not query the database: " . mysql_error()); mysql_close();` When I run it I get the error Code: Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in e:\domains\m\myfileminder.com\user\htdocs\articles\webmaster.php on line 16 line 16 is this: ????: NamePros.com http://www.namepros.com/showthread.php?t=126236 PHP Code: `mysql_connect($server,$user,$pass) or die("Could not connect to database: " . mysql_error());` but I cant find the problem. __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385 Last edited by Mikor; 09-24-2005 at 08:23 AM.

09-24-2005, 09:23 AM	#2 (permalink)
aween Pro Coder & Designer Join Date: Apr 2005 Location: Netherlands Posts: 967	Code: include 'http://www.myfileminder.com/articles/dbconnect.php'; you cant do that if you are on a different server/ip ????: NamePros.com http://www.namepros.com/showthread.php?t=126236 do this: Code: include 'dbconnect.php'; __________________ aween web development

09-24-2005, 09:53 AM	THREAD STARTER #3 (permalink)
Barrucadu Senior Member Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,689 Follow @barrucadu	hmm... thing is I want that script to work on other peoples sites, its an article script I'm working on, thats the script webmasters use to display the articles... __________________ Website \| Blog Arch Hurd developer; GNU Webmaster; FSF member #8385

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Looking for Support / Design Work	webdirect	For Sale / Advertising Board	0	05-29-2005 03:01 AM
CAUTION: Don't work with Metalicdesigns/ Serverplace NET	Deathdart	Web Development Wanted	30	03-28-2004 06:56 AM

09-24-2005, 10:57 AM	#4 (permalink)
csmaster2005 Senior Member Join Date: Mar 2004 Location: U.S.A. Posts: 1,985	you're going to have to provide the username/pass/ip as a feed then parse it out since you're doing it remotely. Or you could also just provide the info that they're going to put on their site as a feed then you wouldnt need the whole connection issue.

09-24-2005, 10:06 PM	#6 (permalink)
csmaster2005 Senior Member Join Date: Mar 2004 Location: U.S.A. Posts: 1,985	You may want to research what a feed does.. basically you print all the info on a page, and then you write your script to goto your site and parse the info from that page.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)