Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Best way to store data in root SQL database using livephp

Discussion in 'cPanel Developers' started by AeonCube, Jun 11, 2014.

  1. AeonCube

    AeonCube Member

    Joined:
    Jul 18, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    51
    Hi,
    Developing a plugin for cPanel that will need to store data for a user when they fill in a form on the plugin. I need this to be stored in a database table in the root SQL DB as the user can't go change things from outside of the plugin form page.

    Does anyone have a recommended way of doing this? If so any doc links or example code would be great!
    Thanks,
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 AeonCube, Jun 11, 2014
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,374
    Likes Received:
    2,042
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Could you elaborate a little more on the nature of the plugin? For instance, are you integrating any cPanel functions?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Jun 11, 2014
  3. KostonConsulting

    KostonConsulting Well-Known Member Verifed Vendor

    Joined:
    Jun 17, 2010
    Messages:
    255
    Likes Received:
    1
    Trophy Points:
    68
    Location:
    San Francisco, CA
    cPanel Access Level:
    Root Administrator
    When you install the plugin (you need to build your own installer), you can create a database as root and then you can access it through PHP's mysqli functions (PHP: Mysqli - Manual).

    However, if you just need to store data for an individual user, using MySQL is probably not the way to go. You should use cPanel's NVData (non-volatile data store) functions to store individual user data: NVData Module Documentation

    The main advantage of NVData over MySQL is that the data will be stored in the user's $HOME directory which means if their account is transferred to a different cPanel server, the data will still be available.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 KostonConsulting, Jun 13, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - Best store data
  1. NetsSource

    Best Practice for Migration

    NetsSource, Mar 8, 2019, in forum: General Discussion
    Replies:
    1
    Views:
    227
    cPanelMichael
    Mar 8, 2019
  2. Maning

    Best Spam settings

    Maning, Jan 31, 2019, in forum: E-mail Discussion
    Replies:
    1
    Views:
    251
    cPanelMichael
    Jan 31, 2019
  3. inteldigital

    Best server side caching on Centos 7/Cloudlinux?

    inteldigital, Nov 13, 2018, in forum: Workarounds and Optimization
    Replies:
    4
    Views:
    421
    cPanelMichael
    Nov 15, 2018
  4. DennisMidjord

    SOLVED Best approach to resellers?

    DennisMidjord, Oct 26, 2018, in forum: General Discussion
    Replies:
    10
    Views:
    203
    cPanelMichael
    Oct 26, 2018
  5. Host4life

    Best way to set up Nameservers, and Shared IP?

    Host4life, Oct 10, 2018, in forum: Bind/DNS/Nameserver
    Replies:
    1
    Views:
    236
    cPanelLauren
    Oct 16, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice