Posts by Brenno Sacramento • 47 points
6 posts
-
1
votes1
answer37
viewsQ: Mysql - exchange contents from ISO-8859-1 charset column to UTF-8
It is possible to swap the content charset of specific columns? I have a database with the following architecture: :: Idcontent (int autoincrement) :: Title (vchar) :: Summary (vchar) :: Content…
-
0
votes2
answers59
viewsQ: Select record between the first day of month X and the last day of month X
How would the Mysql Query be for me to get all records of the selected month (using a select)? Date field is of type Date. SELECT * FROM tabel WHERE primeiro-dia-do-mes-x BETWEEN ultimo-dia-do-mes-x…
mysqlasked Brenno Sacramento 47 -
-2
votes2
answers34
viewsA: How to solve a depreciated each() problem?
I resolved foreach($image as $key=>$v){ ($key == 0) ? $width = $v : $height = $v; } $image = imagecreatetruecolor($width, $height);
phpanswered Brenno Sacramento 47 -
-1
votes2
answers34
viewsQ: How to solve a depreciated each() problem?
My code elseif (is_array($image)) { list($key, $width) = each($image); list($key, $height) = each($image); $image = imagecreatetruecolor($width, $height); } This excerpt is appearing a Notice de…
phpasked Brenno Sacramento 47 -
2
votes2
answers84
viewsQ: Mysql Select replace a code with information
I have two situations in the search inside Mysql that I need to exchange the code for a literal data. Field: Pgto (possible data: S or N) In the search if the Pgto field is N I display on the screen…
mysqlasked Brenno Sacramento 47 -
2
votes1
answer200
viewsQ: Function to encrypt and decrypt in PHP 7+
I own the functions below: function enCript($string, $key) { $result = ''; $test = ""; for($i=0; $i<strlen($string); $i++) { $char = substr($string, $i, 1); $keychar = substr($key, ($i %…