Change your PHP code as below $del_id = $_POST[‘checkbox’]; $detectinglocations=”your database table name”; foreach($del_id as $value){ $sql = “DELETE FROM “.$detectinglocations.” WHERE id='”.$value.”‘”; $result = mysql_query($sql); } 2 solved Delete record from table using Checkbox [duplicate]
If you have the paid date as a string: if(strtotime(“2012-10-19 13:13:20 +3 years”) > time()) { // expired } If you have paid date as a timestamp: if(strtotime(“+3 years”, $paidDate) > time()) { // expired } 3 solved PHP DateTime, paid date + a year term [duplicate]
Your question is not clear, but it may be useful to you. You can iterate over php cookie array and insert it in your table. foreach($_COOKIE as $name => $cookie){ // you can check any conditions based on cookie name $name $query1 = “INSERT INTO table_name(field_name) VALUES(” . mysql_escape_string($cookie) . “)”; mysql_query($query1); unset($query1); } 3 … Read more
Yes, it is possible. To do this, you need to use AJAX. Here is a beginners tutorial: http://www.tizag.com/ajaxTutorial/ After you read up on that, and understand the basics (if you don’t know javascript, you may want to look into some more tutorials), you can move on to jQuery(a Javascript framework). You can use jQuery.ajax() for … Read more
You might want to start with database answers. This is a large collection of database models, offered for free. Many of them have no implementation alonmg with them, so they are just a starting point for a do it yourself project. But the author has done a lot of work clarifying the problem. I don’t … Read more
The included file is not behaving as you expect it to. To pull this off you will have to create a global out of the variable (but don’t do it!). You can print_r() the array in the controller, because you’re fetching it from the model. But after that you include the view. When you place … Read more
Use it this way: SELECT * FROM `user_post` WHERE `id` NOT IN ( SELECT `post_id` FROM `hide_post` WHERE `user_id` = ‘{$userID}’ AND `status` = ‘hide’ ) Here the {$userID} should be the current logged in User’s ID. 7 solved dont show hide post which user had hide that post
if you mean bulk insert, please follow the example given below. CREATE TABLE example ( example_id INT NOT NULL, name VARCHAR( 50 ) NOT NULL, value VARCHAR( 50 ) NOT NULL, other_value VARCHAR( 50 ) NOT NULL ) INSERT INTO example VALUES (100, ‘Name 1’, ‘Value 1’, ‘Other 1’), (101, ‘Name 2’, ‘Value 2’, ‘Other … Read more
The only way I see this really would’t work, is if you’ve mistyped the name of the column ‘title’ (if the second query you wrote works) The assumptions about the case sensitivity are wrong, since the second query returns something, the first should return at least the same rows as the second one In MySQL … Read more
It’s not entirely clear what you mean by “in the past 5 days“, but something along the following lines should do the trick: SELECT COUNT(DISTINCT IDENT) FROM PS_LOGIN_LOG WHERE USER = ‘someuser’ AND TIME >= CURRENT_DATE – INTERVAL 5 DAY AND TIME < CURRENT_DATE + INTERVAL 1 DAY 0 solved Yet Another SQL Query
It is all about primary key AND foreign key. If you want to add a record with an id, that must exist in another table, it is a foreign key. If you don’t want this you can do the following: conn = getConnection(); String query = “SELECT EXISTS(SELECT NULL FROM my_table WHERE number = ? … Read more
You can accomplish the same with UPDATE query UPDATE tablename SET points = points + 5 WHERE email=”your_email_here” solved adding “5” to INT [closed]
how to write a stored procedure for adding the values in the table when we have two or more values for the same data in stored procedure MSSQl solved how to write a stored procedure for adding the values in the table when we have two or more values for the same data in stored … Read more
U can use this: mysqldump -u username -p databasename > filename.sql to export mysql -u username -p databasename < filename.sql to import 4 solved how to create mysql database backup file in windows [closed]
Try to change the mysql_query to show errors meaningfully: mysql_query($sql, $sql_connection) or die(mysql_error() . “<br/>Query was: ” . $sql); If you have an error, it will stop execution and you will see both the error and the query that was attempted to be executed. 1 solved Why is my PHP is not inserting data into … Read more