Questions tagged [phpmyadmin]

-2

votes
0

answer
15

Views

: Undefined variable: FILES of image, PHP [duplicate]

This question already has an answer here: “Notice: Undefined variable”, “Notice: Undefined index”, and “Notice: Undefined offset” using PHP 28 answers HTML & PHP - Undefined variable: FILES to upload file [duplicate] 4 answers I'm trying to make an admin page for a website, when in thi...
roudy rahme
1

votes
3

answer
43

Views

mysql copy schema without data

using phpmyadmin and mysql i am trying to run the following query without success create TABLE 'amazonUK-crawler' like 'amazonDE-crawler'; 2 errors were found during analysis. An opening bracket was expected. (near 'like' at position 32) At least one column definition was expected. (near ' ' at posi...
Yossi Bondasd
1

votes
2

answer
24

Views

how to export all databases as separate sql files instead of localhost.sql

I want to export all databases as separate .sql files but I get localhost.sql Can anyone here show me how we can accomplish this?
Lawrence Bosumbe
0

votes
0

answer
11

Views

Adding foreign key constraint data type error

I have a table A that has a field created_by it is a int(11) unsigned with NOT NULL and no default. I want to create a foreign key constraint in table A with the users table id field that is also a int(11) unsigned with NOT NULL and no default (auto incremented). The constraint type will be ON DELET...
Alex
0

votes
2

answer
31

Views

Problems using MySQL inside PHP and trying to get my database to insert into tables

I'm trying to use a page called create-order.php to post information from that form into a confirm-order.php that will insert what is put into the table from create-order.php and input the data into my database. I believe I have the sql right but I can't get the data to show up when looking at my ta...
Brandin Yoder
1

votes
3

answer
667

Views

phpMy Admin 4.8.4 export table as SQL is missing

How to create the well known export as SQL in latest phpMyAdmin ? There is no choice for SQL anymore!
Gerd
0

votes
0

answer
11

Views

How to union all and group by multiple select without null output?

I have problems when select by union and group by, there's null output on the output. Maybe because there's some multiple input with detailed data and some mathematics operation on the inside. I have 1 view table with a primary key and have 2 foreign key that related with 2 table. I've tried this co...
ishiroga
1

votes
3

answer
3.7k

Views

ÆØÅ doesn't display correctly in MySQL

I have set up a table in phpMyAdmin. I haven't changed the charsets or anything. I inserted a text in a new row, and when I try to SELECT that row and output it with PHP, the letters ÆØÅ are displayed as ���, however if I try to edit the field in phpMyAdmin, the letters are displayed correc...
1

votes
0

answer
180

Views

Xampp Database Replication Setup Error

Scenario I've been trying to set up mysql database replication on my xampp server but its not been working. I get the following error and the error logs display the following message. 2017-12-28 10:14:37 10384 [ERROR] Slave I/O: Fatal error: The slave I/O thread stops because master and slave have e...
Kenziiee Flavius
1

votes
1

answer
40

Views

creating a trigger in php-my-admin

i would like to create a trigger using the phpmyadmin 'add trigger' option. The Trigger should run AFTER every INSERT in table comments that takes the highest 'number of comments' (nc in DB) from the table 'POST' and takes the 'ID' and the 'question' of that row and puts it in the 'top_questions' t...
Zyzzx
1

votes
1

answer
95

Views

Skip the first line of a CSV file in Yii2

public function actionUpload(){ $model = new CsvForm(); if($model->load(Yii::$app->request->post())){ $file = UploadedFile::getInstance($model,'file'); $filename = 'Data.'.$file->extension; $upload = $file->saveAs('uploads/'.$filename); if($upload){ define('CSV_PATH','uploads/'); $csv_file = CSV_PAT...
Janardhan Ram
1

votes
1

answer
74

Views

Inserting exported PHP array from phpmyadmin

I have exported data from my MySQL database in PHP My Admin. I exported it as a PHP Array. $measurements = array( array('measurement_id' => '1','measurement_name' => 'bag','measurement_last_updated' => '2018-01-03 14:40:49'), array('measurement_id' => '2','measurement_name' => 'bowl','measurement_la...
1

votes
1

answer
75

Views

Laravel. How to put put image from Laravel public folder and to put it into database

maybe somebody could advice me. I have images in Laravel public/images folder and now in my dishes table im trying to put image from public folder public function up() { Schema::create('dishes', function (Blueprint $table) { $table->increments('id')->unique(); $table->string('gamintojas', 20); $tabl...
moniqu
1

votes
0

answer
225

Views

sql query with select before insert

I am currently working on the following sql code which should insert a new data set only if it doesn't exist so far. The sql code works fine when being executed in phpmyadmin. If I execute the code within php I get the error (see below). The sql code is the following: INSERT INTO `historiclist` (`...
harrykupfer
1

votes
0

answer
258

Views

mb_detect_encoding , PHP7.1.13 phpMyadmin not working Wamp windows

I added php 7.1.13 version in wampp server windows, PHPmyadmin working perfect on php5.5.12 version. when 1 change my php version to 7.1.13 from my previous version 5.5.12 then phpmyadmin stop working. Fatal error: Uncaught Error: Call to undefined function mb_detect_encoding() in D:\wamp\apps\phpm...
noman.khan87
1

votes
0

answer
45

Views

PHP Image hashing

I am making a social network and I want to give the users profile picture a unique name when they upload it to the folder directory and/or the database . I looked on here and saw some good answers but I don't know how to implement them with my code . I tried this code $strtotime = strtotime('now');...
Jacobs Johnson
1

votes
0

answer
96

Views

Laravel 5.4, mysql 5.6.35 empty result when using STR_TO_DATE in where clause

I get empty result in eloquent query builder, whereas copying the sql (from ->toSql( ) function) and run it in phpadmin works perfectly. This is my query: $reportData=DB::table('my_table') ->select('my_table.*') ->whereRaw('STR_TO_DATE(my_table.date, '%m.%Y') >= STR_TO_DATE('01.2017', '%m.%Y')') The...
4givN
1

votes
0

answer
486

Views

phpmyadmin Designer tab 'error has been detected on the server' but console is blank

What is the error here? I even tried checking all the tables with operation and it shows all ok. When i press ignore all everything's fine.
Cheang Wai Bin
1

votes
0

answer
94

Views

nginx access denied on subfolder

location /phpmyadmin/ { allow all; root /opt/data; fastcgi_pass unix:/var/run/php5-fpm.sock; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; include fastcgi_params; fastcgi_param PATH_INFO $fastcgi_path_info; fastcgi_param SCRIPT_FILENAME $doc...
Blurry Script
1

votes
0

answer
25

Views

Relational tables in phpmyadmin

what's the point in creating relationships between tables in phpmyadmin designer view while in fact retrieving data can be done by simple SELECT + JOIN (left / right / inner / outer) statements? I know that having data stored in multiple tables with the right primary and foreign indexes increases o...
alice_in_wonderland
1

votes
0

answer
230

Views

Run PhpMyAdmin in node based server

I am trying to run the phpmyadmin on apache server to access the MySQL. But PhpMyAdmin is not working, the reason I am thinking is this: Since I have written down the server code in the node and hosted it on the Apache server, so I have redirected the port 80 traffic to the port 3000. So when I am...
Ankur_009
1

votes
1

answer
206

Views

How do I define relationships between User, Post and Like models

I'm building a blogging app with laravel with the functionality to like a post (only once by a user) with a thumbs-up icon. I have set up a model each for User, Post and Like with their respective tables. The likes table consist of user_id,post_id and the timestamps columns. I have also defined rela...
banky
1

votes
1

answer
64

Views

Uploading and showing profile picture

I am trying to upload a profile picture to my social account but I am having a couple of problems . I want the name of the image to be unique so I decided to add the date and time to each of the pictures to prevent any confusion with the files . In my database I have name:date_time type:datetime le...
New indie
1

votes
1

answer
27

Views

Show number of new records on page

I want to display the exact number of new entries (records) on my page of my phpmyadmin database after reloading the page. I looked online but couldn't find anything usefull. Maybe someone can help me. This is the code for the page: Verzoekpagina DJ
Patrick van den Hurk
1

votes
1

answer
25

Views

LINK columns to rows in MySQL database

I have a MySQL database in which I created 2 tables. One of these has a 'ID' column with several entries in it (for this example, lets say [0, 1, 2, 3]). The second table needs to have the same number of entries, but as columns. So each 'ID' row in the first table corresponds to a column in this sec...
Keysaw
1

votes
4

answer
75

Views

SELECT time period, SQL

Can someone please help me? This doesn't work (I get no results): SELECT * FROM push WHERE Sent >= '08.00' AND Sent < '10:00' Sent contains 'Dec 5, 2017 09:45 AM CET' and I would like to select everything that has a time between 08:00 and 10:00. I've also tried things like (I get no results): SELEC...
anna
1

votes
0

answer
61

Views

MySQL migrate data from one table to another

I'm attempting to move data from one table to another, as part of a restructure to the database architecture. I'm using PHPMyAdmin and MySQL to do so. The SQL is meant to, for each emergency_contacts.id, move e_c.id and e_c.activity_id to activities_emergency_contacts, where the pair will form a com...
Tom Barden
1

votes
0

answer
209

Views

Ping failed, unknown system variable 'language'

I'm trying to connect Eclipse to phpMyAdmin but when I'm trying to do a Test Connection I get this error: Ping failed! java.sql.SQLException: Unknown system variable 'language' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:39...
Paul Botezatu
1

votes
0

answer
113

Views

Convert latitude and longitude to decimal in codeigniter

how to convert number latitude or longitude just to decimal convert latitude to show 2 number in front of comma convert longitude to show 3 number in front of comma show me code in model and view insert + view the result like in here view insert Latitude Longitude view result please help me
Dini
1

votes
1

answer
1.1k

Views

Waiting for table level lock - mysql

I am trying to run a simple query SELECT * FROM table_name LIMIT 1 and the process goes on without retrieving anything. I cannot do run any other queries for that specific table because they go on forever. I killed the session (using phpMyAdmin > Status) but still when I try to run the query again i...
johnmmm
1

votes
2

answer
24

Views

How can I add the selected row that has been deleted to a backup database?

Private Sub Delete1_Click(sender As Object, e As EventArgs) Handles Delete1.Click Dim mResult Dim ObjConnection As New MySqlConnection() mResult = MsgBox('You are really want to delete the slected record?', vbYesNo + vbQuestion, 'Removal Confirmation') If mResult = vbNo Then Exit Sub End If...
kai
1

votes
0

answer
27

Views

Configuring MySQL with Node.js from AMP project

I am trying to migrate an existing MySQL + PHP project (with phpMyAdmin) to server-side javascript (Node.js and Express). I am wondering how best to establish a MySQL connection with Node, given that the current setup is on phpMyAdmin? That is, is it possible to configure the node-mysql connection s...
K. Li
1

votes
0

answer
322

Views

PHPMyAdmin Error- MySQLIi extension missing (Windows)

I'm running the latest versions of Apache, php and MySQL on a Windows 10 device and am stuck at the PHPMyAdmin Error 'mysqli extension is missing'. I've tried everything from un-commenting the extensions to changing the directory and restarting Apache but even though I can see the mysqli.dll file, t...
Aradhana Gahlaut
1

votes
0

answer
48

Views

JPA @JoinTable do not create foreign keys in phpmyadmin

I am new to Hibernate and JPA. I would like to create a @ManyToMany relationship between the Movie and Actor class. In the hibernate.cfg.xml file, I have set the following configuration: update Here a code snapshot from the Movie and Actor entities. @Entity public class Movie { @Id @GeneratedValue(...
Draxent
1

votes
0

answer
22

Views

Reset but not truncate

Is there any possible way to reset a record in a table, without truncating it? Here is my table: So, i want to reset the stack_number back to A-1 without deleting the previous record
Henry Wilson
1

votes
1

answer
46

Views

Can't save a stored procedure: #1064 - You have an error in your SQL syntax;

I'm trying to create a stored procedure in phpmyadmin. My definition is: BEGIN INSERT INTO `medication_mapping` (`patient_id`, `active_ingredient_id`, `strength`, `pharmaceutical_dose_form_id`, `number_of_units_per_intake`, `frequency_of_intake`, `date_of_onset`, `duration`, `unit_id`, `status`, `ve...
zinon
1

votes
0

answer
53

Views

What is the easiest way to access my database from another computer?

I created a mySQL database with phpMyAdmin. In this database I stored the names and the location of my friends (along with an id as a primary key for the database). I wrote and run the following php script to retrieve these data from the database and project them on my local web server (XAMPP): Now...
Poete Maudit
1

votes
1

answer
30

Views

adding values to a different column after button click

I have a page where users can view the tickets they sent, they can cancel it as well, here's what it looks like: What I want to happen is that when I click on the 'Closed: Cancelled' button. It would show 'Closed: Cancelled' in the assignee column as well. Currently this is what I only get when I cl...
Andre F
1

votes
1

answer
641

Views

Logging in as root in MySQL does not require password

Whenever I try to login via SSH on my MySQL server, the 'root' user does not require me to provide a password. I already tried the suggestion from this guide, however, I still have no luck. UPDATE mysql.user SET authentication_string = PASSWORD('MyPass'), password_expired = 'N' WHERE User = 'root'...
jericpo
1

votes
1

answer
182

Views

Wordpress pages not loading, after migrating to new host

I've migrated my wordpress sites to a new host. Migrated the database correctly, changed .htaccess and wp-config. The homepage of the site loading perfectly fine. But when I click on any of the pages they aren't working. The directory is .../public_html/directory_name/site/ and when I click a page...
András Tóth

View additional questions