How can I prevent SQL-injection in PHP [SOLVED]

Following are different 3 ways to prevent from SQL Injection.
1. Using PHP inbuilt Functions.

$name = mysql_real_escape_string($_POST["name"]);
mysql_query("INSERT INTO users VALUES($name)");

2. Use MySqli instead of MySQL. MySqli is far better than MySql because is object oriented MySql.

$stmt = $dbConnection->prepare('INSERT INTO users VALUES(?)');
$name=$_POST["name"];
$stmt->bind_param('s', $name);
$stmt->execute();

3. Using PDO

$stmt = $conn->prepare("INSERT INTO users VALUES(:name)");
$stmt->bindValue(':name', $_POST["name"]);
$stmt->execute();

Best Related Posts are Following:

1. How to import csv file to database through phpmyadmin.
2. How to export mysql query results to csv?.
3. MySql replace NULL values with empty string without effecting Rowset.
4. How to fix Headers already sent error in PHP?.
5. Twitter login failed leads to Page not found.
6. How to send an email using Email Template in Zend Framework.
7. How do I get wordpress global variable and functions in custom file [SOLVED].
8. How to convert php array into javascript array.
9. How to store array in Cookie and retrieve array from cookie.
10. Synchronous XMLHttpRequest on the main thread is deprecated.
11. Send Email from Gmail SMTP using Zend Framework.
12. HTML formatted email not showing up correctly in mail clients (Gmail-Outlook-Hotmail-Iphone-Android) [SOLVED].
13. How to change the author of a post in Wordpress.
14. How to clear Facebook image cache.
15. Google trends api php - How to get hot trends.
16. How can delete a user without deleting the post and comments in wordpress?.
17. Using mysqli and parameterized statements in PHP with Example.
18. Wordpress redirect https to http with htaccess [SOLVED].
19. Advanced PHP Interview Questions and Answers.
20. PHP Technical Interview Questions and Answers for Fresher and Experienced.
21. How to Add attribute in A-Tag using jQuery.
22. 
    

get_class_vars PHP Function

array get_class_vars ( string $class_name )

Get the default properties of the class

Get the default properties of the given class.


<?phpclass myclass {

    var $var1; // this has no default value...
    var $var2 = "xyz";
    var $var3 = 100;
    private $var4; // PHP 5

    // constructor
    function myclass() {
        // change some properties
        $this->var1 = "foo";
        $this->var2 = "bar";
        return true;
    }

}$my_class = new myclass();$class_vars = get_class_vars(get_class($my_class));

foreach ($class_vars as $name => $value) {
    echo "$name : $value\n";
}?>

OOP PHP #16 : fungsi get_class_vars() dan get_class_method

Best Related Posts are Following:

1. Check if string contains specific words - PHP.
2. New features of PHP 5.5 with Examples.
3. New features of PHP 5.4 with Examples.
4. date_sunrise - Returns time of sunrise for a given day and location.
5. Convert image to Binary Data and vice versa in PHP.
6. Difference between in_array and array_key_exists in php with Example.
7. get_class_vars PHP Function.
8. get_class_methods PHP Function.
9. mysql_fetch_field - Get column information from a result.
10. PHP mktime() Function - Get Unix timestamp for a date.
11. Strtolower - Returns string with all alphabetic characters converted to lowercase.
12. PHP file_get_contents Function - Reads entire file into a string.
13. PHP utf8_encode Function - Encodes an ISO-8859-1 string to UTF-8.
14. com_create_guid Generate a globally unique identifier.
15. spl_autoload What is spl_autoload function in php.
16. parse_ini_string - Parse a configuration string.
17. stream_socket_client - Open Internet or Unix domain socket connection.
18. imagecopyresampled-Copy and resize part of an image with resampling.
19. What is proc_close.
20. What is str_getcsv.
21. ob_get_level -Return the nesting level of the output buffering mechanism.
22. openssl decrypt - Decrypts data.
23. Domain Name Server.
24. openssl private encrypt.
25. openssl_pkcs12_read.
26. mb_check_encoding.
27. imagegrabwindow.
28. imagealphablending.
29. Gets options from the command line argument list.
30. spl autoload extensions in PHP.
31. Parse a binary IPTC block into single tags.
32. Embeds binary IPTC data into a JPEG image.
33. Perform a regular expression search and replace.
34. session_set_save_handler.
35. What is session_set_cookie_params.
36. mcrypt_encrypt.
37. imagegrabscreen.
38. imagecreatefrompng - Create a new image from file or URL - PHP.
39. imagecreatefromjpeg.
40. stat Gives information about a file - PHP.
41. fsockopen Open Internet or Unix domain socket connection- PHP.
42. fputcsv - Write in CSV File with PHP.
43. realpath - Get the Real path of File with PHP.
44. intval - Get Integer value from string in PHP.
45. register_shutdown_function.
46. setcookie - Store Cookie in Browser with PHP.
47. header_remove - Remove the Header.
48. proc_open.
49. count_chars - Count Number of character of string with PHP.
50. ucwords - Uppercase the first character of each word in a string.
51. getimagesize -Get the size of an image - PHP.
52. phpinfo - Outputs information about PHP's configuration.
53. iterator_apply - Call a function for every element in an iterator - PHP.
54. spl_autoload_register.
55. json_encode - Returns the JSON representation of a value.
56. mcrypt_decrypt.
57. PHP Magic Methods with Examples.