After installing MySQL and Apache/PHP, the database connections didn’t work from PHP. They worked only if connect using the MySQL client. Must be a problem with the PHP side. There is a sock file that PHP was trying to use, and it was in /var/mysql/mysql.sock and loged that the file was not there. Warning Error: […]
Continue Reading →Most browser cache form input values and when user refreshes page, the inputs have same values. To stop browsers putting data in where it shouldn’t you can add the autocomplete attribute to the form tag. See below example. <form autocomplete=”off” …></form>
Continue Reading →There are two functions on sql to change string to lowercase. Those are LOWER() and LCASE() and both do the same thing at the end. Example SELECT LOWER(keyword) FROM your_table;
Continue Reading →Callback function of the TinyMCE : init_instance_callback This option should contain a function name to be executed each time a editor instance is initialized. See the bellow example for usage of this callback function. function my_custom_init_instance(inst) { alert(“Editor: ” + inst.editorId + ” is now initialized.”); } tinyMCE.init({ … init_instance_callback : “my_custom_init_instance” });
Continue Reading →If you want to check some element ID exist, then you can use following single jQuery line. if ($(‘#input-id’).length) { // do something }
Continue Reading →Think you need to duplicate existing mysql table as a new empty table. That means only structure of an existing table to new one. Use following sql to do that. create table users2 like users;
Continue Reading →When open a jQuyery UI dialog and can scroll the browser and the dialog would change it’s position relative to the browser window, And if you want to make it stay in the same position relative to the browser, use the following css & javascript. .dialogFixed { position: fixed !important; } $(function() { $( “#dialog” […]
Continue Reading →Think if you has a page with data which load data using ajax and edited those data using ajax form. And go to another page using a link there. And click back button again & old data loaded and not loading last edited data. So you have to reload that page when click on back […]
Continue Reading →If you want to empty or truncate a mysql table using codeigniter active record, use the following code. 🙂 To empty $this->db->empty_table(); This will generate a delete SQL string and runs the query. // DELETE FROM mytable To truncate $this->db->from(‘mytable’); $this->db->truncate(); // or $this->db->truncate(‘mytable’); This will generate a truncate SQL string and runs the query. […]
Continue Reading →The easiest way is to use date function, which lets you mix hard-coded values with ones extracted from a timestamp. If you don’t give a timestamp, it assumes the current date and time. <?php // Current timestamp is assumed, so these find first and last day of THIS month $first_day_this_month = date(‘m-01-Y’); // hard-coded ’01’ […]
Continue Reading →