Best answeres tagged with phpmyadmin

0

answers

Error inserting foreign key PhpMyAdmin [duplicate]

I have 2 tables: Students and Subjects, each student will have their certain materials, I try to add a foreign key ( FK ) in the tables, but gives this error: Note: Both are in the Engine InnoDB

asked by 15.08.2018 / 05:54

0

answers

Problems trying to run MySQL through Xampp

I was studying about database normally until one day when starting xampp and trying to access phpMyAdmin I got the following error message: phpMyAdmin - Error Error during session start; please check your PHP and/or webserver log file and co...

asked by 03.08.2018 / 16:04

1

answer

Warning: mysqli_real_escape_string () expects exactly 2 parameters, 1 given

I'm doing a posting system using PHP and Mysqli, but there are some bugs that I can not fix. Mycodesbelow..PHP<?phpif(isset($_POST['enviar'])){$autor=mysqli_real_escape_string(trim(strip_tags($_POST['autor'])));$titulo=mysqli_real_escape_s...

asked by 24.07.2018 / 00:16

0

answers

Import phpmyadmin

asked by 06.08.2018 / 15:11

0

answers

Convert charset Latin1 to Utf-8 at column level

I have a huge bank in Latin1 and I need to convert ALL the values of ALL the columns of the bank. Searching discovered a command that does this manually. UPDATE tabela SET coluna = CONVERT(cast(CONVERT(coluna USING latin1) AS BINARY) US...

asked by 18.07.2018 / 18:38

2

answers

How do I get the last values entered from two tables, and sorts them by the last access?

I need to create a select that takes the id's from two tables, unite them and show me the last record of the two together. I tried this way: SELECT DISTINCT p.cod_mobilibus, p.nome, q.dt_acesso FROM pr_pontos p RIGHT JOIN pr_qr_pontos q ON p.c...

asked by 23.07.2018 / 23:02

0

answers

How to access Virtual Host from another pc on the same network

I want to access my local site that is # PC1 by phone or # PC2, but I can only access it from the computer it is on, and if I try to get in from another computer it only works if I put the IP my machine instead of the Virtual Host on what the si...

asked by 08.07.2018 / 07:33

1

answer

Error changing the mysql port on xampp

Because I need to use MySQL Workbench for college, I left port 3306 pro server for Workbench and switched to XAMPP for 3307 as the guy Suman Kotagiri said in this forum link When I started the MySQL module in XAMPP I thought I might make a...

asked by 19.06.2018 / 00:07

0

answers

Error 404 when inserting Kanjis in the URLs of permanent links (permalinks)

I'm starting a blog about Japanese. When trying to set up URL's with Kanjis (for example link I get a 404 error - page not found. But the post usually appears in the list of posts and the initial feed. How to solve?

asked by 18.06.2018 / 16:19

0

answers

I open the products table of localhost / phpmyadmin and it already comes with a definite Select

When I open my phpmyadmin products table it was for vim SELECT * FROM produtos ! That is the standard of all tables. However, the products table every time I refresh the page to see if new products have been registered comes the following:...

asked by 10.06.2018 / 02:12

Questions tagged as 'phpmyadmin'