Questions tagged as 'php'

Tagged questions
2
answers

Highlight the first record brought from a Mysql query with DESC

I do not know if the title is descriptive enough, but I did not know how to ask the question. The problem is this: I have a query that I use to show a "top" of the 20 ages of some people. What I want is that the first record shown, in this ca...
asked by 29.04.2018 / 03:12
1
answer

how to send an email that has a html and php code message?

I need to send an email where the message is with HTML and PHP code, what does the code in html is to assemble the table and with the php and mysql must bring the data and put it in the table, when I only put html if it sends the msj, when I put...
asked by 18.04.2017 / 18:34
3
answers

LEFT OUTER JOIN query with 4 tables

I have 4 tables and Wallpapers, Downloads, Favorites, Votes that are defined as well. Of wallpapers I just need the id. Table Downloads +----+---------+---------+ | id | wall_id | user_id | +----+---------+---------+ | 1 | 1 |...
asked by 23.03.2017 / 01:45
4
answers

Check mail with PHP

Good morning, Through a registration form, I receive mail among other things. To check that it is an email I do a series of simple checks, however when trying to find the position of certain characters like @ it does not return anythin...
asked by 20.03.2017 / 01:22
3
answers

How to get the number of times a word is repeated in MYSQL

How can I get the number of times the word "false" is repeated, in a column from mysql. example: id | read | ------------- 1 | false | ------------- 2 | true | ------------- 3 | false | ------------- 4 | false | -------------...
asked by 15.09.2018 / 21:11
2
answers

know the auto_increment of a MySQL table after deleting the last ID's?

Friends, I come to you to know who tells me how to know the auto_increment of a table. Suppose that id_campo has 30 values, but after 6 rows is deleted, it would be in id_campo (24) , but the auto_increment is at 31. Is there...
asked by 24.10.2017 / 21:00
2
answers

Problem with COUNT (*) Does not return data (PHP AND MYSQL) [closed]

I try to count the amount of invoices in the database: //conexion: $con=@mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME); if(!$con){ die("imposible conectarse: ".mysqli_error($con)); } if (@mysqli_connect_errno()) {...
asked by 27.04.2018 / 17:38
2
answers

Problem with query like

Good morning, I have this query that is like a search engine, only for products where the brand is "strong" .. in the parameter $ word, it can only bring a description of the product or code. When I send a description of the product, the sear...
asked by 27.12.2017 / 14:03
4
answers

URL treatment to avoid errors

I would like to know if there is any function or method to evaluate when the user enters in the URL unwanted text or erroneous data that may "malfunction" the web. That is: if you delete any extension of the URL or insert unwanted characters,...
asked by 14.12.2017 / 10:51
3
answers

Simple problems with PHP arrays

to the point, I declared an empty array, in which I intend to save random integer values using a function and this is what I did, but when doing the count ($ array), I get 0 elements. Example: $numerosJ1 = array(); numerosJugadores($numeros...
asked by 23.09.2018 / 09:03