When I try to connect php whith the container that has the mysql server I get this error This is the docker compose file: This is the connection class: Now that I changed the host to 127.0.0.1, the connection is refused. And there’s no way that the MySQL server isn’t running, cause i can connect to it using php-server, but
Tag: mysql
i have a problem with search using php, mysql
I have 50M data in my database (mysql phpmyadmin), when I search inside this data using php it takes a lot of time, very slow How can i solve this problem? my code : and thanks I’ve already tried using limit and Like But nothing happened Answer There are three things I can suggest you that can improve the performance
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 to
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 statement This is my table This is
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 result as there is product
How do I filter with dropdown list? PHP and SQL
We are trying to filter based on the tags or the dropdown menu, we are trying to create a blog website that has tags and those tags can be used to filter the posted content on the homepage Tags dropdown menu:. Here should be the content in the page: Here should be the content in the page: Answer Set tags
Cannot terminate or close a PDO connection MySQL
The page seems to continue loading indefinitely event when the script reaches the end. How can I terminate the connection after breaking out of the PHP loop? I have set the $pdo and $usearch variables to null and reviewed other questions. Answer I moved to MySQLi:
Update Multiple columns with no effect
I am developing an API’s, in my project we are using dynamic databases so for that one i am connecting databases by using mysqli it’s working fine i can able to do CRUD operations also on Database but if i try to update multiple columns at that time changes are not reflected in Database did i miss anything can anyone
How to upload files from react native app to PHP server?
I developed a PHP project, now I am working on connecting it to react native app. However, I tried many codes to upload image to the server nothing works. Here is my code example, }; And for the PHP server side (upload.php), here is the code I got this code from here https://aboutreact.com/file-uploading-in-react-native/ And I am getting this error Can
Split a comma delimited string into an array and display on html page
basically I’m making a page where the information from mySQL database will be displayed. I have a column named topics in the database where the string (VARCHAR) goes like this: Marketing, Business, Law, Medicine, … I’m trying to break up this string after a comma and display them in a single line one by one like this: I already have