10 questions with no answers
0
votes
0
answers
185
views
Json.dumps alternative in Redshift
I have strings like
Origi\"nal
and
Origi"nal
. I want to convert them to raw string and then to a Json String and write to a table in Redshift.
Example output of "select col from ...
0
votes
0
answers
272
views
mysqli_real_escape_string() does not work in database
I am using mysqli_real_escape_string() function for prevent SQl Injection.My code
<?php
// open a connection
$dhost = 'localhost';
$duser = 'user';
$dpw = 'pass';
$dname = 'db_name';
$connection ...
0
votes
0
answers
138
views
Escape string in mysqli
I have a function to escape string in my OOP PHP project like this....
public function escape($string)
{
$query = mysqli_real_escape_string($this->connection, $string);
return $query;
}
is ...
1
vote
0
answers
1k
views
AngularJS and PHP: escaping and unescaping JSON string
I was trying to save some data (a table) as JSON in my database with AngularJS and PHP. For that, I would want to convert it to string first and then escape special characters (avoiding SQL injection)....
0
votes
0
answers
119
views
from real_escape_string appears as text on browser
From real_escape_string code is showing as text not running on browser, even dreamweaver showing no error please help
if any alternative then please tell me.
trying to create a subscribe php form with ...
1
vote
0
answers
497
views
Cleaning the post array?
I am very new to PHP and I am trying to add in precautions to my web form to avoid misuse, these inputs from the user are being stored to a database. I keep getting errors when trying to pass through ...
0
votes
0
answers
68
views
Apostrophes not being escaped in new server environment
I've moved a site to a new server and am having trouble determining why the old server properly handles apostrophes in a back end form and the new server does not (breaks sql query).
The site is ...
1
vote
0
answers
32
views
Simple form always inserting \' once typed '
have this crazy issue with string escaping, if I insert ' in to fields I am getting \' in return, I am not even escaping any string? Could you tell me what happen and how do I display ' correctly ?
&...
1
vote
0
answers
74
views
html purifier library usage concept
HiI am at prototype stage with my site. I read the html purifier main page and questions about this library in this site but I am still not clear with the issue on my mind. Can you guide me please?...
1
vote
0
answers
414
views
Script to undo php Magic Quotes and mysql_real_escape_string combination
For the last 4 years I've run a site mistakenly using both magic quotes and mysql_real_escape_string simultaneously.
This has resulted in all manner of different format strings being stored where in ...