PHP - MySQL

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

  1. » mluci12
    I use mysql Inner join with php for a select from two data tables.But the resuts are duplicated because in one table i have more results with that...
    Last post » Admin
    The group_concat() is not for file, it is a mysql function that returns a string with concatenated non-NULL value from a group of rows (separated by...


  2. » mluci12
    How can i display the selected mysql row into html table cells?
    Last post » Admin
    See the tutorial from:
    - Or search on the net for: mysql select in html table .


  3. » Admin
    This php script can be used to print a MySQL table data to HTML table.

    $conn = new mysqli('localhost', 'root', 'password', 'dbname');...


  4. » mluci12
    How can i rename file with current date ( month/years/minute/secondes.file_extension ) in the code from:
    Last post » Admin
    Try to use the code from this example:
    $fname ='file-name.ext';

    $set_name = date('Y-m-d-H-i-s');
    $fname = preg_replace('/(.+?)\.( +)$/i', $set_name...


  5. » JanMolendijk
    I have this code to update one from your scripts
    But if i select the option Other it does not stay in de admin on this same line
    I hope you could...
    Last post » JanMolendijk
    Thank you Admin for the support


  6. » JanMolendijk
    I wanna use this code but only a single row, do you known how to select it ?

    // SELECT sql query
    $sql = SELECT `id`, `name`, `pass` FROM `users` ;
    Last post » JanMolendijk
    I found the answer i have to do this
    // SELECT sql query
    $sql = SELECT `user_longbio`, `user_id` FROM `user` WHERE `user_id`='10000' ;


  7. » JanMolendijk
    I run two different scripts for both i have an log-in system.
    But how can i make an register for two data-bases ?
    Last post » JanMolendijk
    ok thank you for the answer i gonna try some things


  8. » JanMolendijk
    I hope you could help me out with this problem

    <?php
    session_start();
    include_once 'dbconnect.php';

    if(!$mid){
    $query = mysqli_query( SELECT *...
    Last post » Admin
    Hello
    You have to the object with the mysqli connection:
    $query = $conn->query( ... );
    //OR:
    $query = mysqli_query( ... , $conn);


  9. » JanMolendijk
    How can i give users an php webpage into a map on my server when they register ?
    Last post » JanMolendijk
    My explain is meight bit pity so i try again
    I found this script

    But now i wanna create an php file on my server
    with data when users...


  10. » JanMolendijk
    I wanna add text into an textarea where i have html code into the title but it does not show the whole html code into the textarea.
    Title:...
    Last post » Admin
    In <textarea> you not have to add data in value attribute, but between starting and ending tags.
    Try simple like this:
    Title: <textarea...


  11. » JanMolendijk
    I wanna Delete records from a database, but i want to choose what record i delete into an text-area with delete-button
    (i where able to find this...
    Last post » JanMolendijk
    You doing Great Work `thanks for the support`

    & also thanks to coursesweb.net i have
    this Web-Site:


  12. » JanMolendijk
    First thing it stay`s an great website
    i learning alot & i`m thankfully.
    I getting this error & ask myself what is wrong
    Deprecated:...
    Last post » Admin
    Hello,
    Welcome to this website.
    It seems you use an old php script, which uses the mysql_connect() function for working with mysql database.
    That...


  13. » JanMolendijk
    First great website i learning alot `thanks for this`

    My Question:
    I did not found an example how to add text into the SQLdatabase from a...
    Last post » JanMolendijk
    thanks for the quick answer you all do greatest work
    i gonna try this code hope i`m able to complete


  14. » Waylon
    Hi:
    I am using this script to insert data from a Form into a Database. I am new to PHP and trying to learn. However, after 3 days of banging my head...
    Last post » Admin
    A documentation complete about Strings and Quotes in php you can find to this page: PHP Strings (in the php manual from php.net).
    - Or, you can find...


  15. » mluci12
    Hello!i have this page: autobelgia.ro/listings.html and database:
    Id | content | type
    How can i order database results after select ? First display...
    Last post » Admin
    Hi,
    I don't know.
    If there is a php-mysql issue, put the php and mysql code that you use to make and output Selecting data.


  16. » mluci12
    Please help me! I have this code but don't redirect to submit2.WHY?
    <!DOCTYPE html>
    <?php
    require('layout-submit1.php');...
    Last post » Admin
    Hello,
    The code mysql_query($sql, $conn) is incorrect. Maybe the script it uses MySQLi; in this case you should put: $conn->query($sql) .
    Also,...


  17. » mluci12
    Hello!
    I have page: autobelgia.ro/submit1.html from to: autobelgia.ro/submit5.html from autobelgia.ro/submit1.html to submit5.html user complete...
    Last post » Admin
    Hello,
    If the second page is just a simple html document (without php code), to keep data from one page to another html page you can use JavaScript...


  18. » mluci12
    Hello!
    I created a blog but I have problem with Romanian characters: autobelgia.ro/article.php?id=7
    Last post » Admin
    Hello
    I see no problem with characters in that page. The romanian characters, diacritics, are displayed well.
    Copied from that page:
    mașină...


  19. » mluci12
    <?php
    require('layout.php');
    $servername = ;
    $username = ;
    $password = ;
    $dbname = ;

    // Create connection
    $conn = new mysqli($servername,...
    Last post » mluci12
    Thank you very very much!!!!!!


  20. » mluci12
    Hello!
    i have a page create.php/id=xx
    I have a Database like
    Id--quiz---answer1--answer2-answer3
    I want to put all this quiz on page...
    Last post » Admin
    Forgive me, I have no wish for more ideeas; just Peace.
    Try to accept you,
    And see, what is your truly wish?

    When all here is a virtual...


  21. » mluci12
    Hello
    I have this file upload script and Mysql& PHP insert in database.Why don't work file upload?
    <?php require('includes/config.php');...
    Last post » Admin
    Maybe the : in the array keys is wrong.
    Try this, make sure you have the filename column in the members table; and check for $db /$stmt error....


  22. » mluci12
    Hello!
    When i create PHP apps i create link like domain.com/page?variable=&variable2 , but this is not seo friendly.
    How can i make link like:...
    Last post » Admin
    Hi,
    You can create friendly seo links with mod_rewrite in the .htaccess file.
    For example:
    Options +FollowSymLinks
    RewriteEngine On

    RewriteRule...


  23. » mluci12
    Hello!
    I have a linux server with custom api.I make a php script who check if user pay invoce.How can i make this script acces a link if he return...
    Last post » Admin
    Hi
    If you want to open /redirect to a page address when a condition is True in php, you can use the header() function; like in this example:...


  24. » mluci12
    Hello!I have this php asp(mluci.com/d/cont.php).If users press Bookmark burton he is redirected to a page like(mluci.com/d/bookmark&id=Xx) where...
    Last post » Admin
    Hi
    You can send data to php without page refresh using Ajax. You can learn it from the: , or you can search on intenet for: ajax tutorial .
    - For...


  25. » mluci12
    How can i create a %Like select where variable is a php variable.
    Last post » Admin
    Simple, like this:
    $varnm ='value';
    $sql =  SELECT * FROM table_name WHERE col_1 LIKE '%$varnm' OR col_2 LIKE '%$varnm' ;