Here is an image of my current code This is what my current code outputs when I enter it This is what I need my code to be outputting
My current code is to try to find 2 words "Red Table" in Title: SELECT `id`,`title`,`colors`, `child_value`, `vendor`,`price`, `image1`,`shipping` FROM `databasename`.`the_table` WHERE `display` = '1' and (`title` REGEXP '([[:blank:][:punct:]]|^)RED([[:blank:][:punct:]]|$)') and (`title` REGEXP '([[:blank:][:punct:]]|^)TABLE([[:blank:][:punct:]]|$)') The problem is, this is so slow!…
I got Laravel SQLSTATE[HY000] [1049] Unknown database Error, when I try to migrate using php artisan migrate:install/ migrate. I have properly named database on my localhost SQL server. I'm using XAMPP to run it. here's my .env: DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3307…
Good evening, I am currently working on the implementation of a shopping cart through PHP and MySQL, I am getting the following error at line 172 onwards, I have been looking at the quotes but I cannot find the problem,…
I have installed Ubuntu 18.04.3 LTS on my virtual box: I have also created an ssh tunnel the following way to connect to my remote db: admin@admin-VirtualBox:~$ ssh -v -v -v [email protected] -CNL 13306:localhost:3306 OpenSSH_7.6p1 Ubuntu-4ubuntu0.3, OpenSSL 1.0.2n 7 Dec…
"mytest_people" and "mytest_hobbies": PK FK <--- PK +----+------+------+------+ +----+-----------------+ | Id | Name | Age | H_ID | | Id | Hobby | +----+------+------+------+ +----+-----------------+ | 0 | Pete | 100 | 0 | | 0 | Reading News |…
I see this error in phpmyadmin: The number of joins that do not use indexes but I never use join in my code. Now I want get a list of query that do not use indexes. How can I get…
I've got a little problem with my database permissions. I created a user with literally no rights to test a database class I'm writing on my local machine. So now if I try to change the charset on an existing…
I'm sure there's a logic to this, but I do not understand it date_format(date, '%m.%d.%Y') // Output: 03.05.2021 date_format(date, '%D.%m.%Y') // Output: 5th.03.2021 date_format(date, '%e.%m.%Y') // Output: 5.03.2021 But date_format(date, '%d.%m.%Y') // Output: 28.02.2021 There seems to be an issue…
I have a table in mysql called site_settings that looks like this Table in PHPMyAdmin I am trying to store all of my website settings in mysql and want to pull them into PHP as variables. I want to pull…