PHP - MySQL

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

  1. » PloMar
    I have the following object in php:
    $ob  =  new stdClass ; $ob -> name  =   'some-name' ; $ob -> email  =   'email-address' ; $ob -> site ...
    Last post » Admin
    Hi,
    Just use the: (array) $objectName construction.
    $ob  = new  stdClass ; $ob -> name  =  'some-name' ; $ob ->...


  2. » PloMar
    Hello,
    I have a script that the user can upload and delete images on server. The issue I am running into is that when the user changes his image on...
    Last post » Admin
    Hi,
    The simpliest way to force a refresh /reload of that image after upload is to add an unique " ?hash " to the URL /SRC adress...


  3. » Marius
    Hi,
    I have this php exercise:
    - Calculate the final sum of the digits of a number, till get a number with one digit.
    For example:
    $nr = 458;
    // the...
    Last post » sandy
    Another example with a recursive function:
    <?php function add ( $nr )   {   $nr  =  array_sum ( str_split ( $nr ));   if ( strlen ( $nr )   ==  1...


  4. » PloMar
    Hello,
    I have the following method to update data in MySQL table.
    public function update ( $table ,  $rows ){   foreach ( $rows as $k  =>  $v )  ...
    Last post » Admin
    Hi,
    Try this code:
    public function update ( $table ,  $rows ){   $set  =   [];   foreach ( $rows as $k  =>  $v )   {     $set []...


  5. » Marius
    Hi
    I have a table in mysql database, with 3 columns: id | title | description .
    The id column is INT AUTO_INCREMENT .
    Does anyone know how to select...
    Last post » sandy
    Hi,
    If you're using PDO, use PDO::lastInsertId();// To Display the last Inserted value
    If you're using MySql, use mysql_insert_id();// To Display the...


  6. » PloMar
    Hi,
    I have the following code that uses DOMDocument to get some data from a html string in PHP.
    // string with HTML content $strhtml  =  ...
    Last post » MarPlo
    Hi,
    The nodeValue attribute gives you the combined text of all the child nodes.
    To get the text value of the first child text node only, use:...


  7. » PloMar
    I wrote a PHP code to insert some data in to MySQL database. I want to display a message indicating whether the records are successfully added to the...
    Last post » sandy
    try {        $db_user  =  'root' ;           ...


  8. » 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.
    Using...


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


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


  11. » 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"....
    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',...


  12. » 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 (...


  13. » 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 ...' ;...


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


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


  16. » 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 [ 'REQUEST_METHOD' ]; echo $request ; if( $request  ===   'GET' )   {    // ... }...


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


  18. » MarPlo
    What is the best way to validate an email address in PHP?
    I currently use preg_match() with a RegExp:
    $email  = ...
    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  = ...


  19. » 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 '[\£\$\%\^\&\*\?]'


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


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

    // check login data received from...
    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...


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


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


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


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