[Troys]

Hello all thanks for reading hopefully this problem can be fixed i made this php mysql script for account registration and for some reason its not working
it keeps saying
"Fatal error: Call to undefined function mysql_connect() in C:\Pedregon's 2.4.3 Repack\Server2\htdocs\Insert.php on line 2"

Here is the code

<?php
$con = mysql_connect("localhost","root","lichking") or Die ('Could not connect: ' . mysql_error());
if ($con)

mysql_select_db("logon", $con);

$sql="INSERT INTO accounts (login,password,gm,email,flags)
VALUES
('login','password','0','email','8')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

($announce = "Account Creation Successfull!");

mysql_close($con);

?>

If some1 can point out what i did wrong and gave me a solution to my problem that would be great !!

[Tanax]

Your error says that the function isn't defined.

Meaning:

1. You've made a little error, such as for example forgetting a ' or a ;
2. Your PHP server doesn't support mysql
3. You don't have a PHP server on your webhotel/localhost

[Troys]

yea it says the Mysql_connect wont work but yet all sites i go to says thats how you imput it to connect to mysql db

[dejavu11]

Originally Posted by Troys

yea it says the Mysql_connect wont work but yet all sites i go to says thats how you imput it to connect to mysql db

PHP doesn't come with built in MySQL support. Odds are you don't have MySQL enabled in your php.ini. Google the error: "Call to undefined function mysql_connect" and you'll find all sorts of pages on how to fix it.

[Tanax]

Originally Posted by Troys

yea it says the Mysql_connect wont work but yet all sites i go to says thats how you imput it to connect to mysql db

Yes, mysql_connect is indeed the php function used to connect to a mysql database.

Your script probably AINT wrong. But the server is just not supporting it.

Try this server, it's free, and is probably one of the best I've found yet(that is free that is). And guess what? It supports databases

[Only registered and activated users can see links. ]

[Troys]

Thanks for the link and for the help i appreciate it !

Originally Posted by dejavu11

PHP doesn't come with built in MySQL support. Odds are you don't have MySQL enabled in your php.ini. Google the error: "Call to undefined function mysql_connect" and you'll find all sorts of pages on how to fix it.

Its enabled and it works fine with other scrips that connect

[insanesk8123]

try putting an @ in front of it like this:
$con = @mysql_connect("localhost","root","lichking")

[dejavu11]

Originally Posted by insanesk8123

try putting an @ in front of it like this:
= @mysql_connect("localhost","root","lichking")

That will supress the error from being shown but it's not going to fix the problem.

[Troys]

Originally Posted by insanesk8123

try putting an @ in front of it like this:
= @mysql_connect("localhost","root","lichking")

Hey insane long time no see =]

and as for the code still not working i have edited it so many times to fix it im trying the hosting company see if that will fix it.
Here is all the code im using for the account creation table .

This is what im trying to make

And the code for this is

 

<form id="contactForm" name="form2" method="post" action="insert.php">
    

<h2>Account Register</h2><br class="spacer" />
      <label>Username:</label>
      <br class="spacer" />
        <input type="text" name="textfield2" />
        <label>Password:</label><br class="spacer" />
        <input type="text" name="textfield2" />
        <label>Re-type Password:</label>
        <br class="spacer" />
        <input type="text" name="textfield2" />
        <label>Email :</label><br class="spacer" />
            <input type="text" name="textfield2" />
         
      <input type="image" class="submit" src="images/submit_bg.gif" title="submit" />   
   </form>

[dejavu11]

Originally Posted by Troys

Thanks for the link and for the help i appreciate it !



Its enabled and it works fine with other scrips that connect

You mentioned that you were going to contact "the host" but everything seems to say you are hosting this locally.

= mysql_connect("localhost","root","lichking")

I don't know of any hosts that would give you MySQL root access

C:Pedregon's 2.4.3 RepackServer2htdocsInsert.php

Odds are they also wouldn't be having an emulation server running on their webserver.

[Troys]

I fixed that all its being hosted on a free server im trying to see if it works finally /cross fingers

[dejavu11]

Originally Posted by Troys

I fixed that all its being hosted on a free server im trying to see if it works finally /cross fingers

What was the problem in the end?

[Troys]

well now after i click submit its saying 404 error >.<
i dont know if its trying to go to insert.php or what all insert is is the php code for the registration its not supposed to be a page =/

ugh this is the hardest most fustrating code i have ever done ..and also dejavu thanks a ton for helping me

[dejavu11]

Hey I'm just happy to see action in the PHP section. 404 = page not found. If you're using the code you have above it is trying to go to insert.php.

<form id="contactForm" name="form2" method="post" action="insert.php">

Do you have an insert.php in the same directory?

[Troys]

yep its all hosted in 1 place