PHP connection to MySQL database not connecting?

Question

I've just started learning php and I'm having trouble finding the problem when I get it to connect to the database and run an 'INSERT' query. I think the problem is in my connection.php file.

insert.php:

<?PHP
echo "into";
include("connection.php");
echo "connected";
$table = blog;
$sql = "INSERT INTO $table SET
Title = '$_POST[title]',
Description = '$_POST[description]',
Content = '$_POST[content]'";
$query = @mysql_query($sql);

echo "complete";

echo $_POST[title];
echo $_POST[description];
echo $_POST[content]; 
?>

connection.php:

<?php
echo "connection file reached";
$conn = mysql_connect(localhost, user, pass);
mysql_select_db(test, $conn);
echo "connected";
?>

Any advice on my code, or how I could solve this problem would be much appreciated.

EDIT: I'm thinking that it never gets to the connection.php file because it shows the "into" at the top of insert.php but not the "connection file reached" at the top of connection.php. Is that call correct to that file?

Thanks

Its only on a local server so that shouldn't be too much of a problem will it? — Airglow
– Airglow, Commented Jul 5, 2014 at 13:58
set error_reporting(E_ALL); and ini_set('display_errors', 1); — andrew
– andrew, Commented Jul 5, 2014 at 13:59
get the error <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); ?> — Steinbock
– Steinbock, Commented Jul 5, 2014 at 13:59

andrew · Accepted Answer · 2014-07-05 14:12:13Z

1

Readup on php constants, variables and strings!

define('foo','bar'); // foo == 'bar';
$foo = 'bar'; // $foo == 'bar'

Please use mysqli_* as mysql_* is depreciated.

$conn = mysql_connect(localhost, user, pass);

probably should be

$conn = mysql_connect('localhost', 'user', 'pass');

answered Jul 5, 2014 at 14:12

andrew

9,6039 gold badges36 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Airglow Over a year ago

That worked, thanks. It went through and said connected etc but the db is still empty, any ideas on this?

andrew Over a year ago

I would install phpmyadmin on your setup xamp or whatever your using, and start by copying in the result of echo $sql it will help you debug your query

Airglow Over a year ago

i have Sequel Pro running and can see the database

Hujjat Khan · Accepted Answer · 2014-07-05 14:25:48Z

0

you have written

@mysql_query($sql)

as well as a lot other problem it's structure is also wrong the problem might be from version of your language as recommendation of php you should not use mysql any more use mysqli or PDO

answered Jul 5, 2014 at 14:25

Hujjat Khan

113 bronze badges

Collectives™ on Stack Overflow

PHP connection to MySQL database not connecting?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related