🚀Get access to full PHP CRUD project. www.udemy.com/course/learn-php-crud-operation-create-read-update-and-delete/?referralCode=4C91E67AB34784662E54 🚀Registration system using PHP and MySQL www.udemy.com/course/registration-and-login-system-using-php-and-mysql/?referralCode=F96D572ED43994DAD56F ******************************* 👉Instagram: @khaiserkhanam instagram.com/khaiserkhanam/
for anyone having this error Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''categories' (category_title) values ('qwe')' at line 1 in E:\XAMPP\htdocs\finale\admin_area\insert_categories.php:6 Stack trace: #0 E:\XAMPP\htdocs\finale\admin_area\insert_categories.php(6): mysqli_query(Object(mysqli), 'insert into 'ca...') #1 E:\XAMPP\htdocs\finale\admin_area\index.php(69): include('E:\\XAMPP\\htdocs...') #2 {main} thrown in E:\XAMPP\htdocs\finale\admin_area\insert_categories.php on line 6 Solution: remove the ' ' on categories in your line $insert_query
Remove the single quotes around the table name 'categories' in the insert query. Table names should be surrounded by backticks (`) instead of single quotes. This is a common mistake when writing SQL queries.
11:25 i am getting this error Fatal error: Uncaught TypeError: mysqli_num_rows(): Argument #1 ($result) must be of type mysqli_result, bool given in C:\xampp\htdocs\website\admin\insert_categories.php:11 Stack trace: #0 C:\xampp\htdocs\website\admin\insert_categories.php(11): mysqli_num_rows(false) #1 C:\xampp\htdocs\website\admin\index.php(78): include('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs\website\admin\insert_categories.php on line 11
Hi, I'm having the same problem as others. I don't get the items inserted successfully alert and it is not adding to my database. I checked all the codes and everything. Can you please help?
i face some problem how can i fix it Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''categories ( 'categories_id','categories_title' ) values ('1','Cloth')' at line 1.
Table names should be surrounded by backticks, if they need to be quoted at all. Using single quotes will turn it into a value and break your query. So replace 'categories' by `categories`
Thank you for a great tutorial. I have a small problem though. Whenever I refresh the page, the form will be resubmitted which is not intended behavior. Is there a solution to my problem or have I done something differently?
In insert category when I'm typing Fruit and Vegetable nothing is happening and in my database phpmyadmin. I have written the code follow your tutorial and same but can't work
If you want, you can do this : alert('Category $category_title has been inserted successfully')"; We add just $category_title It's for display the name of the catergorie
Could you please help ma'am 🙏 I am getting below error in insert category. I checked the code properly but unable to do action. Error visible on the front-end: 0){ echo ""; }else{ $insert_query="insert into 'categories' (category_title) valuse ('$category_title')"; $result=mysqli_query($con,$insert_query); if($result){ echo ""; } } } ?>
I have also stuck into this problem for a while but actually it's a mistake I did in the insert_query. which is I typed the categorise as 'categories' but it's not single qoute. it's the key just above the tab key in the keyboard. so it will be `categories` not 'categories'. looks like that will fix your issue as well.😇
🚀Get access to full PHP CRUD project.
www.udemy.com/course/learn-php-crud-operation-create-read-update-and-delete/?referralCode=4C91E67AB34784662E54
🚀Registration system using PHP and MySQL
www.udemy.com/course/registration-and-login-system-using-php-and-mysql/?referralCode=F96D572ED43994DAD56F
*******************************
👉Instagram: @khaiserkhanam
instagram.com/khaiserkhanam/
for anyone having this error
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''categories' (category_title) values ('qwe')' at line 1 in E:\XAMPP\htdocs\finale\admin_area\insert_categories.php:6 Stack trace: #0 E:\XAMPP\htdocs\finale\admin_area\insert_categories.php(6): mysqli_query(Object(mysqli), 'insert into 'ca...') #1 E:\XAMPP\htdocs\finale\admin_area\index.php(69): include('E:\\XAMPP\\htdocs...') #2 {main} thrown in E:\XAMPP\htdocs\finale\admin_area\insert_categories.php on line 6
Solution: remove the ' ' on categories in your line $insert_query
thank you!!!!
Thank uu😍
Thank you so much
Thank you sooo much
Thanks I was searching for it for long
Remove the single quotes around the table name 'categories' in the insert query. Table names should be surrounded by backticks (`) instead of single quotes. This is a common mistake when writing SQL queries.
You Are Top .. Go On ..
Don't get items inserted successfully in database what to do then
Did you got solution
Please reply 🥺
Please reply I have the same problem
Jazak Allah ❤❤ love you From MIU university 🎉
Thank you soo much💖
Can you plzz help ma'am 🙏
I am getting error in insert category.
I checked the code properly but unable to do action.
Same buddy
use backtiks instead of single quotes for table name `categories` instead of 'categories'
Mam will click on insert categories button alert message was not display and data was not added so please help me
mam plz reply
make sure that your includes folder are seperate folder and not part of the admin folder
11:25 i am getting this error
Fatal error: Uncaught TypeError: mysqli_num_rows(): Argument #1 ($result) must be of type mysqli_result, bool given in C:\xampp\htdocs\website\admin\insert_categories.php:11 Stack trace: #0 C:\xampp\htdocs\website\admin\insert_categories.php(11): mysqli_num_rows(false) #1 C:\xampp\htdocs\website\admin\index.php(78): include('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs\website\admin\insert_categories.php on line 11
Hi, I'm having the same problem as others. I don't get the items inserted successfully alert and it is not adding to my database. I checked all the codes and everything. Can you please help?
@Havi Pradipkumar Patel Check for syntax spelling errors.... I have typed $POST for $_POST and corrected it.
Did you got solution?
Hii your problem solved ya what
For the tag in the connect.php fle and when I save the file in VS code the ?> gets removed. Is that an error?
9:36 - You can also write mysqli_num_rows like below:
if(mysqli_num_rows($result_select) > 0){
echo 'do this';
else{
echo 'do this';
}
}
Please help mem ( syntax error, unexpected token "if" in) error not insert the value please solve my error
Please maam complete the project
Please upload remaining videos🙏🏻
i face some problem how can i fix it
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''categories ( 'categories_id','categories_title' ) values ('1','Cloth')' at line 1.
Table names should be surrounded by backticks, if they need to be quoted at all. Using single quotes will turn it into a value and break your query.
So replace 'categories' by `categories`
@@danyalsamad1080 Thank you! I had the same issue and that fixed it!
@@danyalsamad1080 Dude thank you so much for this it really helps me a lot
Thank you so much it's working now😌
@@danyalsamad1080 thankyou so much
data show ni ho rha database me emply column a rha ha category ka ise kase solve karen
Thank you for a great tutorial. I have a small problem though. Whenever I refresh the page, the form will be resubmitted which is not intended behavior. Is there a solution to my problem or have I done something differently?
How will we get the source code of the e-commerce website that we have created?
They keep saying that no such folder is included but I have a folder. I am unable to connect with my database
In insert category when I'm typing Fruit and Vegetable nothing is happening and in my database phpmyadmin. I have written the code follow your tutorial and same but can't work
Hi, We you able to finish this part???
Check for syntax spelling errors.... I have typed $POST for $_POST and corrected it.
Hi
Can yoh help me in this project
@@riddhikohli1775 didi you got solution?
I am having the same problem .value is not inserted in data aur alert is not showing
If you want, you can do this : alert('Category $category_title has been inserted successfully')"; We add just $category_title It's for display the name of the catergorie
Still doesn't work...am having the same problem where the category is added to the database but the name of the category is not displayed.
Same problem alert message is not displaying
Bahi kya solve ?
All syntax ok but did not working .
$result = "INSERT INTO categories (category_title) VALUES ('$insert_category')"; try this
Hi can u pls help with code
Could you please help ma'am 🙏
I am getting below error in insert category.
I checked the code properly but unable to do action.
Error visible on the front-end:
0){ echo ""; }else{ $insert_query="insert into 'categories' (category_title) valuse ('$category_title')"; $result=mysqli_query($con,$insert_query); if($result){ echo ""; } } } ?>
I have also stuck into this problem for a while but actually it's a mistake I did in the insert_query. which is I typed the categorise as 'categories' but it's not single qoute. it's the key just above the tab key in the keyboard. so it will be `categories` not 'categories'. looks like that will fix your issue as well.😇
Fatal error: Uncaught mysqli_sql_exception: Table 'my store.categories' doesn't exist in C:\xampp\htdocs\ecomerceahad\admin_area\insert-catogories.php:6 Stack trace: #0 C:\xampp\htdocs\ecomerceahad\admin_area\insert-catogories.php(6): mysqli_query(Object(mysqli), 'insert into`cat...') #1 C:\xampp\htdocs\ecomerceahad\admin_area\index.php(93): include('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs\ecomerceahad\admin_area\insert-catogories.php on line 6
Its not working heeeelp
Why?
Please give source code better understand 🙏🙏🙏🙏🙏
tnx alot 😘😍😘😍😘😍😘😍😘😍😘😍