php error

[lakijayawardana]

$vehicle = $_POST['vehicle'];
$owner = $_POST['owner'];

$sql = "INSERT INTO vehicle('vehicle','owner') VALUES ('$vehicle','$owner')";


Warning: mysqli_query() expects parameter 1 to be mysqli, object given in (path)

Me error eka enne ai machanla.

db connection eka success.
okkoma hari me error eka thamai awula.

 

[dildude]

php nodanimi.
but variables walata single quotes dala pass kalama ewa string wenne nadda ?
+ dala concat karanna wei mama hithanne

 

[shashikaxp]

echo karala balapan $vehicle ekata value eka set welada kiyala ? nathnam $_POST["vehicle"] dapan double quotation ""

 

[lahiru1223]

mysqli_query() nathuwa mysql_query() user karala balanda... naththam full query eka danda balanda

 

[Identity]

Sql statement eka print karala ena query eka phpmyadmin ekata dala balanna

 

[badsectorguy]

can U show the code up to execution part (to mysqli_query)

 

[sajith.xp.pk]

$sql = "INSERT INTO vehicle(*vehicle*,*owner*) VALUES ('{$vehicle}','{$owner}')";

Meke * wenuwata keyboard eke left side 1 ilakkamata left side eken thoyena muhudu rella wage eka gawa thiyena podi udu koma daala balapan. Phone eke e simbol eka nehe.

 

[masterit]

$sql = "INSERT INTO vehicle('vehicle','owner') VALUES ('$vehicle','$owner')";

$sql = "INSERT INTO vehicle('vehicle','owner') VALUES ($vehicle,$owner)";

me widihata daala balanna

 

[සුදු පුතා]

meka balahan.. ------------

mysqli query function ekedi connection variable ekai sql ekai dekama yawanna ona.
menna mehema ---

mysqli_query($con, $query);

$con = me connection eka variable ekakata aran.
$query = me sql statement eka.

 

[sajith.xp.pk]

Full code eka daapan. With connection code. Hadala dennam

 

[kolavari]

mysqli_query() wala first parameter eka wenna one connection eka

 

[~Hades~]

meka balahan.. ------------

mysqli query function ekedi connection variable ekai sql ekai dekama yawanna ona.
menna mehema ---

mysqli_query($con, $query);

$con = me connection eka variable ekakata aran.
$query = me sql statement eka.

 

[nuwan91]

$sql = "INSERT INTO vehicle(vehicle,owner) VALUES ('".$vehicle."','".$owner."')";

query eka me widiyata gahapan

 

[kalhara96]

mysqli_query($connection,$query);

 

[lakijayawardana]

php nodanimi.
but variables walata single quotes dala pass kalama ewa string wenne nadda ?
+ dala concat karanna wei mama hithanne

bump

echo karala balapan $vehicle ekata value eka set welada kiyala ? nathnam $_POST["vehicle"] dapan double quotation ""

mysqli_query() nathuwa mysql_query() user karala balanda... naththam full query eka danda balanda

Sql statement eka print karala ena query eka phpmyadmin ekata dala balanna

can U show the code up to execution part (to mysqli_query)

$sql = "INSERT INTO vehicle(*vehicle*,*owner*) VALUES ('{$vehicle}','{$owner}')";

Meke * wenuwata keyboard eke left side 1 ilakkamata left side eken thoyena muhudu rella wage eka gawa thiyena podi udu koma daala balapan. Phone eke e simbol eka nehe.

bump

$sql = "INSERT INTO vehicle('vehicle','owner') VALUES ('$vehicle','$owner')";

$sql = "INSERT INTO vehicle('vehicle','owner') VALUES ($vehicle,$owner)";

me widihata daala balanna

meka balahan.. ------------

mysqli query function ekedi connection variable ekai sql ekai dekama yawanna ona.
menna mehema ---

mysqli_query($con, $query);

$con = me connection eka variable ekakata aran.
$query = me sql statement eka.

Full code eka daapan. With connection code. Hadala dennam

bp

mysqli_query() wala first parameter eka wenna one connection eka

$sql = "INSERT INTO vehicle(vehicle,owner) VALUES ('".$vehicle."','".$owner."')";

query eka me widiyata gahapan

mysqli_query($connection,$query);

thanks okkotama.


​

 

[lakijayawardana]

echo karala balapan $vehicle ekata value eka set welada kiyala ? nathnam $_POST["vehicle"] dapan double quotation ""

eka enwa machan. double quote anan manan hama reddama kara machan barima thana thamai ahuwe.

mysqli_query() nathuwa mysql_query() user karala balanda... naththam full query eka danda balanda

$sql = "INSERT INTO vehicle('vehicle','owner') VALUES ('$vehicle','$owner')";

$sql = "INSERT INTO vehicle('vehicle','owner') VALUES ($vehicle,$owner)";

me widihata daala balanna

meka balahan.. ------------

mysqli query function ekedi connection variable ekai sql ekai dekama yawanna ona.
menna mehema ---

mysqli_query($con, $query);

$con = me connection eka variable ekakata aran.
$query = me sql statement eka.

$add = $_POST['owner'];
$vehicle = $_POST['vehicle'];

mysqli_query($db,"INSERT INTO vehicle (vehicle,owner)
VALUES ('$vehicle','$owner');

mysqli_close($db);

conn.php

<?php

session_start();

if(isset($_SESSION['user_id']) && isset($_SESSION['priv']))
{
$dsn = 'mysql:host=localhost; dbname=test';
$u_name = 'root';
$pwd = '';

}
if(!isset($connection)) {
try{
$db = new PDO($dsn,$u_name,$pwd);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e){
echo "connection failed . Reason = ".$e->getMessage();
}
}
else{
header("Location:index.php");
}
?>


db para eka dammath e awula mai.
Warning: mysqli_query() expects parameter 1 to be mysqli, object given in

mysqli_query() wala first parameter eka wenna one connection eka

 

[kolavari]

$add = $_POST['owner'];
$vehicle = $_POST['vehicle'];

mysqli_query($db,"INSERT INTO vehicle (vehicle,owner)
VALUES ('$vehicle','$owner');

mysqli_close($db);

conn.php

<?php

session_start();

if(isset($_SESSION['user_id']) && isset($_SESSION['priv']))
{
$dsn = 'mysql:host=localhost; dbname=test';
$u_name = 'root';
$pwd = '';

}
if(!isset($connection)) {
try{
$db = new PDO($dsn,$u_name,$pwd);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e){
echo "connection failed . Reason = ".$e->getMessage();
}
}
else{
header("Location:index.php");
}
?>


db para eka dammath e awula mai.
Warning: mysqli_query() expects parameter 1 to be mysqli, object given in

මචන් මෙතන $db කියන්නේ mysqli කනෙක්ෂන් එකක් නෙමෙයි නේ... PDO ඔබ්ජෙක්ට් එකක් නේ...ඔය දෙක දෙකක් මචන්... PDO භාවිත කරනවානම් එකම පාවිච්චි කරන්න...mysqli භාවිත කරනවානම් එක භාවිත කරන්න...ඒ දෙක මිශ්‍ර කරන්න බැහැ...

mysqli_query() කියන එකේ පලවෙනි පැරාමීටර් එකට දෙන්න ඕනේ mysqli_ කනෙක්ෂන් එකක්....

$db = mysqli_connect($host, $user, $password, $db_name);

ඔයා procedural විදිහට කරලා තියෙන නිසා ඔහොම දැම්මේ...ඕකම OO විදිහටත් කරන්න පුළුවන්...ඔතන conn.php එකේ PDO කොටස අයින් කරලා මේක දාන්න...එතකොට හරි

 

[lakijayawardana]

මචන් මෙතන $db කියන්නේ mysqli කනෙක්ෂන් එකක් නෙමෙයි නේ... PDO ඔබ්ජෙක්ට් එකක් නේ...ඔය දෙක දෙකක් මචන්... PDO භාවිත කරනවානම් එකම පාවිච්චි කරන්න...mysqli භාවිත කරනවානම් එක භාවිත කරන්න...ඒ දෙක මිශ්‍ර කරන්න බැහැ...

mysqli_query() කියන එකේ පලවෙනි පැරාමීටර් එකට දෙන්න ඕනේ mysqli_ කනෙක්ෂන් එකක්....

$db = mysqli_connect($host, $user, $password, $db_name);

ඔයා procedural විදිහට කරලා තියෙන නිසා ඔහොම දැම්මේ...ඕකම OO විදිහටත් කරන්න පුළුවන්...ඔතන conn.php එකේ PDO කොටස අයින් කරලා මේක දාන්න...එතකොට හරි

thank you machan mata eka echchara meter wune na
mysqli basic tika thiyena e kiyanne oye select,update piliwelakata thiyena link ekak nadda.

mata ekama eka paarak witharai site ekak hamune -> mark eka explain karala thiyena ekak. anik okkoma bageta explain karala thiyenne

 

[Megatrone]

mysqli_query(connection,query);

connection eka dapan issarahata... eathakota hari

 

[Megatrone]

mysqli_query(connection,query);

connection eka dapan issarahata... eathakota hari

more details
http://php.net/manual/en/mysqli.query.php