So, theres already a pre-made table in the database. Now, I am trying to connect my project to that specific table in the db. but everytime i try to insert data, im getting this error “SQLSTATE[42703]: Undefined column: 7 ERROR: column “updated_at” of relation “applicant_account_tbl…
How to keep the Input field inside the session storage and disabled upon refresh?
I want to disable the input field after the user clicks the “disable” button, and automatically change the “disable” button to “enable”, disabling the input fields at the same time. But, if we refresh or press Ctrl+F5, the disabled fields becomes enabled and editable. Below…
trying to update on duplicate key but its not working
I have this line of sql: It works perfectlly when I only need to insert, but it is failing when trying to update,it has an user_id that is primary key, so I hope thats what gets on the key, the other array variables $datosArr are strings, any ideas? Basically im trying to update when user_id exists , I want t…
Run same web application on multiple linux systems (AWS EC2) with version control
I’m wondering what the best approach is to run a application on multiple Linux servers. Using EC2 AWS linux on different zones. The web application is the same on each zone, using a different database for each application which is defined in a single config file. At the moment when I update the applicat…
Creating a custom validation error message in CodeIgniter4
How can i create a custom error message for a custom validation. I’m using codeIgniter4 Okay guys so I’m a bit of a newbie with CI4 and I have created a custom validation file using the spark command ./spark make:validation and it works but the problem is I still don’t know how to customize …
How can I use 3 group by in one query statement sql? [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 6 days ago. Improve this question This is my query.Group by query in one table and I wanna get three sum column in select state…
Laravel – query part of a integer and boolean value
In my database I have id column which can contain integer, string, integer + string value. like, check this image: https://ibb.co/2KNJzVW As you can see on the id column I have something like this value: product id PPAETRABN018283 So, On the input box (my search form) – If I enter product I can get the …
Mutli Application Calling Model From Shared Site In Single Installation Codeigniter 4
How to call models from other multi application site in single installation codeigniter 4 ? The folder structure look like this : This is my example code : In Site1 Constants.php I have define a root directory to targeted the site2. This return : E:Projectwebsitesite2 Autoload.php I have setup PSR4. Then I Ru…
SyntaxError: Unexpected token ‘o’, “object(Sim”… is not valid JSON
The purpose of the following code is to go through xml file and see if email or login entered by user are taken, and I want to get a JSON response. Here’s my AJAX code: And here’s ‘create_user.php’: Answer It seems you have not prevent PHP code from writing multiple JSON data. In your …
How to push custom key and value into an array from an associative array in PHP
Take a look at this loop My table, id date income expense 1 2022-05-01 00:00:00 20 10 2 2022-06-01 00:00:00 40 30 3 2022-07-01 00:00:00 60 50 In desire one, I want to push custom key and value with specific columns from an associative array ($row) like this, In also desire two, Final output is like below, I w…