PHP - MySQL


  1. » mlucicom
    Hello, i have a JSON response from an api that is like this: mluci.com/script.php
    I tried to transform this to an array but i can't foreach this.For...
    Last post » mlucicom
    I resolved with this thank you:
    I changed the code but this send only an api request :
    <?php
    $servername = localhost ;
    $username = mluci_api ;...


  2. » JanMolendijk
    I have a little script to detect if a member is placed in database
    but I dont understand how to detect $row in javascript

    also I don`t known how...
    Last post » Admin
    I think that in the controller.php file you must call the searchData() method with data from the js ajax.
    Something like this:
    echo...


  3. » JanMolendijk
    I`m back again found a solution on the question before thanks for that
    |My new problem I try to detect # hash with a id

    like this url example but...
    Last post » JanMolendijk
    I tested it again &nd it seems like to work now `thanks for supporting`


  4. » JanMolendijk
    I`m busy for a few hours to add a function in my comment system
    this comment-system post comments is without page-refresh

    Only I can`t find out...
    Last post » Admin
    According to your script, each form must have its own submit button.


  5. » JanMolendijk
    Chief I have a problem to get the countrycode into my sql-statement.

    Please help me out....

    This script is to detect the countrycode...
    Last post » Admin
    The JavaScript code cannot be executed in php.
    Javascript is executed in browser, after the php finished to output its data.
    Also, Javascript it is...


  6. » JanMolendijk
    Chef hope you do fine.... I readed many documents about PDO insert into, mostly with the function where not exists.

    I tried also some things into...
    Last post » Admin
    The query: Insert into ... where not exists ... is used when you want to insert something in database when a specified data not exists in that table....


  7. » JanMolendijk
    My SQL-database was stolen on monday-morning they ask 0.05 Bitcoin to send it back :D
    When I readed it I had to laugh because I have backups &...
    Last post » Admin
    Hello,
    I think the problem is not from XAMPP, but from the php script you made and run on your server.
    It is possible that your database was stolen...


  8. » JanMolendijk
    I have a simple script to show the visited url
    but from my sql table I would like to display only the 'tag=variables', not id= or other...
    Last post » JanMolendijk
    Thank you so mutch `thanks thanks thanks` working in once


  9. » JanMolendijk
    I try to add this script to build a energy-low-mode dark-mode
    But It only succeed with one item but I would like to have it with all items 6 rows...
    Last post » JanMolendijk
    I apologize the script is a bit too big, and it's only 1 item I don't get fixed but I'll leave it that way .... Thanks for the feedback


  10. » JanMolendijk
    I found a script from: tutorialzine.com/2014/09/cute-file-browser-jquery-ajax-php
    what I wanna use for my website.

    But I can`t find out how to...
    Last post » JanMolendijk
    Thanks Chief for the support `it is working now`


  11. » Marius
    I have this string: 'mr (3_22) mrs (1_12) miss (2_4)'
    I want php to output that string to: (3_22)(1_12)(2_4)
    How can i do that with php?
    Last post » Admin
    You can use preg_match_all() . Try the following code:

    $str ='mr (3_22) mrs (1_12) miss (2_4)';
    $re ='';
    if(preg_match_all('/(\( +\))/i', $str,...


  12. » JanMolendijk
    I`m building a hashtag system but now recently I getting some nasty spam
    How can I add simply a filter to protect it ????

    <?php
    //if hashtag...
    Last post » Admin
    Sorry, i not understand.
    What nasty spam do you refer?
    Where or to what do you want to add filter?
    What do you want to protect?
    Do you want an...


  13. » JanMolendijk
    I'm sorry to interrupt, I've been trying to ask a question on stackoverflow for an hour but I can not figure it out because they've changed their...
    Last post » Admin
    Here is an example that gets the url address and #hashtag:

    $url ='some_domai.net/dir/page#hashtag';
    $ar_u =[];
    if(preg_match('/( +)( {0,1} *)/i',...


  14. » JanMolendijk
    I prefer not to bother you too often but because of my bad English, two accounts have already been blocked on stack overflow.
    And I think you are...
    Last post » Admin
    Try this:
    - At the beginning of your php script, for example at the beginning of the configuration.php file add the header function for utf-8...


  15. » JanMolendijk
    Without real knowledge the gambling remains & questions arise
    & without the support from Coursesweb it is checkmate for me :D

    I found a...
    Last post » JanMolendijk
    I found the answer:

    // SELECT sql query
    $sql = SELECT * FROM `user` ORDER BY `id` DESC ;

    // perform the query and store the result
    $result =...


  16. » JanMolendijk
    Well I have some new problem I`m rebuilding a comment system
    & succesfully placed it as Iframe addon but for the smilies I want
    to use a...
    Last post » Admin
    The content from iframe cannot be displayed outside it.
    To display the menu it the parent window, it must be created in that page.
    From iframe you...


  17. » JanMolendijk
    Well some new problem. I have a simple code to convert timestamp so it`s able to read.

    timestamp 1537939165

    <?php echo date(DATE_RFC822,...
    Last post » Admin
    Since the type of the timestamp column is INT(11), you not need to apply the UNIX_TIMESTAMP() function (which is used for DateTime type).
    Try the...


  18. » JanMolendijk
    Dear admin hope you do okey ???

    I looking for php code like I can do here with option
    to show it on my website ???? so i`m also able to see...
    Last post » JanMolendijk
    Thanks Chief

    You told me once that you do not judge,
    but sometimes I wonder what you think
    of my knowledge :D ????


  19. » JanMolendijk
    I have a little script that have a Previous & Next button.
    My problem is I want to detect & place the ID in those buttons

    this is the...
    Last post » Admin
    Sorry, I not understand your code, not know what it is not working.
    Where in the pagination you add $row ?
    Do you get any error, or what value the...


  20. » JanMolendijk
    I`m searching for few hours now but can`t find a solution to link to a part off a page ??? I try to use this...

    In one comment-page I have this...
    Last post » JanMolendijk
    It is strange I tried alot things nothing working correctly.
    Meight my Question is wrong, Because I try from a page a link to another page but the...


  21. » Marius
    How can I remove a parameter from URL query, and display the query string without the removed parameter?
    For example, i have this URL:...
    Last post » Admin
    You can use the queryToArray() function from the following example to make an array from URL query parameters.
    With unset() remove the parameter you...


  22. » Marius
    Hello,
    How can I concatenate the value of a string in the replace() statement in mysql?

    For example, in the 'content' column i have something...
    Last post » Admin
    Hi,
    You can use the concat() function in the replace() statement.
    REPLACE(col_name, concat('string', col_2, 'join-string'), 'new_value')
    - Here...


  23. » JanMolendijk
    I have a problem it does not register all IP-addresses from the visitors with a Unique Key made from their IP-address.
    I see also that some visitors...
    Last post » JanMolendijk
    I let go of my imagination, and tried with loading of iframes, but then it did not register either...

    After that I changed my code into this, I...


  24. » JanMolendijk
    My next problem... I want to insert into my data-base & detect if the record allready exists
    when the record allready exists i don`t want to...
    Last post » Admin
    You can use INSERT ... ON DUPLICATE KEY UPDATE to Insert record if not exist.
    The sql column for that record must be set as UNIQUE index or PRIMARY...


  25. » JanMolendijk
    Dear admin i cant get the specivic id in my vex-modal script detected
    i hope i can open multiply iframes in my script

    $sql = SELECT * FROM...
    Last post » Admin
    Try this in your script (i cant test it, so, if you get errors try to fix what you know and post errors here):
    foreach ($results as $res) {
    echo...