I have a registration form that will be used to register new users. My users are called “Clients” so I have two tables in mysql database (“clients” table and “users” table). I’m using Laravel 7. I would like to insert Clients data (first name, last name, email e.t.c) …
Tag: mysql
Filling boostrap cards with data from a mySQL database
I am trying to fill bootstrap cards with data from a database. I am very close. I have the mainphp file called project.php A file with a function called component to fill them, called component.php. And a connectDB.php file, that connect the DB and extracts the information from a table. I am aware this is alo…
Data from 2 tables is not displaying on the same page
I’m a newbie in PHP and mySQL, I’m currently working on a profile page where I will display the logged in user’s personal information from one table called users and also display the tours that they will book in the future from my website from this table: booking I’m fetching the data …
Why is the following SQL Query returning an empty result?
I have the following table structures: 1 – Course(course_id, course_nam, language, course_price, create_date, average_rating, category, course_description, certifica_price, course_creator_id) 2 – Student(student_id, wallet) 3 – Discount(discount_id, discounted_course_id, allower_course_creat…
Follow Unfollow system
I am working on this site that follow and unfollow users just like Twitter follow. The query below works then I notice it doesn’t show me users I don’t follow because the user has been followed by somebody or is following somebody Below is my table structure In the user_follow_list Ben is followin…
Php multiple data insertion with textarea
I have 500+ user:pass and i want add all data with textarea. Example ; user:pass user:pass user:pass I use the following codes to add users individually ; How can I make this to add multiple data user = username : pass = password Thanks in advance. Answer you could use explode to split your string with a sepa…
INSERT INTO SELECT WITH DECLARING OTHER COLUMS VALUE
I just want to ask. what is the problem in here I just want to add some value to the the columns and get other value to the other table. I hope you can help me. I only have the problem in the first 4 value. -Thankyou. Answer
Months name is not showing in German in PHP?
Hi I am trying to display months name in PHP but it is not showing in German language in MYSQL, my date is showing as 2021-01-23 which I converted into months by using PHP function Month(), MONTH(…
PHP: Line break is not working in data table using MYSQL?
Hi I have data in my MYSQL which I am trying to sort by Months and Year together and display it in new HTML table every time sort by Year and months. trying to do like this – (Months wise data) But HTML table is sorted by year only not months. see below the output. But I am trying to
How to cast string boolean from MySQL to real boolean in Javascript?
I built a php backend for my ReactJS frontend. My mysql users table has a checkedIn column that is stored as tinyint. I am fetching it like: And in my frontend: My log gives me: How can I modify my backend or my frontend, to have a real boolean value for checkedIn in the frontend? I expect: As a side