I have a large SQL database operating on a live server. Whenever a bug arises, my usual process is to manually export the database from phpmyadmin (by viewing the output text), dropping the localhost database, importing the output dump, and then importing ...
My website's current URL is www.xyz.com/folder-name/filename.php I'm looking to change it to: www.xyz.com/dynamic-value-1/dynamic-value-2/listen(this part stays the same)/? Thanks! ...
After a successful login, I want to display a personalized greeting message to the user in PHP (e.g. "Hey User!"). However, the code $username = $_SESSION['username']; is not retrieving the username properly and displays nothing (Hey !). Here's my PHP ...
Is it possible to store details of both Tamil and English books in the library management system database table? Can you provide me with ideas on how best to manage storing information in different languages? When attempting to add Tamil language content ...
I'm having trouble with this query on the server, but it works fine in Phpmyadmin on my local host : SELECT * FROM op_theme_certification AS t INNER JOIN op_category_module AS c ON t.cat_mod_id = c.cat_mod_id, (SELECT cat_mod_id, MAX(date_expiration) A ...
After creating an SSL certificate and key, I implemented it on my localhost (XAMPP). However, when attempting to access localhost:9001, the browser indicates that the certificate is invalid. https://i.stack.imgur.com/gyQgS.png https://i.stack.imgur.com/K ...
I have a column in my database that stores the top gaining athletes on my fantasy sports website. I want to make each athlete's name a clickable link that directs users to their individual page on our site. Currently, the function in the code is calli ...
I have the following table structure: CREATE TABLE user_info ( user_index INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, user_first_name VARCHAR(250) NOT NULL, user_last_name VARCHAR(250) NOT NULL, user_email VARCHAR(250) NOT NULL, user_t ...
After embarking on setting up a server with NGINX today, I successfully configured PHP and MySQL. Everything seems to be going smoothly so far. However, I am facing an issue with getting NGINX to open PhpMyAdmin (previously located in the root directory [E ...
I am a beginner in this field, so I appreciate your patience with my questions. Currently, I am working on a project that involves inputting form data into a phpMyAdmin table and sending confirmation emails to users upon successful submission. If you'd l ...
I'm facing an issue while trying to set up a basic sails.js application in the Cloud9 environment and connecting it to MySQL. Here are the steps I've followed: Created a Cloud9 project Installed sails: npm -g install sails Created the project: ...
I had a vision to develop a website with dynamic content, specifically a slider similar to this. Currently, it is hard coded and I am looking to make it dynamic by loading images from a folder in my-sql db. I want to use a php script to update the databa ...
`The CORS policy has blocked access to the XMLHttpRequest at 'http://localhost/phpfile/leave-option.php' from the origin 'http://localhost:8100'. This is due to the absence of the 'Access-Control-Allow-Origin' header on the re ...
I have a server-side database with a table called "customers" and a column named "names". My goal is to send a request to the server asking for the first two records in the "customers" table. However, when I execute the program, the browser does not displa ...
My phpmyadmin is populated with the following databases: demo_db_1 information_schema mysql performance_schema demo_db_2 test_db_1 test_db_2 I am looking to generate a list of only custom databases. Basically, when I execute a file test.php, I want to d ...
My team and I are currently working on developing a web application for a company. Our goal is to display various startup companies with different group numbers on this page, while also providing the option to update these numbers. Although the update func ...
I have been experimenting with different methods to create a table that includes a foreign key and then insert it into phpMyAdmin. Unfortunately, the results are not meeting my expectations. Here is what I have tried: CREATE TABLE user ( user_id BIGI ...
I am brand new to Laravel and databases as I work on creating a web application for individuals facing difficulties with specific products. The app prompts users with questions and based on their answers, directs them to the next question in sequence. Each ...
I am facing an issue where my queries are returning incorrect results in Joomla 2.5 compared to directly querying the database. The code is working fine when I query the database directly, but when implemented into Joomla 2.5, it only displays up to the nu ...
I am facing an issue with my MariaDB query in Laravel as it is only returning 4 columns instead of the expected 7. Surprisingly, when I run the same query in PhpMyAdmin SQL editor, all 7 columns are returned correctly. I'm curious about why Laravel might ...
I am facing an issue with my CRUD project developed using react and nodejs. When I attempt to run index.js, a strange error pops up: Named export 'express' not found (please refer to the image for details). The code in my index.js file is as fol ...
I have been working on a project involving php. Throughout the process, all my queries have been executing smoothly. However, I encountered an issue when attempting to delete an object... Below is my php code: <?php //delete item if(isset($_GET['delet ...
I need help sorting MySQL records in descending order to retrieve the most recent entry. Here are the records stored as strings: 1/2017 1/2018 2/2017 2/2018 3/2017 I specifically want to retrieve the value 1/2018. The entries correspond to each year an ...
I am relatively new to SQL coding and I have encountered an issue with grouping Company names with route IDs from 4 different tables. The code snippet I am currently using is returning more records than expected and mixing up company names with route IDs i ...
I am attempting to retrieve daily data from my database, but neither of the two code snippets I have tried are functioning correctly. $sales=Sale::whereDate('created_at', '=', Carbon::today()); The error message I received is: Cla ...
In my PHP project, I am dealing with a dynamic array and trying to store the array result in a variable. However, I encountered an error: array to string conversion while coding. <?php require_once('ag.php'); class H { var $Voltage; ...
Every time I export a database from phpMyAdmin using XAMPP, I always encounter the same error. Strangely enough, when I download files from other websites like YouTube or Pinterest, I never run into any issues. I've consulted my university friends ab ...
I'm currently working through a guide that requires me to establish specific relationships within my database: ALTER TABLE 'tbl_issue' ADD CONSTRAINT 'FK_issue_project' FOREIGN KEY ('project_id') REFERENCES 'tbl_pro ...
My local development environment was set up with wampserver 2.0 (featuring php5.3.0, mysql5.1.16, Apache 2.2.11). Wanting to upgrade, I downloaded php 5.6.16 and extracted it into a new directory named "wamp/bin/php/php5.6.16". I transferred over the neces ...
Is there a reason why a query in PHP may not return the same data as it does in phpMyAdmin SQL? $query = "UPDATE `boards` SET `contestPlaces`=0, `contestPlacesFilled`=0"; $result = mysql_query($query) or die("ERROR:QUERY_FAILED timeset 8" . mysql_error( ...
I need to run this code, but I'm missing one key variable that I can't seem to locate. Here's my current code snippet: SELECT CODE = 'P1R2G1' and CATEGORY = '20M' IF RANK op1 = '1' THEN UPDATE tourneyeventga ...