i basically have a simple porgram to count how many times a click a specific button and then send it to mysql, but for each button i have diferent tables and separated files. I would like to know if …
Tag: mysql
How do I send bound variables to another page to then update the database?
I’m trying to update a database dependant on an whether the radio button has been clicked or not for a number of different rows which have all been generated from the database. I’ve managed to select …
Codeigniter: Join between three tables
I’m trying to do a Join between three tables, in which in one table could not be informations to do the join. This my tables: Meetings id docent_id motivation Persons id name surname Companions id meeting_id name surname Now I want to recover the information where Meetings.docent_id = Persons.id (and th…
Problems specifying Laravel Eloquent database at runtime
Laravel 5.8. I am trying to save an Eloquent model, choosing the database connection at runtime: My config/database.php file: My problem is that each time I run this code, the cat is created in the mysql (default) database, rather than the staging database, even when USE_STAGING is true. Answer The problem is…
Displaying coordinates from mysql in a php array in specific way
What I’m trying to do is to get lat and lon columns from a MySQL table and put it in an array with this format “lat lon”. This is what I have done so far:
Fatal error: Query Failed! SQL: SELECT * INTO OUTFILE
I couldn’t understand why a query work as expected in PhpMyAdmin and from command line (mysql client) and not in PHP. Fatal error: Query Failed! SQL: SELECT * INTO OUTFILE ‘/var/www/html/domain.dom/tmp/qry_patients_11_11.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘…
Laravel Eloquent – how to get only 2 child of each parent using Eloquent?
I want to get category with only 2 subcategory not all subcategory. Like below output Category 1 subcategory 1, subcategory 2, Category 2 subcategory 1, subcategory 2, Category 3 …
pass the tablename to getData.php in flutter
I am making a flutter application using MySQL. In the home page I have a listview as shown below. The database has unique tables for each item in the list view. What I want is that when I am calling …
Import of SQL file to XAMPP error. Possible code error?
I was wondering if someone could help me. I am taking my 2nd Web Programming Classes and we’re working with MySQL. The teacher provided code to use to create the SQL database. I copy and pasted the …
Upload data to database with JSON [closed]
How can I upload data to database with AJAX, JSON and PHP? Here is the code. AJAX function saveToTheDB(ratedIndex) { $.ajax({ url: ‘fetch.php’, method: ‘POST’, …