/    Sign up×
Community /Pin to ProfileBookmark

What To Learn During PHP Pagination Tutorial ?

Copy linkTweet thisAlerts:
Sep 29.2019

PHP Gurus,

Q1.
What is old technology that I must not learn in PHP and what is new in PHP which I must learn when it comes to building webpages dealing with Mysql database ?
I must know these answers so I do not waste time learning old stuffs.
For example, had I known that Mysqli extension is old stuff along with prepared statements and pdo is new substitute then I never would have bothered the former. Can’t afford to waste time like this anymore.

I believe to build pages that read, write, edit, delete to/from Mysql databases, I must learn:

  • * PDO

  • * jQuery

  • * Mobile Responsive coding

  • * CRUD

  • * REST API

  • * jSON
    What else must I learn ?

    • Q2.
    Now, what must I avoid learning ?
    Here is my list, can you add to it ?

  • * Mysql extension

  • * Mysqli extension

  • * Pagination without jQuery

  • * API (non-REST)

  • * XML

    • Q3.
    Anyway, what is the difference between CRUD dB connections/communications and the new non-CRUD dB communications ?

    Q4.
    Finally, what is really jSon and how can it really benefit us ?

    I can understand how jQUERY benefits us. It loads only the new rows data without needing to load the whole page along with imgs etc. It saves us bandwidth. Saves new data loading time too on page.
    Now how does jSon benefit us ?Explain in layman terms.
    jSon is JavaScript. Right ? Might as well skip it as learning one language (PHP) is hard enough for me.
    And jSon does what XML used to do. Right ? But Jason does it without needing to load the whole page while with XML you need to load the whole page to view new feeds. Right ? So, jSon is a bit like
    jQuery ?

    Q5.
    Anything else I must know ?
    Thank You

    to post a comment
    PHP

    3 Comments(s) ↴

    Copy linkTweet thisAlerts:
    @ginerjmSep 29.2019 — one thing at a time.

    The Mysqli EXTENSION is not old stuff. Yes it is older but it is not deprecated like the mysql extension is, and is therefore perfectly acceptable to use. PDO is often said to be the more preferable as it is newer and can probably be expected to be around much much longer than mysqli. Both do utilize prepared statements and both can execute the exact same query statements. Done.

    All of the things that you list are things that one should pick up over time to be able to build more powerful apps. You don't need them all at once. That is - IF YOU DON"T TRY TO BUILD THE TAJ MAHAL on your first try..

    Pagination is not a function of JQ or even JS. Pagination is simply a "method" of displaying your data in a controlled way so as not to over load the user's screen with row upon row of data. You don't need to user anything but PHP to achieve pagination, but JS or JQ do make it more friendly for the user since the page doesn't have to be resent from the server to the client all the time - just the portion showing the rows.

    This statement:

    I can understand how jQUERY benefits us. It loads only the new rows data without needing to load the whole page along with imgs etc. It saves us bandwidth. Saves new data loading time too on page.


    is not correct. JQ and JS in a php environment is most likely a part of the AJAX call If you are writing a php web page that wants to use pagination then the Ajax call (using either JS or jQ) contacts a php script to obtain the next set of rows and then, Yes, the JQ/JS will receive and re-build the portion of the html code that is showing the rows of data. That is the beauty of using AJAX. JS/JQ can also be used for an AJAX call that is NOT doing pagination but simply trying to get some bit of data from the server to update a part of the currently viewed web page. JS and JQ are both languages that run on the client and not the server that allow you to do some fancier things that plain html cannot always do. Please try not to think of them as only being part of pagination, which is a method, a practice, a way of doing things, not a language.
    Copy linkTweet thisAlerts:
    @SempervivumSep 29.2019 — And jSon does what XML used to do. Right ? But Jason does it without needing to load the whole page while with XML you need to load the whole page to view new feeds. Right ? So, jSon is a bit like

    jQuery ?[/quote]    JSON and XML are similar insofar as both allow for encoding data structures, (nested) (associative) arrays, to a string. However JSON is easier to handle as a simple function call encodes or decodes the string from/to a data structure whereas, when using XML, it is necessary to build or evaluate the DOM.

    Both, JSON and XML can be used together with Ajax by encoding or decoding data structures when transfering the to/from the server. Thus when using XML you need not reload the complete page but you can use Ajax to get information from the server either.

    JSON and jQuery are completely different and cannot be compared.
    Copy linkTweet thisAlerts:
    @PrecalfOct 02.2019 — Q2 - the list is correct. Nothing to add really.
    ×

    Success!

    Help @developer_web spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 — BETA 5.20,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @AriseFacilitySolutions09,
    tipped: article
    amount: 1000 SATS,

    tipper: @Yussuf4331,
    tipped: article
    amount: 1000 SATS,

    tipper: @darkwebsites540,
    tipped: article
    amount: 10 SATS,
    )...