[headboy337]

I have my site uploaded and connected. It won't show because of this script

<?
$linkID = mysql_connect("localhost","fmsdesig_Twisted", "97026574")
        or exit("Could not connect");
    
mysql_select_db ("fmsdesig_demo");

?>

Is there something wrong with this script? It was in my dbase.php and I sought help Could someone help me?

I changed everything in blue, Is there something wrong with the black?

[huzi8t9]

EDIT

Quote

If you're using short open tags, ensure they're enabled in your php.ini, or use <?php instead of <? just to be sure.

It all looks correct, by syntax. Although I'd verify the login information; I know you changed it to seek help and didn't give away any valuables, but still check 'em. Also, is the page dying when you try to connect, or are you just unable to make any queries?

It's good practise to also verify that your table is being selected.

<?php
$link = mysql_connect("HOST", "USERNAME", "PASSWORD") or die("Unable to connect. MySQL said: <b>". mysql_error() ."</b>");
$select = mysql_select_db("DATABASE") or die("Unable to select database. MySQL said: <b>". mysql_error() ."</b>");
?>

Hope this helps

~huzi

This post has been edited by huzi8t9: 26 November 2011 - 05:17 AM

[headboy337]

The page is dying, and when I put in that code you gave me, it went to my domain went to the serverhost page. www.xrayplay.com

[huzi8t9]

headboy337, on 26 November 2011 - 12:20 PM, said:

The page is dying, and when I put in that code you gave me, it went to my domain went to the serverhost page. www.xrayplay.com

Sorry, could you try and word that differently please. I don't understand.

I get that the page is dying. However, I don't get the rest. Is it that your domain is redirecting you to your homepage/index page?

~huzi

[headboy337]

no, the page looks right, but in the address bar, my address shows correctly

THe page looks blank, but the address bar shows correctly

(disregard the last post)

[huzi8t9]

headboy337, on 26 November 2011 - 12:25 PM, said:

no, the page looks right, but in the address bar, my address shows correctly

THe page looks blank, but the address bar shows correctly

(disregard the last post)

It'd appear that your code is being killed before the query then. Is this MySQL connection being queried at the the very top of the page, or..?

~huzi

[headboy337]

for the host section of that script should I put "localhost"

no its is not

I upload my sql file correctly with everything in place, but that piece of script that I posted is incorrect. I even had techs from the server company help me with my db name and password placements. They told me to put local host for the server name

[huzi8t9]

headboy337, on 26 November 2011 - 12:27 PM, said:

for the host section of that script should I put "localhost"

That's commonly used, but I'd verify that just to be sure. Login to your cPanel, and navigate to phpMyAdmin. There you should see your connection details. If not, navigate to something along the lines of "phpMyAdmin Users"

~huzi

[headboy337]

Server: Localhost via UNIX socket
Server version: 5.0.77
Protocol version: 10
User: xrayp_play@localhost
MySQL charset: UTF-8 Unicode

[huzi8t9]

headboy337, on 26 November 2011 - 12:33 PM, said:

Server: Localhost via UNIX socket
Server version: 5.0.77
Protocol version: 10
User: xrayp_play@localhost
MySQL charset: UTF-8 Unicode

then I should assume your connection string would be

<?php
$link = @mysql_connect("localhost", "xrayp_play", "PASSWORD");
$select = @mysql_select_db("DATABASE");
if ( !$link )
{
     die("An error occured.<br />\nMySQL said [". mysql_errno() ."] ". mysql_error();
}
else
{
     if ( !$select )
     {
          die("An error occured.<br />\nMySQL said [". mysql_errno() ."] ". mysql_error();
     }
     else
     {
          die("MySQL connected and database selected. Good work ;)/>");
     }
}
?>

Give that a try. It should die either way, but at least you'll get a success of failure message.

~huzi

[headboy337]

I didn't, maybe it's a problem somewhere else in the script?

[huzi8t9]

headboy337, on 26 November 2011 - 12:48 PM, said:

I didn't, maybe it's a problem somewhere else in the script?

That's all I can assume Personally, I keep my functions and headers at the top of the page, then if anything goes wrong, I'll always know. Of course, headers must be outputted before any HTML, else you'll receive an error, which I assume you're already aware of

~huzi

[headboy337]

It brought my page up, but the page looked funny. www.xrayplay.com

THe PHP coding is on the page. So, I know the source to my problem is these couple of lines of code, am I correct?

[huzi8t9]

headboy337, on 26 November 2011 - 01:05 PM, said:

It brought my page up, but the page looked funny. www.xrayplay.com

I got redirected to "index_ie.php" (using Google Chrome) with an error.

Quote

The website encountered an error while retrieving http://xrayplay.com/index_ie.php. It may be down for maintenance or configured incorrectly.

This looks like it could possibly be a HTACCESS error.

~huzi

[headboy337]

htcaccess error?