[RESOLVED] Connecting to IP address?

dapuxter

I've recently set up a new MySQL server on a machine here at work and don't yet have a domain name assigned so I'm just using the ip address. For my connect statement, would the syntax be:

$con = mysql_connect("xx.xx.xx.xx:3308", "user", "pass");

I've tried that and it doesn't seem to be working. Port 3308 is the port I assigned to the server during setup. I can connect to the server remotely using that information in MySQL Command Center but it doesn't seem to be working for my form.

Also, once I do get a domain name set up, will php automatically direct any mysql queries to the mysql server at that domain or do I need to set up port forwarding or something?

Edit: Oh, forgot to add, all of my code works fine when ran on phpnet.us but not when ran on my local server, which is what leads me to believe its a problem with the connection statement.

dapuxter

Just in case I'm missing something, and it will probably be asked, here's my code in its entirety:

<html>
<head>
<meta http-equiv="refresh" content="5;URL=http://xx.xx.xx.xx/outagelog.php">
</head>
<body>
<?php

$con = mysql_connect("xx.xx.xx.xx:3308", "user", "pass");
if (!con)
   {
   die('Could not connect: '. mysql_error());
   }

if(get_magic_quotes_gpc()) {
            $outagedate = stripslashes($_POST['date']);
            $outagetime = stripslashes($_POST['time']);
            $outagetype = striplslashes($_POST['outagetype']);
            $mtcplant = striplslashes($_POST['mtcplant']);
            $outagecity = striplslashes($_POST['city']);
            $outagenode = striplslashes($_POST['node']);
            $services = striplslashes($_POST['services']);
            $custcount = striplslashes($_POST['custcount']);
            $cbs = striplslashes($_POST['cbs']);
            $impact = striplslashes($_POST['impact']);
            $outagedesc = striplslashes($_POST['desc']);

    } else {

        $outagedate = $_POST['date'];
        $outagetime = $_POST['time'];
        $outagetype = $_POST['outagetype'];
        $mtcplant = $_POST['mtcplant'];
        $outagecity = $_POST['city'];
        $outagenode = $_POST['node'];
        $services = $_POST['services'];
        $custcount = $_POST['custcount'];
        $cbs = $_POST['cbs'];
        $impact = $_POST['impact'];
        $outagedesc = $_POST['desc'];

    }

mysql_select_db("outage", $con);

$sql = sprintf("INSERT INTO `outage`.`outage` (`date`, `time`, `outagetype`, `mtcplant`, `city`, `node`, `services`, `custcount`, `cbs`, `impact`, `desc`) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",
mysql_real_escape_string($outagedate, $con),
mysql_real_escape_string($outagetime, $con),
mysql_real_escape_string($outagetype, $con),
mysql_real_escape_string($mtcplant, $con),
mysql_real_escape_string($outagecity, $con),
mysql_real_escape_string($outagenode, $con),
mysql_real_escape_string($services, $con),
mysql_real_escape_string($custcount, $con),
mysql_real_escape_string($cbs, $con),
mysql_real_escape_string($impact, $con),
mysql_real_escape_string($outagedesc, $con));


mysql_query($sql, $con);

if (mysql_affected_rows($con) > 0) {
            echo "Outage Inserted\n";
        }
     else {
    echo "Fill the form properly\n";
}

mysql_close($con)

?>
</body>
</html>

bradgrafelman

I see that you check mysql_error() if it does fail... can you give us the outputted error message?

mark_kccs

Hi dapuxter

Not sure if i'm correct here but instead of the ip address why not use "localhost"

dapuxter

I do not get a fail message from the code, all I get is a blank screen and then it forwards me to the other page because of the auto refresh thing.

And I can't use localhost because I'm not actually working on the server. I connect locally from my workstation to the server, and this will eventually be a shared application with 3-4 people so it has to work from any connection.

dapuxter

I think it was actually a configuration problem. I played around with php.ini on the server and I'm able to get some results now. However, its telling me : Call to undefined function striplslashes(). I think I might need to include another library or something to make that function work. Thanks for the help though guys, and if any of you have ran into this before and know the solution, please clue me in. Will save me a lot of struggling. 😃

laserlight

Call to undefined function striplslashes().

Here's a simpler reason: it is a typographical error. [man]stripslashes/man is what you are looking for.

dapuxter

Yeah...just figured that out. Go go fat fingers! Thanks for the help though folks!