Posts by rray • 66,288 points
1,220 posts
-
0
votes1
answer2370
viewsA: How can I make a roulette in Javascript
To generate the random number in php use the function Rand(), it accepts two arguments the incial number and the end of an interval. <?php $numero = rand(1 , 5); echo $numero; The echo of the…
-
3
votes2
answers607
viewsA: Pull data from db
It is not recommended to use the mysql_* functions that have long been out of use, it is recommended to use PDO or mysqli in new projects. You can do as follows to list all database records, you…
-
1
votes1
answer131
viewsA: Problem with select dynamical to show dropdown menu for user
The problem seems to lack the bind in the query and also the left quotes, which are causing an error. $novaConsulta = PDOUtil::getStance()->prepare(" Select * from pagina where…
-
8
votes2
answers261
viewsA: Preparedstatement is not working
Fur comments it was possible to discover that the problem was not your code but the configuration of the database, the autocommit was off (so no Exception was released), so write instructions…
-
3
votes1
answer75
viewsA: Procedural code rewriting error for OOP
Blank screen is an indication that an error has occurred and the production server usually hides the errors for security reasons. For quick repair or debug in production just add two lines one that…
-
4
votes1
answer572
views -
1
votes1
answer304
viewsA: Checkbox and Phpmailer
When a field of your form is an array (the attribute name need conchetes), when receiving it in php it is not necessary to use conchetes in the name. Change: $precisa = implode(",",…
-
1
votes3
answers11223
viewsA: What is the MINUS command for and how it works on oracle
According to the documentation Minus returns all the un-duplicated lines of the first query that is not in the second query, it is similar to 'calculating' the difference in conjunct theory. In some…
-
40
votes1
answer2932
viewsA: Is using PDO the safest way to connect to a PHP BD?
Yes PDO is one of the new Apis for connection to the database another is mysqli. One of the advantages of PDO is support for multiple banks and Prepared statements (emulated). In the PDO Controller…
-
2
votes2
answers75
viewsA: Numerical value definition in PHP Constants
The use of constants helps to avoid the problem of magic numbers which is the repetition of a value in various instruction that does not make much sense, in the place of expensive occurrence is…
-
0
votes5
answers3030
viewsA: Codeigniter -> Message: Trying to get Property of non-object
Your object is inside an array item, in which case you can call it directly by the key. It seems to me that here is made his definition: $this->data['result'] =…
-
3
votes3
answers22753
viewsA: Error in select using mysqli_query
Warning: mysqli_query() expects at least 2 Parameters, 1 Given in F: XAMPP htdocs Pap2 rooms.php online 67 This error says that the function expects two arguments and only one has been passed, so it…
-
5
votes1
answer1269
viewsA: PDO connection to bank
Your code has a number of minor errors: On the line where the PDO is instantiated is missing a semicolon and variables, properties etc are case sensitive or either upper case and minuscules make…
-
3
votes2
answers492
viewsA: Mysql due date
Can perform operations at a date using the combination of functions date() with strtotime() which converts the date to a number, then you can add/subtract them with the day, month, year modifiers…
-
0
votes3
answers22761
viewsA: Compile C in Sublime Text
The sublime textbox is just a text editor with advanced functionality what it does is just give an Highlight in keywords, complete certain terms etc. An IDE primarily for statics typing languages is…
-
3
votes2
answers1422
viewsA: Update the information on the page when making a change in the BD
To get the information already updated it is necessary to make a select after the update, as you already have it just turns into a function that asks for two parameters, the connection and the id,…
-
4
votes3
answers3371
viewsA: Query value within a variable
Yes it is possible this using regular expressions, use the function preg_match whether the pattern of regex exists in the string passed as second argument. function findKeyWord($str, $key){ $regex =…
-
3
votes1
answer392
viewsA: CURRENT_TIMESTAMP() inserting zeroed
In INSERT it is necessary to highlight what this means -3 for you can be less 3 hours(Brasilia time) but mysql does not know if it is 3 hours, days, months, years etc use the function subdate to…
-
4
votes2
answers1523
viewsA: Parse error: syntax error, Unexpected 'mysql_query' (T_STRING)
Parse error: syntax error, Unexpected 'mysql_query' (T_STRING) Syntax error it says more or less 'something is out of place/right order', here it is necessary to make an assignment use the equal…
-
0
votes1
answer429
viewsA: Update with Multidimensional Array
The simplest way to do this is to take the array values pass them by a for and run the update within it. If you need something more restrictive can a transaction to ensure the integrity of the…
-
0
votes1
answer72
viewsA: Fatal error in login system
Text values should be in single quotes in your query, as in the code below. num_rows is a property and not a method so do not need kinships. $sql_usuario = "SELECT id, nome, login, senha FROM…
-
3
votes1
answer27
viewsA: Problems entering a datatime record
Values date, datetime, timestamp as well as text(char, varchar, text etc) need to be in quotes, preferably single ones, depending on the server setting double quotes can also be used to identify…
-
3
votes2
answers246
viewsA: Problem with INSERT using PDO
In the update pass date in format Y-m-d, can also pass current date directly by the bank using the function now() mysql. $tempo = date('Y-m-d H:i:s') To get the number of lines do not use…
-
2
votes2
answers237
viewsA: Error while uploading photo
Array to string Conversion in If goal is to save the image name passes the variable who the image name already modified is $nome_imagem, if it’s a blob use file_get_content() and throw that amount…
-
0
votes1
answer212
viewsA: A little problem in Eclipse
Underlined object names/properties/methods etc. are obsolete, it is not recommended to use them in new projects, the lamp should be a suggestion of the new or similar feature. The class…
-
2
votes1
answer1780
viewsA: Error in SQL query in PHP
mysqli_fetch_assoc() expects Parameter 1 to be mysqli_result, Boolean Given This error means that your query failed because mysqli_query() returned a false(Boolean). It looks like your query has a…
-
3
votes2
answers2411
viewsA: Uncompressed data with Internet JOIN using PDO
In your query you have several fields with the same name in different tables, as php is not strongly typed it takes the last name and defines as the array key or object property In the query below I…
-
2
votes1
answer62
viewsA: Problems while recovering Mysql data
The error is here, for each mysql_query() it is necessary a mysql_fetch_assoc() to extract the values of the query executed (Resource) by the database. $bairro = mysql_query("select nmbairro from…
-
0
votes2
answers1233
viewsA: SELECT HTML field displaying Previous, current and next month only
To display only the three months (previous, current and next), you can create an array with range() that starts with the value of the current month minus one and goes up to the current month plus…
-
3
votes1
answer1573
viewsA: Error "Insert value list does not match column list" with PDO
The error says that the number of values passed is different from the number of columns, can solve this specify the column names in the Insert. insert into tabela (c1, c2, c3) values (:c1, :c2, :c3)…
-
1
votes2
answers105
views -
1
votes2
answers1150
viewsA: Sort month that is in full in Postgres
If this table is just to translate the months a simple solution is to add a column with month number the sort must be done by year and by that new column. If you have a date or similar field and…
-
4
votes3
answers1722
viewsA: In PHP, does date() take server or user time?
I’m having a question about the date, it takes the time from the server where the my site is located or the machine the user is accessing? The class or function Datetime/date gets the information…
-
2
votes1
answer324
views -
2
votes3
answers776
views -
9
votes2
answers14345
viewsA: SQLSTATE[HY093]: Invalid Parameter number Insert problem
SQLSTATE[HY093]: Invalid Parameter number: number of bound variables does not match number of tokens It means that the number of parameters passed in the query is not equal to the number of columns…
-
5
votes3
answers161
viewsA: What is the difference between these 2 PHP codes?
The first code explicitly defines the attributes as members of the class and their visibility is also guaranteed (protected) all of them are accessible within the class and their descendants as…
-
7
votes3
answers3860
viewsA: How to rescue ID from last record recorded with Mysqli
Your code lacked a i,the call of insert_id must be made after the execute(). also ensure that the update will only be carried out if the Insert actually occurs successfully otherwise displays the…
-
5
votes5
answers6496
viewsA: Does not record records in my database
Looks like you didn’t pass the correct values on insert and yes only strings, add the dollar sign to the variables sql = mysqli_query($conexao,"INSERT INTO `usuarios` VALUES('', '$nome',…
-
2
votes1
answer124
viewsA: Is it possible to change a word from one string to another in the database via php?
The format of the field seems to be of type date(datetime, timestamp etc), in this case use the functions of date manipulation as date_add() adding a date period. Example SELECT DATE_ADD(now(),…
-
3
votes3
answers852
viewsA: Function does not return value
To return all values concatenate a string using the operator .=, thus for each iteration of the is the variable $c will receive the value already contained plus the current one. If you need to do…
-
2
votes1
answer970
viewsA: PHP- Display query results in a select
You need to imprint with echo the current query item($Row) and not the full array($Rows). while ($row = mysqli_fetch_assoc($result)) { $rows[] = $row; ?> <option> <?php echo…
-
5
votes2
answers1907
viewsA: Pick date and time from a string
You can use that regex to capture the date, use the function preg_match or preg_match_all, for eregi_* was depreciated from php 5.3 $str = 'SSC Napoli v Dnipro - Quinta-Feira 07/05/2015 16:05…
-
1
votes1
answer176
viewsA: How to keep SDK and JRE Java installed and updated in a windows development environment
I don’t know is there any other way for the environment variables more practical, I made a powershell script to automate this process. Limitations: Your environment variable must have the name of…
-
4
votes4
answers20245
viewsA: PDO:: Fetch & Fetchall
fetch() returns only one row of the array, while fetchAll() returns more than one, i.e., this array is indexed by numbers, it takes a loop to display all information. To get the numeric indices use…
-
1
votes1
answer54
viewsA: Code problem
To use mysql_real_escape_string an active connection is required as you have not connected the database with the old functions mysql_* remove the line below. $name = mysql_real_escape_string( $name…
-
1
votes1
answer553
viewsA: Insert into foreign key tables with PDO
In the image Insert method return the id of the record inserted with lastInsertId, store this value in a variable or object and pass it to DescricaoImagemEntity. DAO image public function…
-
4
votes2
answers1278
viewsA: Defined variable, but shows as undefined
The problem is the scope of your variables, they should be passed as an argument in your function if you count nothing happens even if the name is equal. $valorParte = ""; defined here is not the…
-
1
votes1
answer354
viewsA: Best form Select tag in Php without framework with DAO project pattern
Your DAO class should be responsible only for executing queries in the database, avoid text outputs to have problem with header aready sent. Say the user clicked on link that mounts a log screen,…
-
12
votes1
answer3320
viewsA: Source code is displayed on screen and does not run
This happens when the short_open_tag(<?) is not enabled on the server, to solve the problem change all occurrences of: <? for <?php Another way is to enable it by php.ini, after the change…