I want to update a table with a new url to replace the old one: UPDATE table1 SET column1 = REPLACE(column1, 'OLD URL', 'NEWURL') WHERE column LIKE '%OLDURL%' This updates it mostly but I only want to replace part of…
I have a table where I have 1.5 million records (680 MB). When I am trying to open this table in PHPMyAdmin it is not able to load
I'm trying to get data from the database for my login page, but can't seem to do so. It keeps on telling me that my username or password is wrong. I'm a beginner in this field and got my codes…
This is kind of a noob question. I just want to know if it's okay to add new fields for the wp_users table? Or should I create a new table? example wp_users_information The reason that I asked the question is…
My database works fine when it runs on my mac on localhost. But when I upload the code with filezilla online, the following warning occurs: "Warning: mysqli::__construct() [mysqli.construct]: (HY000/1045):Access denied for user 'root'@'localhost' (using password: YES) in /users/hassib/www/markme/index.php on line…
I want to get the location from this JavaScript to the controller and store it in the database: var currPosition; navigator.geolocation.getCurrentPosition(function(position) { updatePosition(position); setInterval(function() { var lat = currPosition.coords.latitude; var lng = currPosition.coords.longitude; jQuery.ajax({ type: "POST", url: "myURL/location.php", data: 'x='…
I am trying to create a login in SQL and using stored procedures to capture the login information. Even when executing the stored procedure on phpmyadmin, my out param is always returning Null, and I can't figure out why. userid…
I have a big problem and hope you guys can help me. Recently, I went on WordPress, go to general setting and change my WordPress address and site address URL from http to https. I did not have any SSL.…
Here I have some records, I want to search for records from 8:30 AM to 9:30 AM. I tried these query but not working: select * from table_name where '8:30 AM' BETWEEN start_time and end_time OR '9:30 AM' BETWEEN start_time…
My database is called: (training_session) I try to print out some information from my data, but I do not want to have any duplicates. I do get it somehow, may someone tell me what I do wrong? SELECT DISTINCT athlete_id…