Most voted "mysql" questions
Mysql is a relational database management system (RDBMS) that functions as a server, and provides access to multiple users simultaneously. Your source code is available under the GNU General Public License.
Learn more…10,264 questions
Sort by count of
-
0
votes1
answer100
viewsCollect data from wordpress database
It has how to make connection in the Wordpress database, and to take the data of some tables of it and to transfer in a Site ?
-
0
votes3
answers864
viewsMake primary key uplinkable
When entering the data in my SQL table everything happens normal. However, when trying to insert for the second time, with the same value in id which is the main field of the table, it returns the…
-
0
votes1
answer320
viewsAssign value to input text
I have the code below that is working perfect, IE, whenever I move the images appears to me the left and top scales of the same. However it is appearing with LI and I need it to appear in the VALUE…
-
0
votes3
answers859
viewsUse explodes to separate categories
good afternoon how could I use the explode in this snippet of code for it to have more than one category per movie? I appreciate the help $categoria = $_GET['category']; $sql = "SELECT * FROM filme…
-
0
votes2
answers89
viewslinks between tables
$sql = "SELECT * FROM Inscricao WHERE al_id = ".$_GET['idc']; $sql = "SELECT * FROM Aluno WHERE al_id = ".$_GET['idc']; $sql = "SELECT * FROM EncarregadoDeEducacao WHERE ee_id = ee_id.inscricao…
-
0
votes2
answers1439
viewsHow to export query to CSV with each column in a cell?
Good afternoon guys. I’m already able to export the query to CSV, but I need the value of each column to be in a different cell. EX: Id in cell A, Name in cell B... Any idea?
-
0
votes0
answers672
views -
0
votes1
answer170
viewsHow to Count Total of Multiple Type Records in a Single Query in sql
Hello Today I’m making the record counts this way $sql1 = "SELECT COUNT(*) AS total1 FROM a_finan Where cat = 'Ativos' ; $resultado1 = mysql_query($sql1) or die ("Erro na consulta1"); $linha1 =…
-
0
votes1
answer636
viewsInserting dates in php with PDO
I am having trouble inserting a date in the bank with PDO. I have a mirror class in my table in the bank: class PaginaEntity { private $id; private $data; public function __construct(){…
-
0
votes1
answer349
views -
0
votes1
answer1054
viewsRequest movies by IMDB link
Good evening, I come here to question the community of ONLY if anyone has an idea of how to do this: Example, when we insert a link from IMDB in the input and we give Submit, it adds the movie to…
-
0
votes0
answers178
viewsBootstrap Typeahead + PHP and Mysql Plugin
I am a few days trying to use the Bootstrap Typeahead completion feature with this plugin:biggora/bootstrap-ajax-typeahead. After researching a lot, I found only vague answers, but nothing…
-
0
votes1
answer58
viewsWrite to two or more Mysql tables
Doing this with two or more separate Inserts in the same function is simple, but is there any more correct way that consumes the least amount of resources ? On the platform we are working on, all…
-
0
votes0
answers32
viewsIs it better to leave logic in PHP or Database?
I am creating an application together with another person, she thinks it is better to put all the logic of the system directly in the database (Mysql), under the pretext that it will help if we use…
-
0
votes1
answer5886
viewsHow to delete records from multiple tables at the same time?
I want to give delete in a student for that I want to delete the records of that same student of all the tables where he is and his image of the folder where it is was saved for that I use the…
-
0
votes1
answer67
viewsComment for each post id without multiplication of the same
First see the image of my database (the link arrows from one table to another are the inner join's): http://prntscr.com/6wjl4h Current query: "SELECT question.*, questioncomments.*, login.* FROM…
-
0
votes1
answer40
viewsDoubt Distinct with Doctrine_query
I have a table in mysql and I need to return unique values of this table only I am not able to create a Function or a query that adapts. The SQL statement in the bank would be like this and works…
-
0
votes2
answers114
viewsphp day counting system
good day how I can make a system that registers the current date in the bank and then I want it to show as new type so I want that while the date that was registered is less than 15 days it shows as…
-
0
votes1
answer739
viewsUse of Resultset, converting String to Array
I’m trying to convert some data that comes from BD to an Array, using Resultset to select BD data. In the code below it does not give any error however If I try to use a: System.out.println(x[0]);…
-
0
votes1
answer83
viewsUpdate does not work in database
I have the following code and when I give Submit it does not update the ANYTHING in the database. $query = "SELECT * FROM tests WHERE ID = :ID"; $result = $db->prepare($query);…
-
0
votes1
answer1057
viewsVariable table name in Mysql query with CONCAT()
It is possible to use CONCAT to form the name of the table to be consulted? Example: SELECT T1.id, T1.col FROM tbl AS T1 LEFT JOIN CONCAT('tabela_prefixo_', t1.col) AS T2 ON T2.id = T1.id The actual…
mysqlasked 9 years, 2 months ago Daniel Omine 19,666 -
0
votes1
answer130
viewsSelect within a setInterval and fill an array in the nodejs
I am making an application that needs to be checked in the bank if there has been any change using nodejs. The application works, however, when I have more than one record in the table, it…
-
0
votes1
answer1568
viewsUpload and Recover an Image with Angular
Let’s assume I have a user registration form where I want to save a photo of it. Send this data by POST to the server (Java) where I include in the database. What is the best (practical) way to send…
-
0
votes1
answer201
viewsCatch problem with Mysql connection c#
Hello I’m a beginner in programming and I’m having trouble connecting Mysql in c#, where the code does not check and goes to catch action. Follows the code: conexaoDataSet = new DataSet(); conexao =…
-
0
votes1
answer208
viewsSubmit text and image at the same time
Good evening guys, I have the following question, can someone help me do this (?): Do submit the image and text at the same time while doing submit. My idea was that the type="file" to make submit…
-
0
votes1
answer354
viewsBest form Select tag in Php without framework with DAO project pattern
I have a question about the best way to implement a method that runs through a common select using DAO standard with PDO. It would be appropriate for me to do so, my entire code in the view:…
-
0
votes0
answers36
viewsDeprecated: mysql_connect()
<?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_conecta = "localhost"; $database_conecta = ""; $username_conecta = ""; $password_conecta = ""; $conecta =…
-
0
votes1
answer466
viewsOrganize schedules in the Database
For the construction of a table on the site that will contain a listing of every day of the week, how can I create these tables in the database? For example: Bus line schedules from one city to…
-
0
votes1
answer155
viewsCount records in Doctrine
I need to return the total number of records from a table field, and also count the number of records from a given id. I need to count the data from a poll vote table so I need to count the values…
-
0
votes0
answers47
viewsHow to use Join, mysql/php
I’m starting with PHP now, and I’d like to know what it’s for and how to use Join, I think it would help solve my problem, but I don’t even know where to start...
-
0
votes1
answer119
viewsHow to resolve this Session o_rdwr error?
How can I fix this php session failed o_rdwr no such file or directory The error occurs when I log in to the server, however, locally it does not give any error and usually someone could help me?…
-
0
votes0
answers30
viewsDBMS Setting all notnull columns automaticamene
Is there any configuration in sgbd that forces the database to set all columns of a table to notnull? Whenever I import some database or create a table in my BD, all columns receive the value not…
-
0
votes1
answer727
viewsDatabase does not show the information
Well I created a database on PhpMyAdmin by name students a table called information and put the data in it... Then I went to add it to my website when I add the code instead of the table…
-
0
votes1
answer1527
viewsGet field for longest date
Yesterday the guys helped me get the last status for the longest date, that is to display the status of the last modification. Now I have arisen another difficulty related to the same question but…
-
0
votes2
answers838
viewsHow to create a button if you are logged in to an account
Hello, I wonder when someone is logged in to create a FILE type button. The registration and login system is created, but I do not know how to know when it is logged in or not. index php.…
-
0
votes0
answers324
viewsSchedule patient hours every 30 minutes and save in mysql database
Good evening I need to make an appointment schedule of a medical clinic in C#. I need to list the office hours every 30 minutes, and keep only the appointment times marked in the database Mysql. But…
-
0
votes2
answers230
viewsSearch with date range
In Mysql I have a table that has two DATE fields: data_inicial and data_final. In the System I have a Field (Textfield) where I type a date. This date does not need to be precise, but corresponds to…
-
0
votes1
answer27
viewsGet Bin File Stored in Mysql
Long live! I have a problem getting my PDF file that was stored in a Mysql BD. Whenever I download it, I cannot open it because it returns the message that may be damaged. So I store: $docs = new…
-
0
votes0
answers33
viewsJoomla error 3.0
When saving a module in joomla 3.0 this error appeared to me: 1286 Unknown storage engine 'InnoDB' SQL=SELECT i.*, v.name AS author FROM stw3q_k2_items as i LEFT JOIN stw3q_k2_categories AS c ON…
-
0
votes1
answer72
viewsIs it possible to reuse this complex function for multiple registrations at the same time?
On the site I took over from a previous developer, the investor registration is done one by one after a search in the system called CM. The function is called cadastralInvestidor: function…
-
0
votes0
answers410
viewsUnanswered Webservice (PHP, Mysql, JSON)
I have a PHP webservice with a Mysql database and JSON responses. It is working normally, but I have a problem using the following query: SELECT podcast.id, podcast.nome, podcast.descricao,…
-
0
votes2
answers153
viewsIs it possible to use between to filter searches with a Character field?
For example, if I am going to do a database search of a table with the price of the products, I use in my condition Where: preco_product between 10 and 550 but and for me to do the same type of…
-
0
votes1
answer469
viewsI created a registration system using PHP+Mysql then when running asks to replace Mysql with Mysqli... Which ones should I replace?
<?php $host = "localhost"; $user = "root"; $pass = ""; $banco = "dbcadastro"; $conexao = mysql_connect($host, $user, $pass) or die (mysql_error()); mysql_select_db($banco) or die (mysql_error());…
-
0
votes2
answers128
viewsEmpty page when running sql command
When I run the index.php page, there is a form that goes to the login.php page When the login page is executed it is completely blank, does not execute anything. The Code is as follows: <?php…
-
0
votes2
answers109
viewsError in SQL syntax - mysqli_real_escape_string
I have a syntax error in my code, but I can’t find my error. That’s the mistake I’m getting: You have an error in your SQL syntax; check the manual that Corresponds to your Mysql server version for…
-
0
votes1
answer56
viewsNumber of records that do not meet a given filter
I have this query: SELECT * FROM Tabela WHERE campo != ""; How to know the amount of records that do not meet this condition? I know I can create another query and use affected Rows I can have the 2…
-
0
votes1
answer86
viewsMysql, load the wrong one
Hello, in case I add some file here it goes to the end of the list, however I want it to go to the beginning. Code that performs this if($sql = mysqli_query($coneccao, "SELECT * FROM…
-
0
votes0
answers80
viewsProblem with INSERT PDO
Hello friends I am very layman in PDO and I would like the help of friends to try to create an INSERT that registers a font name in the BD source table. Next, I created this code below, based on the…
-
0
votes1
answer134
viewsHow to send a kind of form without boot?
good would like to know how to send a request to the database. in fact not a request but an insert for when I click on radio button he insert the value of radio button on the bench as I do this?…
-
0
votes1
answer87
viewsCode problem ( Find values between a date and another in the database )
Okay, here’s the problem. I’m working on a code that picks up a series of flights that are available between a date and another date entered by the user. Dates are entered through the datepicker in…