Re: [PHP] mysql_connect does not connect

2004-09-19 Thread Sam Hobbs
Raditha Dissanayake [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sam Hobbs wrote: I have posted over 12,000 messages in the CodeGuru.com Visual C++ forum, Do you have a life ? I hope the moderators protest posts such as this. -- PHP General Mailing List (http://www.php.net

Re: [PHP] mysql_connect does not connect

2004-09-19 Thread Sam Hobbs
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Would you mind spilling the beans? I'm sure everyone is dying to know what the resolution of this thread is. I definitely mind. I don't believe in rewarding bad behavior. It is reasonable to contribute to the productive

Re: [PHP] mysql_connect does not connect

2004-09-18 Thread Sam Hobbs
Curt Zirzow [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] * Thus wrote Sam Hobbs: And the relevant portion of that says external access, which is not applicable here. I do not see anything else on that page that is relevant. what is relevant? only the last one? :sigh: I don't

Re: [PHP] mysql_connect does not connect

2004-09-18 Thread Sam Hobbs
Curt Zirzow [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Um.. you do realize you have more problems than php not being able to connect to the database. This is the type of unproductive comment that causes problems. The only reason you are saying this is because you are desperate

Re: [PHP] mysql_connect does not connect

2004-09-18 Thread Sam Hobbs
nothing. I hope the moderators agree. Would I be correct if I paraphrased the above as: The wrong way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall might be blocking your attempts to connect to mysql. Try disabling it. [SH] Yeah and what makes you

Re: [PHP] mysql_connect does not connect

2004-09-18 Thread Sam Hobbs
Steve Brown [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sam, if you wouldn't mind answering a question: are you still unable to connect to your mysql server? I am able to connect now. I'm sorry that you feel its a time-consuming process. I'm sorry that you are confused about

Re: [PHP] mysql_connect does not connect

2004-09-18 Thread Sam Hobbs
Matthew Sims [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You should check as XP SP2 firewall is turned on by default. http://support.microsoft.com/default.aspx?kbid=842242 Saying You should check assumes I did not check. I did check. I said as far as I know it is off. I am

Re: [PHP] mysql_connect does not connect

2004-09-18 Thread Sam Hobbs
That is the type of comment that causes problems. Reasonable and knowledgable people know it is not true and saying it just causes problems. Of course, many people would advise to just ignore comments such as that and I will in the future. I just want to make it clear for the benefit of others

Re: [PHP] Re: mysql_connect does not connect

2004-09-18 Thread Sam Hobbs
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Unfortunately (fortunately?) there are packages out there which install all Apache/MySQL/PHP for you or whatever. So unless you state which package you're using then typical is still meaningless. It's just helpful when

Re: [PHP] mysql_connect does not connect

2004-09-17 Thread Sam Hobbs
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] The firewall is relevant depending on your circumstances. In any case it would take you all of one minute to disable your firewall to test out this wild far out suggestion. At the most you would have lost one minute but

Re: [PHP] mysql_connect does not connect

2004-09-17 Thread Sam Hobbs
Markus Mayer [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] It is our experience at my employer that the firewall in XP-SP2, as well as other firewalls that are available, are very relevant. Thank you. I have not seen anything that states that explicitly. I doubt that SP2 makes

Re: [PHP] mysql_connect does not connect

2004-09-17 Thread Sam Hobbs
It is innacuracies such as this that make it difficult for me to pursue the useful suggestions. Chris Dowell [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] All this is irrelevant; while you're still trying to use MySQL 5 with mysql_connect() instead of mysqli_connect(), it WILL

Re: [PHP] mysql_connect does not connect

2004-09-17 Thread Sam Hobbs
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] IIRC the OP did have a successful test case when connecting from the mysql client. Yes, I did get it to work. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] mysql_connect does not connect

2004-09-17 Thread Sam Hobbs
John Nichel [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] The MySQL functions work fine in php5. It just doesn't support all the features available in MySQL = 4.1.0. Unlike php4, support for MySQL isn't bundled in php5, but when enabled, it works. Thank you. I will try to

Re: [PHP] mysql_connect does not connect

2004-09-17 Thread Sam Hobbs
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] IIRC the OP did have a successful test case when connecting from the mysql client. For whomever is interested, see my mess(ages) in the php internals. -- PHP General Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Sam Hobbs
Curt Zirzow [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] RTFM. mysql: This MySQL extension doesn't support full functionality of MySQL versions greater than 4.1.0. For that, use MySQLi. mysqli: The mysqli extension is designed to work with the version 4.1.3 or above of

Re: [PHP] Re: mysql_connect does not connect

2004-09-17 Thread Sam Hobbs
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I'm not familiar with MySQL under Windows, but I believe that there are different installers available from various sources. So saying Typical installation option doesn't really mean much. There is only one Windows

Re: [PHP] mysql_connect does not connect

2004-09-15 Thread Sam Hobbs
I appreciate your attempts to help, but you must understand that when attempts to help just cause time to be wasted, then it might be appropriate to not appreciate the help. Then when I try to explain that you are not helping, you make comments such as this, trying to blame me. If I am the

Re: [PHP] mysql_connect does not connect

2004-09-15 Thread Sam Hobbs
Greg Donald [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I lost track of who the original poster was, but anyway... Why not disconnect from the internet, turn off all the firewalls, and then see if it works. If it doesn't then post some error messages and code for what's being

Re: [PHP] Re: mysql_connect does not connect

2004-09-15 Thread Sam Hobbs
Andrew Kreps [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Tue, 14 Sep 2004 10:11:24 -0700, Sam Hobbs [EMAIL PROTECTED] wrote: Also, are the warning messages documented? As I asked in my original question, is 10061 an error code? 10061 is a generic winsock error for a timeout

Re: [PHP] Re: mysql_connect does not connect

2004-09-15 Thread Sam Hobbs
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] So now are you fully convinced it's your firewall that's the root of your problem? No, not really. At the moment I am assuming it is a bug in something somewhere. The versions of php and MySQL that I am using are not fully

Re: [PHP] mysql_connect does not connect

2004-09-15 Thread Sam Hobbs
Greg Donald [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Yeah, seeing how we don't have physical access to your system that's all you will get is guesses and suggestions. If you want definative answers, hire a consultant, bring them to your pc, and pay them to fix it. I have

Re: [PHP] mysql_connect does not connect

2004-09-15 Thread Sam Hobbs
Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Now that you have figured out, that it is possible its your firewall, which, many, and i think you claimed before was impossible, what exactly makes you sure i said anything invalid. It is my understanding that the

[PHP] Re: php/MYSQL remove duplicate records

2004-09-15 Thread Sam Hobbs
I do that a lot using Microsoft Access. I just finished on a project where I had to eliminate duplicates from each of three or more queries, a couple of which have three keys. However I am not much more experienced han you are; Microsoft Access generates SQL for us so I am not sure what the SQL

[PHP] Re: mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
Janbro [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi I connect to a MySQL 4.1 with the following String: if ($db_verbin=mysqli_connect($mysql_host,$mysql_user,$mysql_passw,$DB_n ame)) watch the i in mysqli_connect! I think I've read somewhere that you are required to use

[PHP] Re: mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
Janbro [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi I connect to a MySQL 4.1 with the following String: if ($db_verbin=mysqli_connect($mysql_host,$mysql_user,$mysql_passw,$DB_n ame)) watch the i in mysqli_connect! I think I've read somewhere that you are required to use

Re: [PHP] mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Windows XP Firewall, or any other firewall for that matter must be off. Jason Can someone else confirm that this is correct? For one thing, when I use MySQL directly outside of a web page, it works. The sample C program

Re: [PHP] mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
John Nichel [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I don't know anything about WindowsXP or it's 'firewall', but you _may_ have to open the port for which you have MySQL running on. I haven't followed this thread, but if MySQL, and your php enabled webserver are on the

Re: [PHP] mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Also, a google on the error returns hundreds of results.. http://www.google.ca/search?hl=enie=UTF-8q=Can%27t+connect+to+++MySQL+server+on+%27localhost%27+%2810061%29btnG=Searchmeta= Yes, I could have searched more

Re: [PHP] Re: mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
Andrew Kreps [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Tue, 14 Sep 2004 10:11:24 -0700, Sam Hobbs [EMAIL PROTECTED] wrote: Also, are the warning messages documented? As I asked in my original question, is 10061 an error code? 10061 is a generic winsock error for a timeout

Re: [PHP] mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Also, a google on the error returns hundreds of results.. http://www.google.ca/search?hl=enie=UTF-8q=Can%27t+connect+to+++MySQL+server+on+%27localhost%27+%2810061%29btnG=Searchmeta= One thing I did find in the

Re: [PHP] mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
. You dont have disable it, i should have been specifc i suppose, you must allow for the mysql port to be open. :) Whats for others to confirm, try it yourself and see if it works. Jason Sam Hobbs [EMAIL PROTECTED] wrote: Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL

Re: [PHP] mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
extension allows you to access the functionality provided by MySQL 4.1 and above. Then this page (http://www.php.net/manual/en/install.windows.extensions.php) about installing extension on windows should get you the rest of the way. Cheers Chris Sam Hobbs wrote: Jason Davidson [EMAIL

Re: [PHP] mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
John Nichel [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Jason Davidson wrote: The webpage of coarse, is not local, regardless of where its hosted, so a firewall will come into play when trying to connect. You dont have disable it, i should have been specifc i suppose, you must

Re: [PHP] mysql_connect does not connect

2004-09-14 Thread Sam Hobbs
And the relevant portion of that says external access, which is not applicable here. I do not see anything else on that page that is relevant. Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] ok, well, i just posted a link for you to check out, it gives insight on how

[PHP] mysql_connect does not connect

2004-09-13 Thread Sam Hobbs
I have: PHP Version 5.0.1 MySQL 5.0.1 Apache 2.0.48 Winows XP Pro SP2 MySQL is working fine as best as I can see; I have tried the various samples in the MySQL manual and I have executed the myTest sample provided with MySQL. They all work. However I can't get mysql_connect to

[PHP] get_class_vars

2004-09-11 Thread Sam Hobbs
Using the code shown below, I get nothing from get_class_vars but I do get very useful results from get_class_methods. I realize that this is how it is supposed to be, but it would be useful to be able to get the property members of the class. The reason I want to see the properties of

Re: [PHP] problem with front page files downloaded to dev machine OT

2004-09-05 Thread Sam Hobbs
John Nichel [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] How about middle posting? I have noticed that usually when people say things like don't top post, the reasons provided for not doing it apply equally as much to bottom-posting. What they really maen is that they want us to

[PHP] Re: PHP to replace javascript

2004-09-03 Thread Sam Hobbs
Jack Gates [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Javascript can open a separate and specifically sized window from a web page when a user clicks on a link that might reference a note or picture etc. Can this be done with PHP? If yes, will someone tell me where in the

Re: [PHP] Popup with recent IE updates

2004-09-03 Thread Sam Hobbs
Lester Caine [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] So don't know what goes wrong, but were running Apache 2.0.50, PHP5.0.0 on XP-SP1 and probably style sheets were going wrong. Switch back to W2k SP3 and all is fine (SP4 screws up various other network apps) so we stay

[PHP] Is a PECL a black whole?

2004-09-03 Thread Sam Hobbs
It took me a while to find an explanation of what a PECL is. I kept reading comments about things being moved to a PECL but I saw nothing about what is in a PECL or how to get anything out of a (the?) PECL. As far as I knew, there is a danger of all of PHP being in a PECL. I could not (and

Re: [PHP] Is a PECL a black whole?

2004-09-03 Thread Sam Hobbs
Curt Zirzow [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] * Thus wrote Sam Hobbs: It took me a while to find an explanation of what a PECL is. I kept reading comments about things being moved to a PECL but I saw nothing about what is in a PECL or how to get anything out

[PHP] Re: Copying HTML from a document to another document

2004-09-03 Thread Sam Hobbs
Sam Hobbs [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] foreach($ContentsDocument-childNodes as $Node) $Cell-appendChild($Node); If there is not a different solution that should be used instead, then can anyone confirm this should work? In other words, does this appear

Re: [PHP] Is a PECL a black whole? OT

2004-09-03 Thread Sam Hobbs
Jay Blanchard [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] [snip] black whole? [/snip] As in, Is PECL the wholeness of black? or Is PECL all that is black? *snicker* It just struck me funny, but everyone knew that you meant black hole. I already replied to you, Jay, offline

[PHP] importNode

2004-09-02 Thread Sam Hobbs
I am trying to copy the body portion of a HTML file for use in the current page. I am using PHP 5.0.1. I think the following is close but not close enough; nothing gets imported by importNode. I assume this would be easy if I knew the DOM well enough; if someone else is then I hope this would

Re: [PHP] Exporting Dbase to CSV

2004-09-02 Thread Sam Hobbs
Jay Blanchard [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What, exactly, do you mean? A CSV file that resembles a spreadsheet? A doc with CSV? The term CSV is very common; it means Comma Separated Values. It is the format that originally was (and is) used by the Basic language.

[PHP] Re: importNode

2004-09-02 Thread Sam Hobbs
Sam Hobbs [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I am trying to copy the body portion of a HTML file for use in the current page. I am using PHP 5.0.1. I think the following is close but not close enough; nothing gets imported by importNode. I assume this would be easy

Re: [PHP] Dynamic HTML Creation

2004-09-02 Thread Sam Hobbs
Ramil Sagum [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] given a template : - body User Information:p Name: {$name}br Address: {$address}br /body - and the php code: $smarty = new Smarty; $smarty-assign('name', 'george smith'); $smarty-assign('address',

[PHP] Copying HTML from a document to another document

2004-09-02 Thread Sam Hobbs
I need to copy HTML from a DOM document to another DOM document. The following is a simplified version of what I need to do. // Create HTML to be copied from $ContentsDocument = new DOMDocument(); $TextNode = $ContentsDocument-createTextNode(Text); $Paragraph =

[PHP] Re: Caching Database Information

2004-08-29 Thread Sam Hobbs
Paul Higgins [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Can I cache too much and therefore negate the advantages of caching? Performance can be a very complicated subject. There is a good chance that the data is already cached. I don't know the details of how PHP, your hadrware

[PHP] Re: Loading php_domxml.dll

2004-08-29 Thread Sam Hobbs
After doing a lot of searching and trying many things, I finally got it working; at least to the extent that the extension is loaded. I am not sure what all I did that is necessary, but the one thing that seems to have been necessary is to copy iconv.dll to my Windows\Systme32 directory. I

[PHP] Loading a html file using DOM XML

2004-08-29 Thread Sam Hobbs
Is it possible to load a HTML file using DOM XML? I tried loading a HTML file using: $Document = domxml_open_file(DynamicTable.html); if (!$Document) { echo Error loading the document\n; exit; } Yet that does not work; I get the error. -- PHP General Mailing

Re: [PHP] Loading a html file using DOM XML

2004-08-29 Thread Sam Hobbs
I don't want a XML document! I need a HTML document. Are you sure that that is the only possible explanation? I think not, and if not, then it is not accurate to say that that is the obvious answer. I did try changing the extension from html to XML and loading that directly into IE. I did get

Re: [PHP] Loading a html file using DOM XML

2004-08-29 Thread Sam Hobbs
, 29 Aug 2004 05:56:51 -0700, Sam Hobbs [EMAIL PROTECTED] wrote: I don't want a XML document! I need a HTML document. Are you sure that that is the only possible explanation? I think not, and if not, then it is not accurate to say that that is the obvious answer. I did try changing

Re: [PHP] Loading a html file using DOM XML

2004-08-29 Thread Sam Hobbs
Correction: the documentation is quite clear in saying that the DOM extension is the replacement for the DOM XML extension. So that is further indication that I should use DOM not DOM XML. Sam Hobbs [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] DOMDocument-loadHTMLFile is what I

Re: [PHP] Loading a html file using DOM XML

2004-08-29 Thread Sam Hobbs
Under domxml phpinfo shows the libxml Version as 20510 and it says that HTML Support is enabled. Is that what you mean? When I say: $Document = DOMDocument::loadHTMLFile(DynamicTable.html); print $Document-saveHTML(); It says: Fatal error: Call to undefined function: loadhtmlfile()

Re: [PHP] Loading a html file using DOM XML

2004-08-29 Thread Sam Hobbs
Perhaps it will be easier if I just install PHP 5. If I do, then I will need to also get the hsoting company that hosts my site to install it. Hopefully that won't be a problem. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Loading a html file using DOM XML

2004-08-29 Thread Sam Hobbs
Look at: http://simplesamples.info/Tests/PHPinfo.php That is not my local system but it is the information for the server that I will need to implement on. If anyone can give a hint of what I need to ask for to get DOM enabled there, then that will help. Or should I ask them to install PHP 5?

[PHP] Dynamic HTML Creation

2004-08-28 Thread Sam Hobbs
Is it possible to use the DOM to add (HTML) elements to a page at the time the page is being shown? The HTML and VBScript shown below is a simplified version of what I need to do but of course I need to do it in PHP. Since PHP is server-side (right?) perhaps it is not possible. HTML HEAD

Re: [PHP] Dynamic HTML Creation

2004-08-28 Thread Sam Hobbs
Justin Patrin [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Fri, 27 Aug 2004 23:17:29 -0700, Sam Hobbs [EMAIL PROTECTED] wrote: Is it possible to use the DOM to add (HTML) elements to a page at the time the page is being shown? The HTML and VBScript shown below is a simplified

Re: [PHP] Dynamic HTML Creation

2004-08-28 Thread Sam Hobbs
Ramil Sagum [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Yes, it is possible. And you are right, PHP is a server side language. In addition to PHP, use a client-side scripting language (like JavaScript). JavaScript also has functions for accessing the DOM (createElement and

Re: [PHP] Dynamic HTML Creation

2004-08-28 Thread Sam Hobbs
Read the original question again; it is quite clear about the relevance to PHP. Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] its possible to add HTML elements with DOM, im not sure what it has to do with php though? -- PHP General Mailing List

[PHP] Loading php_domxml.dll

2004-08-28 Thread Sam Hobbs
I am using PHP 4.3.4 with Windows XP and Apache 2. I can't get php_domxml.dll loaded. I have searched for answers and tried many things. The file: S:\Software\php-4.3.4-Win32\extensions\php_domxml.dll exists. In my php.ini, I have tried setting extension_dir to many values, including:

Re: [PHP] Dynamic HTML Creation

2004-08-28 Thread Sam Hobbs
Ramil Sagum [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Ah. You should have said this in your first mail (which was confusing). It now becomes clear. I think what you are looking for is a template engine, like smarty http://smarty.php.net/ If Smarty is a good solution that