JQuery post to my PHP file to read its variable

[vonKristoff]

Hi there,

Im new here ..

I have been trying for hours to just pass a variable from my HTML to a JQuery post which connects to my PHP file, reading the variable sent in the POST, and updating my database.

 

Basically - my PHP is not getting the variable im sending to it - though it is definitely going as my HTML says so.

 

my HTML click function says:

$.post("setDB.php",{id:$('#myTxt').val()});

my PHP - connects to its DB with its new MySQLi set to $mysqli - says:

 

$id = $_POST['id'];

$query = "INSERT videos SET src = $id";

$result = $mysqli->query($query) or die($mysqli_error($mysqli));

 

ok - but no way is anything working ...... I have no hair left - if anyone else has some spare - please be my guest

[gristoi]

<?php
$query = "INSERT INTO videos (`src`) VALUES ('$id')";

[cybernet]

<?php
$query = "INSERT INTO videos (`src`) VALUES ('$id')";

 

your signature fits the reply )

sorry for offtopic but i had to say it

[Andy-H]

Your MySQLi INSERT query is formatted as an update query, change it from

$id = $_POST['id'];
$query = "INSERT videos SET src = $id";
$result = $mysqli->query($query) or die($mysqli_error($mysqli));

to

$id = (int)$_POST['id'];
$query = "INSERT INTO videos ( $id )";
$result = $mysqli->query($query) or die($mysqli_error($mysqli));

or

$id = (int)$_POST['id'];
$query = "INSERT INTO videos ( id ) VALUES ( $id )";
$result = $mysqli->query($query) or die($mysqli_error($mysqli));