please be patient with me I am still learning, see attached code. this works perfectly for my application but now i want to take it live and in the odd occasion that there is an error i would like the user not to see a long string of SQL warning errors if that makes sense. ..
Category : sql
What is wrong with this code? SELECT DISTINCT `postac`.`nazwa_postac` as ‘Nazwa postaci’, `klasa`.`nazwa_klasaPostac` as ‘Klasa postaci’, `postac`.`poziom_postac` as ‘Poziom postaci’, `przedmiot`.`nazwa_przedmiot` as ‘Przedmiot w lewej rece’, `przedmiot`.`nazwa_przedmiot` as ‘Przedmiot w prawej rece’, `region`.`region_nazwa` as ‘Region postaci’, `postac`.`gracz_postac` as ‘Postac gracza’ FROM `postac`, `klasa`, `gracz`, `region`, `przedmiot` WHERE `postac`.`klasa_postac` = `klasa`.`id_klasaPostac` ^ code: https://i.stack.imgur.com/9wg8h.png ^ mostly ..
I have recently started learning about php and laravel framework. Currently i am learning the Eloquent queries to store and retrieve data from the database. I am able to perform simple select, insert etc. queries however i am trying to understand more complex statement including joins. This is the query i want to translate for ..
I have an insert query in MySQL and using PHP 7.3, it gives this error: Error: INSERT INTO ‘registered-drivers'(full-name,contact-no,email,profile-type,profile,cf-type,cnic-front, cb-type,cnic-back,license-type, license, reg-type, reg, car, select-city, model, car-type, car-image) VALUES (,,,,,, ,, ,, ,, ,,,,, ) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the ..
I’m not very experienced in coding PHP and MySQL, and am therefore looking for help. I’d like to do the following: I have a form where users enter their contact details and at the end of the form there is a multiple file upload button. Now if they submit the form, the following should happen: ..
I sava data in sql table as male as 1 female as 2 now I want to get that data back to HTML page and print, but data print as 1/2.how I print that data as Male and Female??? Sourc..
I am building an app in which i want to let users add an image in the database. How do i store it and access it later on the app? PHP please Sourc..
Guys thanks in advance for helping I’m making a online shopping item page, it gets the ‘item_id‘ to loop through a item info db to show its info on the page(price,image,name,whatev) while using that same ‘item_id‘ to loop through an inventory table(the inventory table has color_id, size_id ,item_id and storage_id) to render a drop down ..
I’m trying to compare the client side time format ("14:00") to SQL Server time format ("14:00:00.0000000") with SQL Query, technically is not equal because SQL Server time format has seconds and milliseconds, so I tried to concatenate the seconds and milliseconds to client side time format in PHP script like this 14:00.":00.0000000" and yet is ..
I need some help with my hasManyThrough relationship I have 3 tables: Field Table id Submission Field Table id field_id Submission Field Values Table id submission_field_id and I’m trying to get all the SubmissionFieldValue for the Field through SubmissionField with this: public function FieldValues() { return $this->hasManyThrough(SubmissionFieldValues::class, SubmissionField::class, ‘id’, ‘submission_field_id’, ‘id’, ‘form_field_id’); } So my ..