Table: members

Associated Objects: Members, Member

Fields

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("admin/load/nosession.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM members");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $firstname = $resRow["firstname"];  //
 $parent = $resRow["parent"];  //
 $lastname = $resRow["lastname"];  //
 $emailaddress = $resRow["emailaddress"];  //
 $username = $resRow["username"];  //
 $url = $resRow["url"];  //
 $phonenumber = $resRow["phonenumber"];  //
 $password = $resRow["password"];  //
 $approved = $resRow["approved"];  //
 $added = $resRow["added"];  //
 $address = $resRow["address"];  //
 $city = $resRow["city"];  //
 $state = $resRow["state"];  //
 $zipcode = $resRow["zipcode"];  //
 $country = $resRow["country"];  //
 $originalparent = $resRow["originalparent"];  //
 $doubleoptin = $resRow["doubleoptin"];  //
 $contentgroup = $resRow["contentgroup"];  //
 $membership = $resRow["membership"];  //
 $language = $resRow["language"];  //
 $timezone = $resRow["timezone"];  //
 $appkey = $resRow["appkey"];  //
}

Other Tables

adminpageaccess     adminpagecontents     adminpagesettings     adminsettings     alerts     apiactions     apikeylogs     apikeypermissions     apikeys     blockedemails     contactfields     contactgroupassign     contactgroups     contactnotes     contactnotify     contactpointlogs     contactpoints     contactpointsettings     contacts     contactsync     contentgroupassign     contentgroups     cookieapprovals     countrycodes     cprequiredfields     cronlogs     deleteque     designtemplatefields     doccategories     documentfolders     documents     documentsubcat     domainassign     editablecontent     emailaddresses     emailassign     errors     files     freesignups     ipblocks     ips     languageadmin     languageassign     languages     languagevalues     login     memberdetails     memberemails     membermobilenumbers     membernotes     membernotifyemails     members     membersareapagesettings     membershipassign     membershipbumps     membershipgroups     membershipnotify     membershipqualifications     memberships     membervars     membervarvalues     menuitems     menus     notes     notificationoffassign     notifications     pagecontents     pagedynamic     pages     pageviews     phoneassign     phonenumbers     primarypages     privacypolicies     reportallowtypes     reportdefaults     reports     reporttypes     resourcecategories     resources     restore     signups     sms     smscarriers     smtpaccounts     stats     statsma     thirdpartyautoresponders     thirdpartyautorespondervalues     useragents     usernamechanges     visitors     visitreferrers     visits     warnings     webapplinks     webapps     webappshortcuts