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
-
-1
votes0
answers13
viewsCompare information in sql
I have the following scenario. I have a site where there are "partners" for this site. Each partner has a specific url for it. When someone accesses this link, with a specific url, something like…
mysqlasked 3 years, 3 months ago gabrielfalieri 1,231 -
-1
votes0
answers16
viewsLoop php in Carousel with Bootstrap indicators
I am creating a Carousel via bootstrap. The problem is that my div: <div class="carousel-inner"> is empty with ::after. Below follows my code: <div id="carouselExampleIndicators"…
-
-1
votes0
answers7
viewsError of mysql_query Giving parameter error
//Connect to mysql server //Sanitize the POST values $login =($_POST['user']); $password =($_POST['password']); if($login!="" && $password!=""){ //Create query $qry="SELECT * FROM…
-
-1
votes1
answer18
viewsRelate the indices (keys) of an obejto Array to the indices (keys) of an array (PHP)
I have a question where I could not find a solution. I have an Array object values and an array status, where I want to relate the indexes of the Array object values to the indices of the array…
-
-1
votes0
answers25
viewsTo what extent is it advantageous to use Nosql?
I’m developing a little app. It does not have a very large amount of data initially, but it would store for example user data (login), images, and some information in text format. But I intend to…
-
-1
votes0
answers31
viewsHow to make a button list data using two select
Hello, I’m doing a project with dynamic selects, I managed to make the selects take the database information, but I wanted to create a button so when it is clicked return me the data of this query:…
-
-1
votes0
answers24
viewsWarning : PDO :: query(): SQLSTATE [HY000]?
You’re making the following mistake: Warning : PDO :: query(): SQLSTATE [HY000]: General error: the mode must be an integer in C: xampp htdocs joel_php curso_hcode DAO sql.php on line 34 Fatal error…
-
-1
votes0
answers9
viewsFatal error : Undetected error: Call to a member function run() on bool in C:
The following error in my code is occurring: Warning : PDO :: query(): SQLSTATE [HY000]: General error: the mode must be an integer in C: xampp htdocs joel_php curso_hcode DAO sql.php on line 34…
-
-1
votes0
answers7
viewsConnection to the wordpress database does not work
A client has an error in the wp-config of the wordpresse message "Error establishing a database Connection", I looked and do not know what it can be...? code below: <?php /** * The base…
-
-1
votes0
answers7
viewsHelp to build a query in Mysql - Build a query between two tables, each table is in a different database
Gentlemen good afternoon I am a junior programmer, and I came across a situation in the company , which I can not solve , what happens , we need to compare two values , but each value is in a…
-
-2
votes3
answers5038
viewsUpload Images with PHP - Mysql
I need to upload an image in Mysql, IE, the image path, has some practical method of doing?
-
-2
votes1
answer57
viewsNeed to manage a text field with separate values ;
I need to insert, edit, delete a text field in this format: 11 2222-3333;11 3333-4444;11 5555-6666;11 7777-8888 In case I need a zebrad grid that lists the data and on each line has this information…
-
-2
votes1
answer157
viewsHow to make this insertion dynamically?
How to do this insertion dynamically knowing the total number of columns? mysql_query("INSERT INTO VOT_PART_MUN_ZONA VALUES ( '$dados[0]', '$dados[1]', '$dados[2]', '$dados[4]', '$dados[...]',…
-
-2
votes1
answer174
viewsHow to build a simple APNS server with PHP?
I am creating a small service triggering notifications. I made this code, to make several pushes shots, where the devicetokens come from a server. But I’m finding the following problems: When I…
-
-2
votes1
answer155
viewsQuery calculating dates with INNER JOIN
Personal hail, Here there’s an example that a guy here from the community posted and I’m trying to adapt my needs but an error arises: #1248 - Every derived table must have its own alias My query…
-
-2
votes1
answer1219
viewsInsert foreach value into a variable
I am trying unsuccessfully to create a variable with the foreach variables for database insertion, the values are checkbox marked, I am trying this way: // buscando os produtos foreach…
-
-2
votes2
answers236
viewsError: Undefined index
I have this code and you give me the following mistake: Notice: Undefined index: ID in <? require('../members/inc/config.php'); require('../lib/framework.php'); // load the configuration file.…
-
-2
votes4
answers2204
viewsMultiple items in a Mysql column
How do I insert and display separate data in a single Mysql mo column? Ex: I have a column (catalogo_address), in it I want to insert the street, the city, and the state in one column and then be…
-
-2
votes2
answers277
viewsError entering record, last possible Intel value already used
I’m having an error trying to enter a record someone knows how to solve. Follow the error message: Operation failed: There was an error while applying the SQL script to the database. Executing:…
mysqlasked 9 years, 4 months ago SneepS NinjA 7,691 -
-2
votes1
answer627
viewsWhich attribute to use for database fields working with numbers from 0 to 5?
Needed to mount a table in Mysql, where the values recorded in this table will be between 0 and 5, what attribute types within the table field should be assumed? What kind of data do we report in…
-
-2
votes2
answers81
viewsWhat’s the risk with this intel?
Speak people, what risk would I take if someone wanted to give an insight into this example: $valorGet = $_GET["valor"]; $sql = "SELECT * FROM tabela WHERE caminho = '$valorGet'"; My question is,…
-
-2
votes1
answer710
viewsUTF-8 Charset error when returning from database
My system has charset error, but it is only with the data returned from the database. My HTML charset is right, the one in the database is also right, and on php.ini is also right. How do I solve…
-
-2
votes1
answer62
viewsDoubt SQL query
I need to make a Mysql query in the following situation: I have two tables announcements and Likes, when the user likes an ad a record is created in the Likes table with the user id and the ad id he…
-
-2
votes1
answer50
viewsQuerys MYSQL BELONGS
I need to make a query in the mysql, within the WHERE I need you to contain the COD_IDENT within a group. That is: COD_IDENT 5 6 7 My query need to return all results where COD_IDENT be equal to…
-
-2
votes1
answer49
viewsselect block rows in block from a range of 10 in 10 by looping the query?
I have a table of 500 thousand precise lines of this 500 thousand lines only of 1000 in 1000 for example select * from table limit 1000 offset 0; the range would be to stop at 1000 and then make…
-
-2
votes2
answers1685
viewsHow to return all fields of a "Mysql" line by the "id" of the line?
Given a table "Mysql", where there are 3 fields: ID - First name - Last name As it should be the query so that only by informing the ID, it returns all fields of the line ? Note: I only put 3 fields…
-
-2
votes1
answer160
viewsHow to display in html the data of all columns obtained through a mysql query?
I have a table with 1000 columns (example), how to display the content , of all columns of a row obtained through the "ID"? SELECT * FROM `tabela_1000_colunas` WHERE id = 1; After this select, how…
-
-2
votes2
answers152
viewsHow to make something expire after certain months in db?
I want to add a "license" for a purchase in my database, plus this license that my "customer" will buy will have an expiration date, let’s say he bought a license... INSERT INTO compras (userid,…
-
-2
votes2
answers2078
viewsExport data from an object to a csv file with PHP
I am trying to export data from the database to a CSV file, but all functions I find to perform such a function present certain type of error. I’m performing the entire search in the database with…
-
-2
votes1
answer81
viewsView recent products registered with php in thumbnails
I have a page and I need to display at index some 4 Thumbs with the latest products registered in my mysql database, I want to do this using php. If anyone can help thanks. My index uses bootstrap…
-
-2
votes1
answer45
viewsSearch in the database when loading the page
When loading the page I want you to make a query in the bank and check that the result brought more than 3 results, if you bring I want to block a checkbox. How can I do this? I’m using Jquery, PHP,…
-
-2
votes1
answer120
viewsSELECT Mysql with wrong result
Let’s take the table below as an example: id empresa forneedor 1 10 105 2 10 102 3 10 105 4 10 112 5 10 105 Using company and supplier as indexes. Making SELECT * FROM table WHERE empresa = 10;…
-
-2
votes2
answers102
viewsPhp file that creates html, how do I get the information to come from the database?
As I do for the html created by this php instead of containing the text between the quotes, it contains information that comes from my database. <?php # Nome do arquivo html $pagename =…
-
-2
votes2
answers70
viewsSyntax error when using UNION
Error: /* Erro SQL (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 'FROM pedido a, tipofornecimento b '…
-
-2
votes1
answer100
viewsHelp to send PHP data to DB
I’m new to programming and I’d like some help I set up a page to insert dates in 4 fields and need these dates to be stored in DB And I kind of don’t know and I’m having a hard time putting it…
-
-2
votes1
answer562
viewsInsert into two php mysql database
I want to insert data from a register in two databases at the same time using PHP/MYSQL. Is there any possibility? . I’m just getting through a connection, when I do the require of two connections…
-
-2
votes1
answer145
viewsHow to step a database variable that is in php for javascript?
I have a program that has coordinates in the database, picking up these coordinates I would pass to another page (javascript) that would calculate the route and show a map on the screen of the…
-
-2
votes2
answers1947
viewsStress problem PHP and Mysql
I have a question regarding accentuation, specifically the return of Ç. My bank has the collation latin1_swedish_ci, I’m using the HTML tags: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0…
-
-2
votes1
answer85
viewsError in php in my syntax
Uncaught Exception 'Pdoexception' with message 'SQLSTATE[42000]: Syntax error or access Violation: 1064 You have an error in your SQL syntax; check the manual that Corresponds to your Mysql server…
-
-2
votes1
answer256
viewsThe more queries in Mysql the higher the consumption?
I’m developing a website and my code is using many queries/queries in Mysql at once, I’m trying to decrease these queries to the smallest number since I think the more queries more resources will be…
-
-2
votes1
answer1460
viewsGrab image from database
wanted to know how I could recover an image from the database, used the php7, the image is recorded in the database in type BLOB, I searched on the internet and were very old examples and none…
-
-2
votes2
answers362
viewsDate_format does not work in code
After following several instructions and operating guides of Date_format, I preferred to ask for help as I tried everything and could not format the date and time output of the Mysql database. Does…
-
-2
votes1
answer167
viewsreturn rows of a 10-by-10 block query by looping this query?
Person, I have a problem. For example: I need to make a SELECT on a huge table, and I want you to return lines in the range of 10 in 10. For example: 1,2,3,4,5,6,7,8,9,10 for…
-
-2
votes1
answer49
viewsWhat do you do when this happens?
I am working on a system in which I must register several data from a form in different tables using mysql. It works like this: The person makes a registration and in the same form requests a…
-
-2
votes2
answers1019
viewsUse "anti_injection" in a MD5 password
I am studying a little more in depth the PHP and in question of security in PHP I have used the standard anti_injection found on the internet and used by many function anti_injection($sql){ $sql =…
-
-2
votes1
answer724
viewsRemove square brackets from an array
You would need to remove the brackets from a print of the results of an array within a While. Follow code: <?php $termo = $_GET['termo']; include "conn.php"; //Consulta busca informações para…
-
-2
votes1
answer135
viewsHow do I connect a Java application to the Mysql-in App on Azure?
How to connect an application via url to the Mysql database (Myslq-inApp) within Azure ? String urlLOCAL = "jdbc:mysql://localhost:3306/crudjsp"; String urlAzure = "jdbc:";…
-
-2
votes1
answer202
viewsconnection from a mysql to android database
I am looking for a free host, where I can save my mysql database and connect it to the android application using the program "Android Studio", can help?
-
-2
votes1
answer75
viewsDoubt IF with SQL
It is calling only an if option. 1 = >all users by date = if empty user and date filled (only this calling and msm so a user has q be selected, what is wrong the user had to be empty) 2 = >…
-
-2
votes2
answers395
viewsMysql problems with DELETE
I’m having problems in mysql when recognizing delete function $code = '1234'; $conn = new PDO('mysql:host=localhost;dbname=data', 'root'); $stmt = $conn->prepare('SELECT * FROM codes WHERE…