Adding Column And Insert Data MYSQL

[morrism35]

I have imported my database from my localserver into my instructors web server. I want to add a column called pageLink and insert data. I'm getting a "Error: INSERT INTO artist_table (pageLink) VALUES ('jkljk')

Unknown column 'pageLink' in 'field list'". As a test I tested my code on other columns and was successfuly able to insert data. My code to add the pageLink column does say successfull but like stated inserting data is saying that pageLink does not exist. Below is my code to add the pageLink column and to insert the pageLink column

 

 

Adding a column code:

$r="ALTER TABLE artist_table

ADD COLUMN (pageLink VARCHAR(200))";

$QueryResult=@mysql_query($r, $conn);

if($QueryResult===FALSE)

echo"Unable to execute the query".mysql_errno($conn).mysql_error($conn);

else 

echo"Success created"; 

 mysqli_close($conn);

 

 

 

Inserting data into that column:

$sql = "INSERT INTO artist_table (pageLink) 

VALUES ('jkljk')";

if ($conn->query($sql) === TRUE) {

    echo "New record created successfully";

} else {

    echo "Error: " . $sql . "<br>" . $conn->error;

}

$conn->close()

[Barand]

you cannot mix mysql and mysqli.

 

 

$QueryResult=@mysql_query($r, $conn);

[mac_gyver]

your alter table query is using the php mysql function to run the query. you are however apparently using either the mysqli or the PDO classes for your connection and the rest of your code.

 

as was stated in one of your previous threads, you cannot mix the different php database functions together for a single connection.

 

if your mysql based statements appear to be running without producing database errors, it's because most of the all-in-one xAMP packages set up default mysql database credentials that allow mysql statements to make a database connection if there isn't already one.

 

also, please do NOT suppress any errors in your code. remove any @ error suppressors and make sure that php's error_reporting is set to E_ALL and display_errors is set to ON in the php.ini on your development system. if you are tyring to learn php or learn anything new in php, developing php code, or trying to debug problems in php code, you want ALL THE HELP YOU CAN GET from php. you don't want to hide any of the php errors.

Edited December 5, 2015 by mac_gyver

[morrism35]

I've changed it to mysqli_query, but it didn't make any difference. It is only with this column that it becomes a problem. I'm able to add data with the columns that are already there.

[morrism35]

ok I only changed mysqli_query in my insertData script, i'm assuming it needs to be also in my addColumns script.

[morrism35]

It worked thanks