"Error 1103: Unable to post..." when inserting data in database

[Gelo_Reuben]

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)]

I removed your password etc to be on the safe side.

[Gelo_Reuben]

oh thanks I forgot to hide it

[Still-learning (1-2-3-4...)]

Why dont you refer this guide before analyzing your problem? Pls go through it and slightly adjust , it will work

MySQLi. PHP. GET. POST. Insert. Update. Delete. Segur SQL Inject

[Gelo_Reuben]

still the same

[Balajidev]

Are you using anytype of free servers ?

[Still-learning (1-2-3-4...)]

Did you try with post text block?

[Gelo_Reuben]

@Balajidev yea and @Still-learning yes and the error is still the same

[Still-learning (1-2-3-4...)]

Four working examples SQLite Extension

sometimes i forgot what sqlite ext i used, this post help me to remember, thank you

Try this

[Rogerio_Rios (Professional Support)]

Try : Use the Screen.ErrorOccurred event and check the 'Parameter Error Number.

[Gelo_Reuben]

I am using phpmyadmin. Do you think it will work? It’s been 4 days and I still have this problem.

[Gelo_Reuben]

I already used that and it doesn’t solve the problem but it only handles the problem.

[Jishnu_Vardhan_Reddy]

[Free]MySQL-My First Extension

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]

Use the Post method rather than Put…

Taifun

[Still-learning (1-2-3-4...)]

@Gelo_Reuben

@Still-learning yes and the error is still the same

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.?

[Taifun]

@Still-learning

but he says still it persists…

@Gelo_Reuben

yes and the error is still the same

Post a screenshot of your updated blocks
Taifun

[_FTTX (Ali Abo Wardi 0 iraq)]

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