Hello, I always got this error while inserting data in mysql. I already exported the app and installed it in my phone since I can’t use Kodular Companion because it turning off quickly. I don’t know if the cause of the problem is from my source code or somewhere. I already searched this error here but still didn’t found something to help me solve the problem.
This is the source code:
<?php
$host = "localhost";//serverhost
$username = "username";
$password = "password";
$dbname = "dbname";// database name
date_default_timezone_set('Asia/Manila');
$Tk_SchDate = $_POST['Tk_SchDate'];
$Tk_Time = $_POST['Tk_Time'];
$Tk_PassName = $_POST['Tk_PassName'];
$Tk_Branch = $_POST['Tk_Branch'];
$Tk_Route = $_POST['Tk_Route'];
$Tk_Seat = $_POST['Tk_Seat'];
$Tk_DateAdd = date['Y-m-d'];
$Tk_Price = $_POST['Tk_Price'];
$Tk_Stat = "ACTIVE";
$Tk_CusID = $_POST['Tk_CusID'];
$Tk_CusName = $_POST['Tk_CusName'];
$conn = new mysqli($host,$username,$password,$dbname);
$sel = mysqli_query($conn, "SELECT * FROM qrcode WHERE Cus_ID='$Tk_CusID'");
$result = mysqli_num_rows($sel);
if($result>0)
{
$rows = $result->fetch_assoc();
$qr = $rows['QR_ID'];
$ins = mysqli_query($conn, "INSERT INTO ticket(Tick_Sch_Date, Tick_Sch_Time, Tick_Pass_Name, Tick_Branch, Tick_Route, Tick_Seat, Tick_DateAdd, Tick_Price, Tick_Stat,QR_ID, Cus_ID, Tick_Cus_Name) VALUES ('$Tk_SchDate','$Tk_Time','$Tk_PassName','$Tk_Branch','$Tk_Route','$Tk_Seat','$Tk_DateAdd','$Tk_Price','$Tk_Stat','$qr',$Tk_CusID','$Tk_CusName')");
if($ins)
{
echo "You reservation has now been sent";
}
}
This is my algorithm:
Peter
(Moderator)
July 19, 2021, 4:35am
#2
I removed your password etc to be on the safe side.
3 Likes
oh thanks I forgot to hide it
1 Like
Why dont you refer this guide before analyzing your problem? Pls go through it and slightly adjust , it will work
2 Likes
Balajidev
(Balaji Dev)
July 19, 2021, 8:09am
#6
Are you using anytype of free servers ?
Did you try with post text block?
@Balajidev yea and @Still-learning yes and the error is still the same
Rogerio_Rios
(Professional Support)
July 20, 2021, 11:27pm
#10
Try : Use the Screen.ErrorOccurred event and check the 'Parameter Error Number.
1 Like
I am using phpmyadmin. Do you think it will work? It’s been 4 days and I still have this problem.
I already used that and it doesn’t solve the problem but it only handles the problem.
Phantom
(Jishnu)
July 23, 2021, 1:55am
#13
Hi Guys This Is My First Extension So With This Extension You Can Store Data In Mysql
Sorry Guys I Could Not Provide The Blocks Because You Need To Customize Parameters I Built This Extension For My Apps If You I Will Customize It I Can Send You By PM
These Are The Examples:
[blocks(9)]
[blocks(8)]
[Screenshot 2021-07-19 15.50.23]
[Screenshot_20210719-171424]
[Screenshot_20210719-171449]
[Screenshot_20210719-171513]
Mysql.aix (Only For Testing)
I Am Not Including Because I Could Not …
Contact me This Can Be Helpful
Taifun
July 23, 2021, 2:49am
#14
Use the Post method rather than Put…
Taifun
Already i suggested @Taifun but he says still it persists…
Still-learning:
post text block
I think the problem could be due to multiple join block ? Only one join is enough but has used multiple join if so how app will read this.?
1 Like
Taifun
July 23, 2021, 2:54am
#16
Post a screenshot of your updated blocks
Taifun
1 Like
_FTTX
(Ali Abo Wardi 0 iraq)
July 23, 2021, 7:41am
#17
I think there is a mistake in one of the letters of your sentences or you forgot a certain letter. I faced this problem many times