Questions tagged [mysql]
MySQL is an open-source, relational database management system.
224 questions
2
votes
0
answers
63
views
How to deal with empty MySQL time zone tables on shared hosting when provider refuses to load them (CiviCRM/WordPress)
I am running CiviCRM 6.5.0 on WordPress 6.8.2 (PHP 8.3) at a shared hosting provider (Mijndomein.nl).
Problem:
The MySQL time zone tables are empty.
Normally this could be fixed with:
...
- 21
1
vote
0
answers
306
views
Connecting to MySQL database hosted on CPanel
I have followed all of the usual steps in setting up a pipeline but cannot seem to get the database itself to connect. I am confident in the correct database name, username passowrd etc but am ...
- 11
1
vote
0
answers
2k
views
mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, string given [closed]
I updating a old volunteer website from Joomla 2.5 to Joomla 4 (PHP 5.4 to PHP 8.1) and mysql to mysqli. A few parts of the website were created by hand with php. So far by searching I have been able ...
- 11
0
votes
1
answer
5k
views
How to fix warning in php : Warning: Undefined variable $nameError in C:\xampp\htdocs\mysql\insert.php on line 84 [closed]
As a beginner in PHP, I was trying to learn how PHP runs along with MySQL. So I was practicing how to insert data into a database using a form. So far this is what I did.
<?php
error_reporting(...
2
votes
5
answers
966
views
Can I develop and test WordPress and PHP without a domain name?
I intend to learn and develop a website using WordPress and PHP. I read from the web that as a start, these two are sufficient for a typical website with database storage and retrieval/query ...
1
vote
1
answer
818
views
Non-existent tablespace when importing MySQL from phpMyAdmin
I usually export a Drupal database from one instance of phpMyAdmin to another on a different server without any issues but lately I have been getting the error when I import:
#3510 - Tablespace ...
- 402
2
votes
1
answer
291
views
Phpmyadmin - How to let users create and manage their own databases without allowing them to see other databases
In PhpMyAdmin I want to allow certain users the ability to create and manage databases without having to manually give them permission to every database they need. I've noticed when giving a user the ...
- 21
1
vote
0
answers
40
views
Why does Dreamweaver save the same .php file twice?
I am creating a website on localhost (WAMP) as of now.
I have set up the testing server
the new php files that I create are saved in a sub-foldor of www
folder specific for my website. [ C:\wamp64\...
0
votes
1
answer
1k
views
Unable to export query result from PHPMyAdmin
I want to export query result in to CSV file from PHPMyAdmin
How to do that?
See the below picture. Normally I can see the option to check all, edit and delete rows.
But when I run this query
...
- 113
1
vote
0
answers
27
views
Is it possible to create mysql accounts for 'user' and have that account access a different page of the website? [closed]
I'm creating a website where me "as an admin" can create other accounts for "users".
When I login as an admin it will be directed to a page like "superuser.php" where I can create an account for "...
- 11
1
vote
0
answers
481
views
Cheapest way to use a MySql Database on Microsoft Azure
I am currently evaluating features of Microsoft Azure, and want to try their Azure Database for MySQL service in a little test project. I just need a very basic database with minimal performance and ...
- 188
3
votes
1
answer
416
views
Using mySql database data directly into generating articles for my website? (newbie, needs to know where to start))
Hi all I am fairly new to web development, I've made a couple of my own sites over the years with simple html tables and free webhosts.
This time, I have decided to try to host my own site using WAMP ...
- 143
1
vote
2
answers
2k
views
Can I use the Laravel Database Framework without using all of Laravel?
I work at a company with a custom PHP framework we have built over the years. For the most our custom framework suits our needs and includes almost everything Laravel offers, however, our database ...
- 111
1
vote
1
answer
336
views
Using MediaWiki and external data, how can I show an image in a page, returned as a blob from a database?
I'm creating a wiki (using MediaWiki) which pulls data from a mySQL instance, and uses this alongside a template to generate the page dynamically.
My mySQL instance contains images, stored in a field ...
- 111
1
vote
1
answer
122
views
Using BLOB's for Small Magazine - PHP / MySQL
I'm building a small magazine website which I plan on using daily, but I'm wondering if I should store my article images and videos as physical files or as BLOB in my MySQL Table.
My primary concern ...
- 13
0
votes
1
answer
105
views
Cannot connect to Wordpress MySQL on Fedora 25
On Fedora 25, I want to develop a Wordpress website. Here's a summary of what I did, but I still cannot get it to work and enter Wordpress management panel:
1- I started MySQL by running
sudo ...
- 111
2
votes
0
answers
100
views
Cannot work with mysql Ver 11.18 Distrib 3.23.55, for suse-linux
An older TYPO3 (v4.4.15) database appears to corrupt a local sandbox MySQL 5.7 schema. The server hosting the CMS says
$ mysql -V
mysql Ver 11.18 Distrib 3.23.55, for suse-linux
Details: Installing ...
- 121
1
vote
2
answers
133
views
Creating a board with thousands of forums
I would like to create a message board that has separate forums for each movie, each actor, each director, etc. With modern forum software, is having many thousands of forums like this impractical for ...
- 111
1
vote
1
answer
99
views
Capturing a variable from a clicked link or url using php [closed]
I've build a php page called pageById.php that pulls in and displays data from a MySQL database, but the query is 'static'.
$sql = "SELECT * FROM table WHERE id = 879";
I want to change this so it ...
- 187
0
votes
1
answer
288
views
Manually insert text into existing MediaWiki table row?
I'm trying to update a page for a MediaWiki database running MW version 1.26.4. The MediaWiki is currenty suffering unexplained Internal Server Errors, so I am trying to perform an end-around by ...
user40589
4
votes
2
answers
23k
views
How do I access MySQL console on wampserver 3?
How do I access MySQL console on Wampserver 3?
With the earlier versions all you had to do was right click on the Wamp server icon and the option to access MySQL console shows up on the side but ...
- 41
2
votes
1
answer
358
views
Is it unusual for a hosting company to refuse to update php and mysql?
I am helping another developer on a WordPress site that's for a committee. Which means everything must be decided upon by a bunch of people and not, like, 2.
The site is using a WP theme purchased ...
- 23
4
votes
1
answer
585
views
Google Analytics not same with my database records
I got a website which will track all the post's visitor view and store each of them in a table with IP address, referrer website and user agent. But I found that in one day I got 100+ rows (pageviews) ...
- 143
2
votes
0
answers
17
views
I always wonder how this dynamic site content index very fast? [duplicate]
I am new to this field.Actually I am learning PHP/MYSQL.Five min before I asked a question in StackOverflow.And when I googling this suddenly my question appears.How does StackOverflow index very fast ...
2
votes
3
answers
8k
views
How do I replace a MySQL Database?
I created a database on the host server using PHPMyAdmin.
I exported the database for local development and have since added data and changed the schema slightly.
How can I replace the database on ...
- 205