Environment:os and apache and php and mariadb version. uname -a Linux MiWiFi-R3-srv 4.9.0-11-amd64 #1 SMP Debian 4.9.189-3+deb9u2 (2019-11-11) x86_64 GNU/Linux sudo apachectl -v Server version: Apache/2.4.25 (Debian) Server built: 2019-10-13T15:43:54 php -v PHP 7.0.33-0+deb9u6 (cli) (built: Oct 24 2019 18:50:20)…
I have a xampp server in a laptop with an application running as development environment, and I need to move all the server to a new computer. Will it work if I copy/paste the complete xampp folder from one to…
I have almost 1800 products in my website. I want to increase to price of all products by adding 200 in all products regular price. As I have 1700 products I cannot edit them 1 by 1. I need a…
I'm having some trouble with the final column that is to give me the number of days between the first and last date a movie was rented. My instructors correct output: My incorrect output. Some of the output in my…
I have a MySQL 5.7.29 database on which a website is built. I need to construct a query to find all table rows containing lines such as https://example.com/index.php?topic=7989.0 or similar and replace them with https://example.com/my-redirect-page/?7989.0 The wildcard here is the…
I did an upgrade of my XAMPP from 7.1.24 to 7.4.2. First I uninstall my XAMPP using uninstall.app, then I install my new XAMPP, then i check my phpmyadmin everything look ok. But when i open one of my db…
I have a table filled with data (about 20,000 records). I am trying to update it by the data from another table, but I have a timeout (30 seconds). At first I tried a naive solution: UPDATE TableWhithBlobs a JOIN…
I have a table with description column. Description has a datatype text (but I tried to change to longText type into phpmyadmin). I have a validation rule too: public function rules() { return [ 'title' => 'required|string|between:6,50', 'city' => 'required|integer|exists:cities,id',…
i was learning laravel6 from scratch from laracast.com and when i started to use the database. I bumped into the following problem: IlluminateDatabaseQueryException could not find driver (SQL: select * from posts where slug = my-first-post limit 1) I use…
I've been trying to send the value of a select value to a PHP file using Ajax and then use in a SQL query but I can't seem to get it to work. My select options <select id="select"> <option value="yes">Yes</option>…