Tag: php

              What you need? WAMP Dreamweaver / Notepad Some knowledge of creating mysql database First of all you need to create a database. Install WAMP if you have not installed yet. Open http://localhost/phpmyadmin/ and log in. Create a database with the name insertdb. Copy the below SQL to create the

To apply ORDER BY or LIMIT to an individual SELECT, place the clause inside the parentheses that enclose the SELECT: (SELECT a FROM t1 WHERE a=10 AND B=1 ORDER BY a LIMIT 10) UNION (SELECT a FROM t2 WHERE a=11 AND B=2 ORDER BY a LIMIT 10); Ref: https://stackoverflow.com/questions/1415328/combining-union-and-limit-operations-in-mysql-query

Often we like to add a stamp or watermark in our images so no one can easily copy the images from our website. Create a folder in www as “watermark” and create/upload three files. stamp.png (It can be with transapercy) picture.jpg (Any image JPG) index.php <?php // Load the stamp and the photo to apply