Tag Archives: SQL

PHP Security

script-secuity




When it comes to PHP, some 99% of amateur sites and 60-70% of all sites use the professional scripting language called PHP. But is it safe to use PHP? Does the implementation of the language not have any gaps that are critical to the operation of our applications? But remember that security problems do not arise just from the language itself, but also from the programming skills of those who write PHP scripts. Of course, most of the errors can […]

Rename Product Image in SQL Query Oscommerce

oscommerce




How to Rename Product Image in SQL Query in osCommerce. In Oscommerce it is simple to rename the product image in sql query. IN the below is the simple script to sove this require(‘includes/application_top.php’);  $products_query = tep_db_query(“select * from products”);  while ($products_values = tep_db_fetch_array($products_query)) {   $products_id = $products_values[‘products_id’]; $products_image = $products_values[‘products_image’]; $image = $products_image.’.jpg’; //echo $image; //echo $products_id; //echo $products_image; $sql = “update products set products_image = ‘” .$image .”‘ where products_id = ‘” . (int)$products_id . “‘”; $update_query […]

Mysql Full Text Search – Mysql

mysql-full-text-search




In this post you’ll learn how to build a basic full-text search engine using PHP and MySQL. What is full text search? The full-text search in mysql allows you to quick and very accurate search for single or multiple keywords from multiple columns. It does this by using an index on the columns that you want to search. There are a few limitations that you should know. Indexed columns can only be TEXT, MySQL does not by default index words […]

Sort Array in PHP

sortarray




If you’ve worked with PHP over any length of time, you’ll already be familiar with arrays — data structures that allow you to store multiple values in a single variable and operate on them as a set. Often, developers find it useful to sort these values, or array elements, into a sequence different from the default one used by PHP. To this end, PHP offers a wide variety of array sorting functions, which allow you to manipulate the arrangement of […]

Top 6 rules to build Solid MySQL AND PHP Applications

6_golden_rules_php




PHP & MYSQL are the those preferred technologies for building web applications, since they provide a way to build web applications rapidly. However, sometimes it leads to code that is hard to maintain , doesn’t scale well and perform poorly. And here there are several golden rules that helps you to build rock-solid applications. 1) Do not Trust your Users’ Input A first golden rules that you should bear in mind is to never write code that trusts customer input. […]

Top 7 PHP Security Article

logo-php_security_audit




PHP is a terrific language for the rapid development of dynamic Websites. It also has many features that are friendly to beginning programmers, such as the fact that it doesn’t require variable declarations. However, many of these features can lead a programmer inadvertently to allow security holes to creep into a Web application. The popular security mailing lists teem with notes of flaws identified in PHP applications, but PHP can be as secure as any other language once you understand […]