PHP - MySQL

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

  1. » JanMolendijk
    Dear admin i`m back again with an question
    I wanna use your file upload script

    sets maximum file size allowed (in KB). Is it posible to use...
    Last post » Admin
    I not have experience with hosting and server settings; but you can try to change those settings in php.ini and see if it works.
    - After you make...


  2. » JanMolendijk
    Dear Admin i`m back again with something new...
    How can i show into a php document text from an text-file ?

    i have this code into the text file...
    Last post » Admin
    Hello,
    You can use file_get_contents() to get a string with file data.
    Then, with explode() you can split that string by the separator you want,...


  3. » chill
    Hi Admin,
    I try to use more than one session field into a single string, it does not work. I have tried:
    $_SESSION $_SESSION $_SESSION and...
    Last post » Admin
    Better put here that part of code.
    Maybe not all those sessions are set.


  4. » melmdoost
    hi,
    i am using a query look like this:
    xxx.com/search.myskils.php?id=157

    this address xxx.com/search.php send an id number to...
    Last post » Admin
    In this case you have to make safety the Insert, Update, Delete data in database.
    1. You can add a login admin script that sets a Session with...


  5. » JanMolendijk
    Well here i`m again... I wanna use this script

    Now i try with an id (int) into this script

    <?php
    include('connection.php');

    $id = (int)...
    Last post » JanMolendijk
    I got one question i try to ad for the upload more extensions like avi or mp3
    but when i put this i get the error The file: 03.avi not has the...


  6. » JanMolendijk
    I have a rating script where new people able to rate from 1 till 5.
    Now i have this simple code what shows the total number of rates:
    <?php...
    Last post » JanMolendijk
    Thank you so mutch Admin great work


  7. » JanMolendijk
    I think i search wrong on google & after few hours i quited.
    My question how do i make a simple calculator in php code like:
    1 + 1
    2 - 1
    2 / 1...
    Last post » Admin
    Hello,
    See the script from this page:


  8. » mlucicom
    Hi Admin!
    I have a php code that select values from database but this return 500 error when i execute

    <!DOCTYPE html>
    <html lang= en...
    Last post » Admin
    Hello,
    That problem is not from that script, generally the 500 error is from server problems or from some code in .htaccess file.


  9. » melmdoost
    hello,
    i have a problem with this code:
    if(isset($_POST ))
    {
    $txt_login= mysqli_real_escape_string($con,$_POST );
    $txt_pass=...
    Last post » melmdoost
    thank you for your help.
    i can find this problem!
    it was a space line in user_password=' $hashed_password' in register code.
    all of the passwords...


  10. » mlucicom
    Hello,
    have you any ideea how this work in html without <?php ?> tags?
    <div class= modal-title...
    Last post » Admin
    - The form of the code that you posted it can work with a template system, like php Smarty, which must be included and configured in your php script....


  11. » mlucicom
    Hello..i have a php social network loveparadyse.com.
    and this is the class for add users to database:

    function query() {...
    Last post » Admin
    If it is inserted 'no_ref' it means that the $_GET is False (not in the address that accesses the file) or its value is deleted by other code in that...


  12. » JanMolendijk
    Dear admin i try for few hours to find out how i can get an id into my code
    <?php for($i = (0); $i<sizeof($i);$i++){ ?>
    - $i = (0); the 0...
    Last post » JanMolendijk
    i tried many things but i get no results


  13. » JanMolendijk
    I`m buissy with an simple upload script, every member have a own folder for pictures on my server.
    Now i try to add a echo variable but getting a...
    Last post » Admin
    Thanks for your intention, but I not need donation.
    I'm thankful with my peace.


  14. » JanMolendijk
    Dear admin i `m thankfully for your support `just great`.
    With both examples for <input type= text > it shows only string(13) but not the...
    Last post » JanMolendijk
    Thank you so mutch stupido me i had to use: <?php echo $ip; ?>


  15. » JanMolendijk
    I wanna add an ip-adress into an notice script.
    This code is working on a hosting server, but not in a script on my XAMPP-home-server
    <? echo...
    Last post » Admin
    I Not know what the problem is.
    What value it is returned by $_SERVER ?
    Try this code to see what exactly it contains:
    var_dump($_SERVER );
    - Try...


  16. » JanMolendijk
    My next problem when i use this code i getting one record from user=' anonymous@hotmail.com '
    but i would like to have all the records what is...
    Last post » Admin
    Hello,
    You have to use a while() loop to traverse the rows returned in the result set.
    $sql=mysqli_query($conn, SELECT * FROM `notice` WHERE...


  17. » JanMolendijk
    Daily i have problems with my work today my problem is...

    I try to build a Notification Popup i have for this a script what seems to work
    but...
    Last post » JanMolendijk
    Dear admin thanks for the support... But when i add your code i getting the number off all results.
    I have two users... 1 user have one result, the...


  18. » JanMolendijk
    I need your help again i cant find out how to select a specific id to show
    i have this address:...
    Last post » JanMolendijk
    After day working i finaly found it out.
    i added this code:
    $id = (int) $_GET ;
    $sql = $conn->query( select * from user where id=$id );


  19. » mlucicom
    i have two php files:

    the index.php ---

    <?php
    $id = 3 ;
    if(!empty($_POST )) {
    $conn = mysql_connect( localhost , website_rent , password...
    Last post » Admin
    I not know way it not works; maybe data from the resulted sql query is not ok for that mysql table structure.
    If there is no message with errors,...


  20. » JanMolendijk
    I have this database for my comments
    Now i wanna count the comments from citem
    c66u_nucleus_comment

    Type Collatie Attributen
    1 cnumber int(11)
    2...
    Last post » Admin
    Hello,
    1. This is the syntax that you can use to sum numeric values from a column into a mysql table:
    SELECT SUM(col_name) AS snr FROM table_name...


  21. » JanMolendijk
    Now i have my next problem & can`t find out what i must do to complete.
    I have three mysql tables:
    user
    Type Collatie Attributen Leeg...
    Last post » Admin
    Hello
    Try with this code (see the relations with the IDs between tables):
    $sql = SELECT A.`user_firstname`, A.`user_lastname`, B.`mem_id`,...


  22. » JanMolendijk
    I looking for a example how to select data from two data-bases

    i have a table group with: group_id, club_id & member_id
    i have a table user...
    Last post » JanMolendijk
    I tried this morning a view thinks & had result just before your posting
    Great support Admin thanks i`m view day`s buissy to find out how tables...


  23. » Ja42la
    Error: Apache shutdown unexpectedly.
    8:59:36 AM This may be due to a blocked port, missing dependencies,
    8:59:36 AM improper privileges, a crash, or...
    Last post » Admin
    Hello
    Not sure what the problem is, from what the error message says, it is possible that another application runs on the port set for Apache, or...


  24. » Admin
    - If you want to do multiple COUNT(), in multiple tables, and output them in a single SELECT statement with each COUNT being a column; you can use a...


  25. » melmdoost
    I have a question. it is my last question.
    i use persian name in file name.
    when i upload a file (with persian name) and move it to upload folder,...
    Last post » Admin
    - Or, in the same approach you can encode /decode the file name with base64:
    1. When uploading the file, apply base64_encode() to name (without...