PHP - MySQL

  1. PHP Alphanumeric RegExp with letter from any language 1336 1

    » Marius
    I am trying to write a Regular Expression that makes sure the characters are all Alpha Numeric, and that accepts other characters as well. I would...
    Last post » MarPlo
    Hi,
    Your regex ^ *$ won't match the accented characters. That is \w would match only the English alphabets, digits 0-9 plus the underscore symbol....

  2. MySQL - Select data in current day, week, month or year 1219 1

    » Marius
    I facing a problem about a select query in MySQL.
    I have table user, It contains id_user, username and user_time. And user_time is a Date-Time for...
    Last post » Admin
    Hi,
    YEAR returns a number like 2015. That will never be equal to a time. You need to test whether the year of user_time is the same as the given...

  3. Delete rows with duplicate column value in MySQL 1230 1

    » Marius
    I have a table with the following columns: id | url | title | company .
    Now, I need to delete rows having same url and title.
    I want to know if...
    Last post » Admin
    An easy way to do this is to add a UNIQUE index on the columns with duplicate values, using the ALTER statement.
    When you write the ALTER statement,...

  4. How to order by FIELD with GROUP BY 66179 1

    » Marius
    I have SQL a query like this:
    SELECT c.type, SUM( u.account )
    FROM contracts c, u_data u
    WHERE c.user_id = u.id
    GROUP BY c.type;
    Now this gives me...
    Last post » Admin
    Hi,
    You just have the wrong order for GROUP BY and ORDER BY.
    ORDER BY should be added after GROUP BY.
    ...
    GROUP BY c.type;
    ORDER BY FIELD( c.type,...

  5. Store an Array in MySQL table column and use it in PHP 1339 1

    » Marius
    Hi
    I have an array in php:
    $arr = array(3, 'value 1', 'other value');
    And a mysql table with these columns: id | name | data
    I want to store...
    Last post » Admin
    Hi
    You can store an array in a database into a string with JSON format.
    Use json_encode() when you want to insert the array. For example:...

  6. SELECTING WHERE ID from array in a php-mysql query 5117 1

    » Marius
    I'm trying to SELECT from a PHP array inside a mysql query.
    $sql = SELECT * FROM table WHERE id = $ids ;
    $ids has been created by $_POST and...
    Last post » Admin
    Try with IN with implode of the array $id like:
    $sql = SELECT * FROM table WHERE id IN ( . implode(',', $ids) . ) ;
    - Make sure that $ids is an...

  7. Comparing date with today date using strtotime 1252 1

    » Marius
    I've written following code to compare a date in a variable with today's date. If the date in a variable is greater than today's date the error...
    Last post » Admin
    You may be meaning 11th Decemeber with 12-11-2014, but strtotime isn't seeing it that way.
    If you need to use strtotime() then change the input...

  8. Get values of one MySQL table that are not in other table 1240 1

    » Marius
    Hello,
    I have two tables: A and B. I need to compare their columns to get values of one table that are not in other table.
    Table A columns : ID,...
    Last post » Admin
    Hi,
    You can use not in :
    SELECT *
    FROM table_A
    WHERE table_id NOT IN (SELECT id from table_B)

  9. Insert date after X days added to now() function in mysql 1395 1

    » Marius
    I have a subscription system in my website. When the users subscribe, their start date and time is added in mysql table using now() function.
    I also...
    Last post » Admin
    The date_add() function is what you're looking for:
    DATE_ADD(date,INTERVAL expr unit)
    Example
    INSERT INTO users
    (username, registration_date,...

  10. INSERT IGNORE vs INSERT ... ON DUPLICATE KEY UPDATE 1938 1

    » Marius
    While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise cause failure. After some research, my...
    Last post » Admin
    Hi,
    If you just want to skip rows with duplicate values, and no update needed, I think that is proper to use INSERT IGNORE .
    If you use INSERT...

  11. Select one row in MySQL with both AND, OR statements 1723 1

    » Marius
    Hello,
    I have this Select query, I want to select one row from mysql table, where id = $id, and has x_name or y_name 'yes'.
    $insert_cat =...
    Last post » Admin
    Hi
    The problem is that you didn't separate the conditions with the OR from the id=$id, so to select just the row which has that $id AND 'yes' in any...

  12. Returning JSON from a PHP Script 1287 1

    » Marius
    Hi
    I have this array, and I want to return it as JSON from a PHP script.
    $ar = array(
    'k0'=> array('a', 'b', 'c'),
    'k1'=> array(1, 2, 3)
    );...
    Last post » MarPlo
    Hi,
    Use json_encode() to encode the data and set the content-type with header('Content-type: application/json');
    Anyway, it works fine if you just...

  13. Check the common elements of two arrays 1371 1

    » Marius
    Hi
    I have two arrays $a1 and $a2 with various elements.
    How can I check which item from $a2 is in $a1? Is there any function, or I have to traverse...
    Last post » Admin
    Hi,
    The array_intersect($a2, $a1) function returns the elements of $a2 which are found in $a1.
    Also, with the in_array() function you can check if...

  14. How do I SELECT same column name from multiple tables 4976 1

    » Marius
    I have 2 tables with same column names in my database which are supposed to provide content in 2 languages.
    This is how I query for one table (this...
    Last post » MarPlo
    The mysql is confused when you select columns with same name. The solution is to use Alias ( AS ).
    $sql = SELECT en.col1 AS c1en, en.col2 AS c2en,...

  15. Displaying the elapsed time 1272 1

    » Marius
    Hi
    Does anyone has a php code to display the elapsed time?
    Like: one hour ago, 1 day and 3 hours ago, ...
    Thank you.
    Last post » Admin
    Hi
    You can use the timeElapsed() function, from this example:
    function timeElapsed($t1, $t2 = null) {
    /*...

  16. MySQL Timestamp appears as DateTime 1231 1

    » Marius
    Why in my database, time is of type Timestamp but has no numeric form: 1402008961, but is of the form: 07/25/2014 12:13:45 ?
    Last post » MarPlo
    Hello
    Timestamp in MySQL is different from Unix Timestamp, which as you know is a number of seconds starting from 1970.
    Timestamp in MySQL is...

Forum permissions

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum