Jump to content

bluekid239

Members
  • Content Count

    8
  • Joined

  • Last visited

Community Reputation

1 Neutral

About bluekid239

  • Rank
    Newbie
  1. *sigh* Once again I fail to see the obvious. (if I could find a headsmack emoticon I would use it) I guess I didn't fully read the intro at the top of the php.ini file. I figured out my problem, though:Problem A: php_mysql.dll was disabled.Problem B: extension_dir was not set, so it could not find any of the extensions.SOLUTION: I rid the two statements of their ; prefix.Now it works, and I am satisfied. Thank you for helping me out, I greatly appreciate your time!
  2. I have MySQL installed and set up (I can run the command-line client perfectly fine and do everything with it). In fact, I already have a database and a couple of tables set up and ready to be read/written to by my PHP script. I'm pretty sure I have php_mysql.dll enabled. Here is the list of extensions, exactly as it appears in php.ini:;extension=php_bz2.dll;extension=php_curl.dll;extension=php_dba.dll;extension=php_exif.dll;extension=php_fileinfo.dll;extension=php_gd2.dll;extension=php_gettext.dll;extension=php_gmp.dll;extension=php_intl.dll;extension=php_imap.dll;extension=php_interbase.dll;extension=php_ldap.dll;extension=php_mbstring.dll;extension=php_ming.dll;extension=php_mssql.dll;extension=php_mysql.dll;extension=php_mysqli.dll;extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client;extension=php_oci8_11g.dll ; Use with Oracle 11g Instant Client;extension=php_openssl.dll;extension=php_pdo_firebird.dll;extension=php_pdo_mssql.dll;extension=php_pdo_mysql.dll;extension=php_pdo_oci.dll;extension=php_pdo_odbc.dll;extension=php_pdo_pgsql.dll;extension=php_pdo_sqlite.dll;extension=php_pgsql.dll;extension=php_phar.dll;extension=php_pspell.dll;extension=php_shmop.dll;extension=php_snmp.dll;extension=php_soap.dll;extension=php_sockets.dll;extension=php_sqlite.dll;extension=php_sqlite3.dll;extension=php_sybase_ct.dll;extension=php_tidy.dll;extension=php_xmlrpc.dll;extension=php_xsl.dll;extension=php_zip.dll
  3. Does it make a difference that I use IIS and not apache? I'm still not sure what phpmyadmin is.
  4. Well, I turned off Friendly Error Messages in IE, but it showed me the same webpage it did before I started getting the HTTP 500 page. I went to the php.ini file and modified these settings to the values shown:error_reporting = E_ALL | E_STRICTdisplay_errors = Ondisplay_startup_errors = Onhtml_errors = OnI also modified the file again to include an echo statement before the connect statement, and it worked perfectly fine. However, the echo statement I placed just after the connect statement didn't happen. I found the error logs, and I'm trying to make sense of them now. This is the most recent line I found (with the descriptions added for clarity):DATE: 2010-03-19TIME: 17:47:54S-IP: ::1CS-METHOD: GETCS-URI-STEM: /TestPHP/testSQL.php -CS-URI-QUERY: 80 -S-PORT: ::1CS-USERNAME C-IP CS(User-Agent): Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729;+Media+Center+PC+6.0)SC-STATUS: 500SC-SUBSTATUS: 0SC-WIN32-STATUS: 0TIME-TAKEN: 10or exactly as it appeared in the log:2010-03-19 17:47:54 ::1 GET /TestPHP/testSQL.php - 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729;+Media+Center+PC+6.0) 500 0 0 10The new line in there was an automatic thing due to the length of the phrase. I can't make sense of it myself.EDIT:: I finally managed to squeeze an error report out of the PHP server. This is the error I received:PHP Fatal error: Call to undefined function mysql_connect() in C:\inetpub\wwwroot\TestPHP\testSQL.php on line 9 I note that in making sure functionality with MySQL was secure, I found that I was missing what appears to me as a key file: libmysql.dll.I can't find it anywhere in C:\PHP. The manual says it comes in the Windows version, but I'm missing it. I downloaded the zip file as opposed to the downloader and installed manually. Would that make a difference?
  5. For some odd reason beyond my knowledge, my PHP script will not connect to the MySQL server, and then stops running all-together. This is my code: <html> <head> <title>Testing MySQL Connection</title> </head> <body> <h1>Hello World!</h1> <?php $dat = mysql_connect("localhost:3306","root","******"); if(!$dat){ die("Could not connect to MySQL: ".mysql_error()); } else{ echo "Connected successfully!"; } mysql_close($dat); ?> </body></html> When I load this (by going to http://localhost/TestPHP/testSQL.php) , the following is in the source code of the return html: <html> <head> <title>Testing MySQL Connection</title> </head> <body> <h1>Hello World!</h1> Could the PHP script be timing out, or is there some odd connection problem? The max_execution_time setting in php.ini is at 30 seconds, and it doesn't take very long to load (a few seconds). FastCGI allows it to run much longer (15 minutes) without communicating. I determined that "servername" was "localhost:3306" because that was the port I set it on, and when I queried the server with "select user()" it returned "root@localhost", which was how I determined "username" as well. Am I misunderstanding something? Can someone point me in the right direction?*EDIT* Now that I try again, I'm not getting ANY HTML returns. I get an HTTP 500 Internal Server Error. Here's the description:This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.*Note* the password field in the source code is starred to protect my password.
  6. Previously I had this in the ASP forum, but now I realize my problem lies with IIS and not ASP. I have IIS 7.5 installed on a Windows 7 Home Premium OS. I open the IIS Manager, and it says that my server is running. However, when I try to connect to http://localhost/, Internet Explorer (version 8.0) gives me an HTTP 404 Not Found error page. Here's the description it gives me:This error (HTTP 404 Not Found) means that Internet Explorer was able to connect to the website, but the page you wanted was not found. It's possible that the webpage is temporarily unavailable. Alternatively, the website might have changed or removed the webpage.I also attempted to connect to a test ASP file I made, along with the default index.html file in wwwroot (via http://localhost/test.asp and http://localhost/index.html) but neither of those work either!Is there something wrong with the settings on IIS? Does anyone know what I've done wrong? It worked last weekend (3/6-3/7)!*a-hem* Pardon my rantings. I just realized I screwed with the bindings of the webpage. It was bound to a certain IP Address that was no longer associated with my computer, which meant I could not connect to it any longer. If a moderator could just erase this post and my previous post (here) so that they do not clog the forums, I'd appreciate it. I feel really stupid now.
  7. I've tried connecting to http://localhost/, but it give me an HTTP 404 Not Found error page. Also, I just checked it again AND checked IIS, and IIS says the server is running. Thank you for pointing out the flaw in double-clicking on the ASP file, I'll keep that in mind. Here's the exact description IE gave me of the 404 error.This error (HTTP 404 Not Found) means that Internet Explorer was able to connect to the website, but the page you wanted was not found. It's possible that the webpage is temporarily unavailable. Alternatively, the website might have changed or removed the webpageEDIT: I realized my problem lies with IIS, not ASP, so I moved my question here.
  8. bluekid239

    ASP not working?

    Hello, I'm relatively new with ASP, and I'm having trouble. Last weekend, I was learning ASP and doing rather well. I had an HTML page with a form and an ASP file to process it. It worked fine and dandy. Now I go back to check it again today (and yesterday), and all of a sudden it doesn't work any more! Everytime I click the submit button, Internet Explorer tries to download the ASP file, unless the HTML page is viewed in a frame and scripting is allowed. In that case it just shows the HTML parts of the ASP and doesn't do anything between the <% %> tags. I've even tried the simplist "Hello World!" ASP I can find, and it doesn't work! What am I doing wrong? I'm currently using IIS version 7.5 on Windows 7 OS. Oh, and also, I added a test file called test.asp to my wwwroot folder, and typed this into my browser: "http://localhost/test.asp" and got an HTTP 404 Not Found error page instead. The code is as follows: (VBScript is the default scripting language) <html> <head> </head> <body> This is a test:<br/> <%response.write("hello world!")%> </body></html>
×
×
  • Create New...