PHP - MySQL

Discuss coding issues, and scripts related to PHP and MySQL.

  1. » PloMar
    Hello,
    I have the following code that saves on the server a png image generated with php.
    In that image I add a text (using imagettftext()), but...
    Last post » MarPlo
    Hi,
    You can use the imagettfbbox() function, it returns an array with 8 elements representing four points making the bounding box of the text....


  2. » PloMar
    Hello,
    How can I save the content of the current php page into a html file, only after a form is submitted?
    For example, I have the following code...
    Last post » MarPlo
    If you want to save the page content after a form is submitted, another way is to add the page code into a hidden field in that form, with JavaScript...


  3. » PloMar
    I have the following Select in MySQL:
    $sql = SELECT * FROM table_1 WHERE rank = 2 AND id IN(2, 5, 8) ;
    But the IDs (2, 5, 8, ...) must be from a...
    Last post » MarPlo
    You can use multiple Select statements in the same SQL query.
    Try this query, using a sub-select that selects the IDs.
    $sql = SELECT * FROM table_1...


  4. » PloMar
    I have two text fields, one for the date in 08/21/2012 format and a second field containing the time in the format 09:41am .
    How can I end up...
    Last post » MarPlo
    On the database side, you can use:
    - STR_TO_DATE() to convert into a database friendly format.
    SELECT STR_TO_DATE(CONCAT('08/21/2012', '09:41am'),...


  5. » PloMar
    I want to insert a DateTime object in database (created in PHP) where the column type is DateTime. How can I do?
    I am using this code:
    $cdate = new...
    Last post » MarPlo
    Use the Y-m-d H:i:s date-time format in PHP, it is the format of the DateTime column in MySQL.
    $cdate = new DateTime('now');...


  6. » PloMar
    Hello
    How can I replace the new lines with a single space in a string in PHP?
    For example I have this $str variable with a string content with...
    Last post » Admin
    You can use str_replace() with PHP_EOL.
    Example:
    $str = 'First line
    Second row
    Other line ...';
    $str = str_replace(PHP_EOL, ' ', $str);
    echo $str; ...


  7. » PloMar
    What's the best way to delete a directory with all its files in it?
    I'm using rmdir(PATH . '/' . $value); to delete a folder, however, if there are...
    Last post » Admin
    This function will allow you to delete any folder (as long as it's writable) and it's files and subdirectories:
    function deleteDir($path) {...


  8. » PloMar
    I try to parse a JSON file using PHP. The data in this JSON is in a two-dimensional object, like this:
    {
    John : {
    status : Wait
    },
    Jennifer :...
    Last post » Admin
    To iterate over a multidimensional array, you can use RecursiveArrayIterator.
    $string = file_get_contents('/dir/test.json');...


  9. » MarPlo
    How can I detect which request type was used (GET, POST, PUT or DELETE) in a php script?
    Last post » Admin
    Simple use $_SERVER .
    $request = $_SERVER ;
    echo $request;

    if($request === 'GET') {
      // ...
    }
    else if($request === 'POST') {
      // ...
    }...


  10. » MarPlo
    I have a PHP array as follows:
    $aray = array(312, 'string', 1599, 'other val');
    $del_val = 1599; 
    I want to delete the element containing the value...
    Last post » Admin
    You can use array_search() and unset(), like in this example:
    $aray = array(312, 'string', 1599, 'other val');
    $del_val = 1599;...


  11. » MarPlo
    What is the best way to validate an email address in PHP?
    I currently use preg_match() with a RegExp:
    $email = 'some_name@domain.com';...
    Last post » Admin
    The easiest and safest way to check whether an email address is well-formed is to use the filter_var() function:
    $email = 'some_name@domain.com';...


  12. » MarPlo
    I am trying to select all rows from a table where column contains a character from a list: Something like:
    SELECT * FROM table WHERE column...
    Last post » Admin
    Try with REGEXP, and escape everything with backslash. Result: .
    SQL:
    SELECT * FROM table WHERE column REGEXP ' '


  13. » MarPlo
    I want to search in mysql database with columns containing some specified names and the column has values like:
    Varsus GmbH (default)
    Varsus...
    Last post » Admin
    Try this Select:
    SELECT * FROM table WHERE
    suppliername = 'Varsus'
    OR (
    suppliername LIKE '%Varsus%'
    AND suppliername LIKE '%default%'
    )
    - The...


  14. » MarPlo
    In login.php it is set a session ID for the logged user. Something simple:
    <?php
    session_start();

    // check login data received from a form .....
    Last post » Admin
    Store a timestamp in the session.
    In login.php , register a session with the expired timestamp (when you want to expire that session) in the same...


  15. » MarPlo
    Hello,
    I have two array one is 1 to 8 number of cards and four colors of cards.
    $no = array(1, 2, 3, 4, 5, 6, 7, 8);...
    Last post » Admin
    Hi,
    Use nested foreach() loops:
    $no = array(1, 2, 3, 4, 5, 6, 7, 8);
    $color = array('K','L','F','C');
    $result = array();
    foreach ($no as $n) {...


  16. » 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....


  17. » 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...


  18. » 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,...


  19. » 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,...


  20. » 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:...


  21. » 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...


  22. » 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...


  23. » 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)


  24. » 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,...


  25. » 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...