got a question : php + mysql = love

counter · 11-10-2007, 11:03 AM

the title is just to make u read this topic

What is the best Free news script which is available online ?
i am planning to run a news site and am not sure what script to choose

anyways i want to know how can i take data from a mysql database which is not on my server

like i got a database on an other server i want to take data from it from my first server how is the code in php for that written

thx

Daniel · 11-10-2007, 11:04 AM

Code:

mysql_connect('server', 'mysql_user', 'mysql_password');

Can be expanded to...


$link = mysql_connect('example.com:3307', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);

You'll need the settings that govern external DB connections to be set up correctly.

Barrucadu · 11-10-2007, 11:23 AM

No need for a $link variable, unless you plan to have multiple connections open at once.

PHP Code:

  mysql_connect('example.com:3307', 'mysql_user', 'mysql_password')or die(mysql_error());

 
/* Stuff Here */

 
mysql_close();

Peter · 11-10-2007, 11:32 AM

What danltn has provided is 100% correct but bear in mind that the database server must be set up to allow connections from external sources (most people set up their servers to only allow connections from trusted people.

Also if the mySQl server is on a different network then you will encounter lag time. If you are using it to output data to a user then the load time of the page will be affected adversely.

mholt · 11-10-2007, 08:29 PM

Don't get intimidated by all the configuration. it's not too difficult. In CPanel, set an access host on the database server to be the IP address of the client system that is accessing it. Then, if it still doesn't work, contact your database server's host to disable any firewalls for that domain on port 3307. Even if you didn't order firewall services, their networking team may have instilled a block on it.

I had to do this to get my C# application on my PC to access a database on my server in Canada. The support team figured out what was causing the block and fixed it. It's really simple, really then:

1. Set access host to allow the IP of the accessor.
2. Contact host of db server if there are still problems.

counter · 11-11-2007, 12:33 AM

ok guys that was helpful ( i just wanted to know the way to write it) ill try it and let u know the result
anyways i got more important question
i am working on a news script that is about to collaps as its going to take me sometime to make a proper one when i can find loads of good scripts online

What is the best Free news script which is available online ?
i am planning to run a news site and am not sure what script to choose

Joe · 11-11-2007, 05:37 AM

An alternative to reading it from MySql is CuteNEWS.

It is a fantastic news system, that uses flat files (information stored in files):
http://cutephp.com/cutenews/
It is very easy to use!

They do, however, have a copyright that is placed at the bottom of your page.

Joe

counter · 11-11-2007, 11:34 AM

hmm
saw this please do u know other (better or without credit)

BTW please guys i want it very very search engines friendly

mholt · 11-13-2007, 06:56 PM

Well, WordPress could be modded up a bit...

counter · 11-25-2007, 11:37 AM

oh where can i get WordPress
i googled it i couldnt find what am searching for what is that

Peter · 11-25-2007, 11:49 AM

wordpress is a blogging software http://wordpress.org/

Daniel · 11-25-2007, 12:24 PM

Quote:

Originally Posted by counter

oh where can i get WordPress
i googled it i couldnt find what am searching for what is that

Wow, no offence but that is the dumbest thing I've ever heard.

http://www.google.co.uk/search?q=WordPress
http://search.yahoo.com/search?p=WordPress
http://www.ask.com/web?q=WordPress
http://search.live.com/results.aspx?q=WordPress

All of which it ranks #1 for... Along with http://wordpress.org (and other exts.)

Did you even try searching for it?

Here's the link:

http://wordpress.org

counter · 11-26-2007, 11:51 PM

actualy i searched for Words Press check what i got http://www.google.co.uk/search?hl=en...G=Search&meta=

11-10-2007, 11:03 AM	#1 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52 0.00 NP$ (Donate)	got a question : php + mysql = love the title is just to make u read this topic What is the best Free news script which is available online ? i am planning to run a news site and am not sure what script to choose anyways i want to know how can i take data from a mysql database which is not on my server like i got a database on an other server i want to take data from it from my first server how is the code in php for that written thx Last edited by counter; 11-11-2007 at 12:51 AM. Reason: s

11-10-2007, 11:04 AM	#2 (permalink)
Daniel Danltn.com Join Date: May 2007 Location: Danltn.com / Nottingham, UK Posts: 1,201 13.51 NP$ (Donate)	Code: mysql_connect('server', 'mysql_user', 'mysql_password'); Can be expanded to... $link = mysql_connect('example.com:3307', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); You'll need the settings that govern external DB connections to be set up correctly. __________________ *VERY CHEAP ADVANCED* BULK DOMAIN-STATISTICS LOOKUP** Danltn's Blog - Daniel Neville's Site Spoof your links! Submit your blog NOW! Putting bloggers on the map! Last edited by Danltn; 11-10-2007 at 11:07 AM.

11-10-2007, 11:23 AM	#3 (permalink)
Barrucadu Barru. Join Date: Aug 2005 Location: East Yorkshire, England Posts: 2,731 78.50 NP$ (Donate)	No need for a $link variable, unless you plan to have multiple connections open at once. PHP Code: `mysql_connect('example.com:3307', 'mysql_user', 'mysql_password')or die(mysql_error()); /* Stuff Here / mysql_close();` __________________ Website \| Blog \| Uzbl (my branch)* 9thSeptember2009.com

11-10-2007, 11:32 AM	#4 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	What danltn has provided is 100% correct but bear in mind that the database server must be set up to allow connections from external sources (most people set up their servers to only allow connections from trusted people. Also if the mySQl server is on a different network then you will encounter lag time. If you are using it to output data to a user then the load time of the page will be affected adversely. __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

11-11-2007, 05:37 AM	#7 (permalink)
Joe Senior Member Join Date: Oct 2005 Location: Kent ~ U.K. Posts: 3,246 88.85 NP$ (Donate)	An alternative to reading it from MySql is CuteNEWS. It is a fantastic news system, that uses flat files (information stored in files): http://cutephp.com/cutenews/ It is very easy to use! They do, however, have a copyright that is placed at the bottom of your page. Joe __________________ Fused Hosting Simplicity and Superiority. █████████████████████████████████████████████ Affordable web hosting solutions; shared, reseller, shoutcast, WHMSonic, proxy, dedicated and more! My computer is broken; new components have been ordered.

11-10-2007, 08:29 PM	#5 (permalink)
mholt DNOA Member Join Date: May 2004 Location: Utah Posts: 5,041 18.01 NP$ (Donate)	Don't get intimidated by all the configuration. it's not too difficult. In CPanel, set an access host on the database server to be the IP address of the client system that is accessing it. Then, if it still doesn't work, contact your database server's host to disable any firewalls for that domain on port 3307. Even if you didn't order firewall services, their networking team may have instilled a block on it. I had to do this to get my C# application on my PC to access a database on my server in Canada. The support team figured out what was causing the block and fixed it. It's really simple, really then: 1. Set access host to allow the IP of the accessor. 2. Contact host of db server if there are still problems.

11-11-2007, 12:33 AM	#6 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52 0.00 NP$ (Donate)	ok guys that was helpful ( i just wanted to know the way to write it) ill try it and let u know the result anyways i got more important question i am working on a news script that is about to collaps as its going to take me sometime to make a proper one when i can find loads of good scripts online What is the best Free news script which is available online ? i am planning to run a news site and am not sure what script to choose

11-11-2007, 11:34 AM	#8 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52 0.00 NP$ (Donate)	hmm saw this please do u know other (better or without credit) BTW please guys i want it very very search engines friendly

11-13-2007, 06:56 PM	#9 (permalink)
mholt DNOA Member Join Date: May 2004 Location: Utah Posts: 5,041 18.01 NP$ (Donate)	Well, WordPress could be modded up a bit...

11-25-2007, 11:37 AM	#10 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52 0.00 NP$ (Donate)	oh where can i get WordPress i googled it i couldnt find what am searching for what is that

11-25-2007, 11:49 AM	#11 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	wordpress is a blogging software http://wordpress.org/ __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

11-26-2007, 11:51 PM	#13 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52 0.00 NP$ (Donate)	actualy i searched for Words Press check what i got http://www.google.co.uk/search?hl=en...G=Search&meta=

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