Questions tagged [phpmyadmin]

0

votes
0

answer
27

Views

Adding new Column with current time in SQL

Im trying to add a new column to my SQL table i want the data type to be TIME and the default value to be CURRENT_TIME. This is my query. ALTER TABLE tuesday_records ADD cur_time TIME DEFAULT CURRENT_TIME And this is the error message i get. Error SQL query: ALTER TABLE tuesday_records ADD cur_time...
Balor9914
0

votes
1

answer
14

Views

How to update row in junction table for student grade

Here i am again. Thank you so much for help. Here is my Old question on how i can select and display the grade of student in a junction table. Select and display all rows belonging to a specific ID I did it successfully but now i am having trouble updating the grade in the junction table. Here is m...
Kimbery palet
0

votes
0

answer
8

Views

User's need to be able to update an image title from a gallery and it update the database table - PHP SQL

I have an image gallery on my webpage, I need the user to be able to UPDATE the image title if they need too. My code is shown below (I've tried using prepared statements for the SELECT query to ensure it's safer....however if I have not implemented it correctly, please do say). My gallery code:
K.Haydock
1

votes
1

answer
27

Views

Fail to pass a boolean value through a SQL request

I want to pass the values of the below form in a database set up with phpMyAdmin: The following piece of php works fine when I don't pass the last variable $read. Whenever I pass $read, an error of SQL syntax is thrown. I tried multiple variant to replace 1 and 0: true, TRUE, etc with no positive r...
Pierre
-1

votes
0

answer
21

Views

import php file and phpmyadmain

I am trying to make connect between my android app and data in phpmyadmain but it their is an error which I don't know MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?php // The...
Lary Samuel
0

votes
0

answer
3

Views

set global for sql mode doesn't work on xampp localhost

I just finished upgrading my MariaDB from 10.1 to 10.3 both localhost xampp and centos server, but always getting this errors Message: SQLSTATE[HY000]: General error: 1364 Field 'cart_info' doesn't have a default value. I know i can add a default value so it will stop but not only on one table have...
Peter
-1

votes
0

answer
16

Views

How to add my project file to phpMyAdmin? [on hold]

I published my project in VS and I want to add my website to phpMyAdmin. I have domain but I couldnt find how to add my file to there
hakan
0

votes
0

answer
6

Views

It works local with xampp. The login works live, but the register does not

Everything works fine. The error log does not show a thing. Stripe tells me that it were created successfully. But i have no entry in my own database. On the other side the login works perfectly well. And the whole backend is working fine. Is there any known error or something i missed here? s...
DarkFlameNinja
1

votes
2

answer
1.2k

Views

Showing rows 0 - 0 (1 total, Query took 0.0008 seconds.) in phpmyadmin SELECT WHERE 1

I have inserted a row in a phpmyadmin table but when i run any of following commands it returns: Showing rows 0 - 0 (1 total, Query took 0.0008 seconds.) SELECT * FROM library_info WHERE 1 SELECT * FROM library_info SELECT * FROM library_info WHERE 1 SELECT * FROM library_info HOW THE DATA IS STORED...
Jain
1

votes
1

answer
249

Views

phpmyadmin logs out on first click

I can log into phpmyadmin successfully. However, whenever I click anywhere within phpmyadmin, or when I reload the page, I end up on the login page again, and am thus unable to use any of the functionality. How can I fix this problem?
cdauth
1

votes
1

answer
4.4k

Views

What's the default password for the root user of phpMyAdmin under AMPPS on a Mac?

I've just used AMPPS on a Mac to install phpMyAdmin but cannot find the root password. What is it or where can it be found? If it helps phpMyAdmin was installed to /Applications/AMPPS/www/myadmin
James
1

votes
1

answer
823

Views

phpMyAdmin - foreign key not working

I am working to establish a foreign key relationship between two tables in phpMyAdmin on my cPanel server - I'll just call them 'parent' and 'child' to keep things simple. In the child table, I have a parent_id column which I want to populate with the id numbers from the parent table. I have follo...
skwidbreth
1

votes
1

answer
50

Views

Can I configure phpMyAdmin to select/USE a database on login?

Sometimes when I'm developing the data access layer of an application, I want to log into phpMyAdmin as a particular user and paste in one or more statements that I have been preparing in a text editor. But when I log into phpMyAdmin, no database is selected. I can tell that no database is selected...
Damian Yerrick
1

votes
1

answer
295

Views

SELECT inside of INSERT

This part of code : INSERT INTO koszyk_produkt (ID_koszyk,ID_produkt,Ilosc) VALUES ( (SELECT ID FROM koszyk WHERE ID_klient=IDk), IDp,Ilosc); works perfectly fine when tested in HeidiSQL (MariaDB), but fails with two errors when I try to apply this in phpMyAdmin (the same engine): A comma or a clo...
DzikiChrzan
1

votes
1

answer
2.4k

Views

How to import a dump of a database with binary files

I have to import a database into phpmyadmin. But the problem is that the creators of the database had the wonderful idea to put some binary files in it. (The field is 'tinyblop' type) When I read the dump in notepad++, I have something like: So there are special caracters that phpmyadmin can't read...
Erlaunis
1

votes
1

answer
684

Views

What does collation utf8mb4_unicode_ci mean

I was working on a project and wanted to implement a posts table similar to the wordpress posts table to store page content. So I basically copied the wp_posts table which is longtext however I noticed under collation it had utf8mb4_unicode_ci I'm wondering what this means and what its necessary for...
Codegenesis G
1

votes
2

answer
2.3k

Views

Symfony \ Component \ HttpKernel \ Exception \ NotFoundHttpException Error in Laravel

I was trying to access http://localhost:8000/phpmyadmin for database in laravel. But it's showing the following error: Symfony \ Component \ HttpKernel \ Exception \ NotFoundHttpException Open: C:\xampp\htdocs\laravel\vendor\laravel\framework\src\Illuminate\Routing\RouteCollection.php $others = $thi...
Hola
1

votes
1

answer
507

Views

How to connect SAP B1 9.0 or 9.1 with PHP 5.5.30?

I have a problem related to SAP B1 and PHP 5.5.30 connection. Actually I know how I can connect PHP direct to SAP B1 Database but that is not good way of connection and it's not supported. So what I need to do is to connect PHP with SAP B1 but not direct connection. in order to read and write data i...
Schadrack Rurangwa
1

votes
1

answer
74

Views

Merge partial DB table into another DB table?

1) I currently have my current database exported into an SQL file. 2) I also have a second SQL file that contains 80 exported rows from a table from a second database (same type of database as my current database, all data is consistent). I'd like to essentially shove these 80 rows into a specific t...
FTLRalph
1

votes
2

answer
527

Views

What is the difference between MySQL grouped indexes and single indexes

In PHP Admin when checking my indexes, I found some grouped indexes and some single indexes. 1) Are my indexes for e.g. post_status indexed twice? 2) If so, which one is best to delete? The grouped or single one? See screenshot:
mesqueeb
1

votes
3

answer
10.7k

Views

phpMyAdmin: Cannot log into the MySQL server no error code

I recently copied my mysql db into a new data directory and changed a few settings. I also accidentally deleted my user directory /home/user and had all the fun of the fair recreating that. I can now connect to mysql on the command line but cannot connect via phpMyAdmin. I get the message: Cannot lo...
Arth
1

votes
1

answer
305

Views

Joomla Database import does not work

i made a backup of my joomla MySQL database using the export function of phpMyAdmin. When i try to import this backup file, it gives me a lot of errors like 'You have an error in your SQL syntax...' even if the SQL looks quite correct. Here is a small part of the backup, which doesnt even work: CREA...
Alphacoder
1

votes
1

answer
680

Views

How i get data from another database in another server? [duplicate]

This question is an exact duplicate of: How to update a table automatically as another table is updated on different mysql server? 2 answers I get 2 database, 'db1' and 'db2', in 2 different servers, 'server1' and 'server2'. The 2 databases have the same structure, and I would like connect one data...
Fernando
1

votes
2

answer
60

Views

Count number of true values in each row

I've created a MySQL database using PHPMyAdmin which stores data that a user on a webpage selects. Basically, the user can click buttons on the page, and when they are clicked, the corresponding column in the database changes from 0 to 1. However, I only want each user to be able to select up to 6 o...
JolonB
1

votes
2

answer
1.9k

Views

docker-compose phpmyadmin kicks out

I'm trying to use a docker-compose.yml for launching mariabd and phpmyadmin. When I edit something on phpmyadmin it kicks me out to login page. db: image: mariadb environment: MYSQL_ROOT_PASSWORD: Pass123 restart: always volumes: - './.data/db:/var/lib/mysql/:rw' phpmyadmin: image: phpmyadmin/phpmya...
berzas
1

votes
1

answer
1.3k

Views

Where is the link to phpmyadmin in Google Compute Engine?

I set up a LAMP instance in Google Compute Engine approx 45 days ago, and it came with phpMyAdmin already set up and accessible via a button in the console (in Compute Engine -> VM instances -> instance-name -> phpMyAdmin). The button is now gone, and I can't find any documentation regarding the cha...
Simon
1

votes
3

answer
1.2k

Views

No privileges in phpmyadmin

I know this question has been asked many times but none of the other solutions put in similar questions have worked. I am trying to move my a WordPress site from one host to another. I have imported the wp database on to the new host and all I have to do is access the 'privileges' tab on phpmyadmin...
James Trenholme
1

votes
2

answer
152

Views

How can I convert string name date to DateTimeFormat Mysql c#?

My string format is Wednesday, June 8, 2016 7:10:29 PM. dateLabel.Text = DateTime.Now.ToLongDateString(); timeLabel.Text = DateTime.Now.ToLongTimeString(); I want to change it to datetimeformat including also the daysoftheweek everytime I'm going to save this data to mysql database.
1

votes
2

answer
80

Views

SQL query to combine tables (n:n)

I have these tables: CATEGORIES: id name KIBE_TRAEGER: id name COUNTIES: id region_id country_id county_code county_de REGIONS: id country region_de CONTACTS: id firstname surname company zipcode city region --> =regions.id --> should show regions.region_de county --> =counties.id --> should sho...
Niko
1

votes
1

answer
313

Views

MySQL 5.5 automatic timestamp update to current

So the timestamp containing column in my database gets automatically updated to current timestamp when I update data there, even if I don't pass any timestamps (not passing null, but just ignoring this field, not including it in update array). I have checked table structure and discovered that the t...
Coffee
1

votes
3

answer
81

Views

Delete Duplicates from large mysql Address DB

I know, deleting duplicates from mysql is often discussed here. But none of the solution work fine within my case. So, I have a DB with Address Data nearly like this: ID; Anrede; Vorname; Nachname; Strasse; Hausnummer; PLZ; Ort; Nummer_Art; Vorwahl; Rufnummer ID is primary Key and unique. And i h...
swapfile
1

votes
2

answer
518

Views

Upload large database file to live server

I have 1GB database that needs to be uploaded to my dev server(phpmyadmin). Is there any solution upload? Please do help me by providing the steps to upload the mysql file. i can't use SQlyog,Putty because i have just cpanel information.
Coder
1

votes
1

answer
65

Views

SELECT statement returns first row instead of record that is looked up

I am trying to select a record from my database, and I am return instead the first one in the table. No matter what I try, the first one gets returned. Here's the query: $query_task_owner = 'select user_id from users where full_name = '$c_task_owner_name''; $response = @mysqli_query($dbc, $query_tas...
Armand
1

votes
2

answer
3.4k

Views

VS Error: The value for column 'IsPrimaryKey' in table 'TableDetails' is DBNull

I am using Visual Studio 2015 with Entity Framework 6 and MySQL Server 5.7.13 The mysql server is from a web and mysql server hosting service online, and I access it using phpmyadmin. I get the following error when I try to update/generate Model from database (the server connection is successful) Un...
Keyur PATEL
1

votes
1

answer
478

Views

Access forbidden! in LAMPP

I install LAMPP in system 15.05 ubuntu opt folder and after I type localhost/dashboard it show home page but i need to put .php file on opt/lampp/htdocs but it can have permission. After that i user this link Fixpermisson. # # This is the main Apache HTTP server configuration file. It contains t...
jsroyal
1

votes
2

answer
640

Views

Magento admin URL changed

I am trying to access my magento admin panel, but I am getting the error 404, I think the admin URL has been changed from the admin panel by another admin user. Is there anyway where I can change the URL or get access to the admin panel. Note:I wanted to change the URL through the local.xml file, b...
Zazai
1

votes
1

answer
34

Views

Random ID Number when user created

I want to use a users unique id to save a cookie - so that I know which user is logged in, and then I can change their content to suit. I am currently just using the usual auto id when a new record is created, but I have heard that for creating user accounts (specifically when you're going to use th...
Eli
1

votes
2

answer
98

Views

Wordpress: Using get_current_user_id() result into my DB table with an HTML form

I have a plugin that contains an HTML form which sends POST data to a DB table. It works perfectly fine excluding one thing. The logged in user's ID is not being sent to the DB table. I think it might be my IF statement just before step #2 here. I've changed it around so many times but haven't had a...
Cody Tetreault
1

votes
1

answer
1k

Views

phpMyAdmin hangs during mySql file import

I received a bunch .sql files, none of them are > 200k I use phpMyAdmin in XAMMP to import to my DB at about 80% of successful import, the must be a bad .sql file that caused phpMyAdmin to hang, but there is no error massage whatsoever. How can phpMyAdim recover from this without erasing the already...
Rich
1

votes
1

answer
137

Views

DELETE link does nothing in PHP when removing data from PHPMyAdmin

I have created a table in PHPMyAdmin, and I have connected to it via a localhost. My PHP code displays the data in a table. I want to be able to delete a certain row, so I created a html/php link to delete the row within a table. My problem is that whenever I press delete, the page just refreshes wi...
Nicholas Nicolaou

View additional questions