WaSQL Documentation

PHP Files

• php::database.php (96)
  • addDBIndex
  • addDBRecord
  • addEditDBForm
  • alterDBTable
  • cleanupDBRecords
  • createDBTable
  • createDBTableFromFile
  • createDBTableFromText
  • databaseGradeSQL
  • databaseListRecords
  • dbAddFields
  • dbAddIndex
  • dbAddRecord
  • dbAddRecords
  • dbAlterTable
  • dbConnect
  • dbCreateTable
  • dbDelRecord
  • dbDelRecordById
  • dbDropFields
  • dbDropIndex
  • dbDropTable
  • dbEditRecord
  • dbEditRecordById
  • dbEnumQueryResults
  • dbExecuteSQL
  • dbGetAllProcedures
  • dbGetAllTableConstraints
  • dbGetAllTableFields
  • dbGetAllTableIndexes
  • dbGetCount
  • dbGetDDL
  • dbGetLast
  • dbGetProcedureText
  • dbGetRecord
  • dbGetRecordById
  • dbGetRecords
  • dbGetTableDDL
  • dbGetTableFields
  • dbGetTableIndexes
  • dbGetTablePrimaryKeys
  • dbGetTables
  • dbGrep
  • dbISQL
  • dbIsTable
  • dbListRecords
  • dbNamedQuery
  • dbOptimizations
  • dbQueryResults
  • dbSetLast
  • delDBRecord
  • delDBRecordById
  • dropDBColumn
  • dropDBIndex
  • dropDBTable
  • dumpDB
  • editDBRecord
  • editDBRecordById
  • editDBUser
  • executeSQL
  • exportDBRecords
  • getDBCount
  • getDBFieldInfo
  • getDBFieldMeta
  • getDBFields
  • getDBFieldTag
  • getDBFiltersString
  • getDBFormRecord
  • getDBFormRecords
  • getDBPaging
  • getDBQuery
  • getDBRecord
  • getDBRecordById
  • getDBRecords
  • getDBSchema
  • getDBSchemaText
  • getDBSettings
  • getDBTableIndexes
  • getDBTableInfo
  • getDBTables
  • getDBUserById
  • getDBWhere
  • grepDBTables
  • isDBPage
  • isDBReservedWord
  • isDBTable
  • listDBRecords
  • listDBResults
  • loadDBFunctions
  • mapDBDvalsToTvals
  • mapDBTvalsToDvals
  • processDBRecords
  • pyQueryResults
  • roundToNearestMultiple
  • setDBSettings
  • truncateDBTable
• php::user.php (5)
  • userGetTempAuthLink
  • userLoginAs
  • userLoginForm
  • userProfileForm
  • userValue
• php::wasql.php (8)
  • debugValue
  • minifyCssFile
  • minifyJsFile
  • wasqlGetCountries
  • wasqlGetDatabases
  • wasqlGetInputtypes
  • wasqlGetMasks
  • wasqlGetStates
• php::common.php (314)
  • abort
  • appendFileContents
  • arrayAverage
  • arrays2CSV
  • arrays2RSS
  • arrays2SchemaFields
  • arrays2TAB
  • arrays2XML
  • arrayToXML
  • asciiArt
  • buildDir
  • buildFakeContent
  • buildFormBegin
  • buildFormButtonSelect
  • buildFormButtonSelectMultiple
  • buildFormCalendar
  • buildFormCheckAll
  • buildFormCheckbox
  • buildFormColor
  • buildFormColorBox
  • buildFormColorBoxMap
  • buildFormColorHexagon
  • buildFormCombo
  • buildFormDate
  • buildFormDateTime
  • buildFormField
  • buildFormFile
  • buildFormFile_OLD
  • buildFormFrequency
  • buildFormGender
  • buildFormGeoLocationMap
  • buildFormHidden
  • buildFormImage
  • buildFormLatLon
  • buildFormMultiInput
  • buildFormMultiSelect
  • buildFormPassword
  • buildFormRadio
  • buildFormRecorderAudio
  • buildFormSelect
  • buildFormSelectColor
  • buildFormSelectCountry
  • buildFormSelectCustom
  • buildFormSelectDatabase
  • buildFormSelectFont
  • buildFormSelectHost
  • buildFormSelectMonth
  • buildFormSelectOnOff
  • buildFormSelectState
  • buildFormSelectTimezone
  • buildFormSelectYear
  • buildFormSignature
  • buildFormSlider
  • buildFormStarRating
  • buildFormSubmit
  • buildFormText
  • buildFormTextarea
  • buildFormTime
  • buildFormToggleButton
  • buildFormTranslate
  • buildFormWhiteboard
  • buildFormWYSIWYG
  • buildFormYesNo
  • buildHtmlBegin
  • buildIECompatible
  • buildOnLoad
  • buildShareButtons
  • buildShareLinks
  • buildSocialButtons
  • buildTableBegin
  • buildTableRow
  • buildTableTD
  • buildTableTH
  • buildUrl
  • calculateBearing
  • calculateDistance
  • checkPHPSyntax
  • cleanDir
  • cleanupDirectory
  • cmdResults
  • commonBuildTerminal
  • commonCertInfo
  • commonConvert2Python
  • commonCronCheckStopNow
  • commonCronError
  • commonCronLog
  • commonCronPause
  • commonCronPauseGroup
  • commonCronRunNow
  • commonCronUnpauseGroup
  • commonFormatPhone
  • commonGetContrastRatio
  • commonGetFileIconClass
  • commonObjectInfo
  • commonParseIni
  • commonProcessChartjsTags
  • commonProcessDBListRecordsTags
  • commonRGBToHSL
  • commonSearchFiltersForm
  • commonSetCookie
  • commonShowCode
  • commonStrlen
  • configValue
  • containsPHP
  • convertExtendedCharacters
  • convertLatLon
  • convertSpecialChars
  • convertTimezone
  • copyFile
  • createExpandDiv
  • csv2Arrays
  • csvImplode
  • csvParseLine
  • date2Mysql
  • decodeBase64
  • decodeJson
  • decodeURL
  • decrypt
  • deleteDirectory
  • embedPDF
  • encodeAscii
  • encodeBase64
  • encodeCRC
  • encodeData
  • encodeHtml
  • encodeJson
  • encodeLatin
  • encodeQP
  • encodeURL
  • encrypt
  • evalPHP
  • fileManager
  • fileManagerOLD
  • fileManagerV2
  • fileStat
  • filterFile
  • fixMicrosoft
  • formatMoney
  • formatPre
  • friendlyName
  • generateGUID
  • generatePassword
  • getAgentBrowser
  • getAgentLang
  • getAgentOS
  • getCalendar
  • getCharset
  • getCSVFileContents
  • getCSVRecords
  • getCSVSchema
  • getD3Color
  • getDaysInMonth
  • getDirRecords
  • getEncodedFileContents
  • getFileContentId
  • getFileContents
  • getFileContentsPartial
  • getFileContentType
  • getFileExif
  • getFileExtension
  • getFileIcon
  • getFileLineCount
  • getFileMimeType
  • getFileName
  • getFilePath
  • getFilePerms
  • getFirstMonthDay
  • getGravatar
  • getGUID
  • getHexAlpha
  • getHolidayList
  • getHolidays
  • getImageWidthHeight
  • getMemoryUsage
  • getRandomColor
  • getRandomString
  • getRemoteFileInfo
  • getRemoteImage
  • getStoredValue
  • getStoredValueAge
  • getSubdomain
  • getUniqueHost
  • getURL
  • getView
  • getWasqlPath
  • getWebsiteMeta
  • getWeekNumber
  • grepFiles
  • headFile
  • hex2RGB
  • html2PDF
  • includeAdminPage
  • includeApp
  • includeFile
  • includeModule
  • includePage
  • includePageIf
  • includePageIfElse
  • includePHPOnce
  • int8ToTime
  • isAudioFile
  • isDate
  • isDateTime
  • isEmail
  • isEven
  • isExtra
  • isExtraCss
  • isExtraJs
  • isFactor
  • isFunction
  • isImageFile
  • isJSON
  • isLiveUrl
  • isNum
  • isOne
  • isParams
  • isRequest
  • isServer
  • isSession
  • isSpider
  • isStrongPassword
  • isTextFile
  • isVideoFile
  • isWasqlField
  • isWasqlTable
  • isWebImage
  • isXML
  • listFiles
  • listFilesEx
  • loadExtras
  • loadExtrasCss
  • loadExtrasFont
  • loadExtrasJs
  • loadJsFile
  • loremIpsum
  • minifyCode
  • monthName
  • mysqlDate
  • mysqlDateTime
  • numberFormat
  • ordinalSuffix
  • pageValue
  • parseHtmlTagAttributes
  • parseKeyValueString
  • parseWacssEditFormTags
  • passwordScore
  • ping
  • postJSON
  • postURL
  • postXML
  • printValue
  • printValueHidden
  • printValueIf
  • printValueIfUser
  • processCSVLines
  • processFileLines
  • pushData
  • pushFile
  • readRSS
  • readXML
  • removeCdata
  • removeComments
  • removeHtml
  • removeHtmlTags
  • removePHPComments
  • renderEach
  • renderView
  • renderViewIf
  • renderViewIfElse
  • renderViewIfs
  • renderViewSwitch
  • request2XML
  • request2XMLSimple
  • requestValue
  • rgb2HEX
  • selectYears
  • sendMail
  • setFileContents
  • setSessionTemplate
  • setStoredValue
  • setStyleAttribues
  • setTagAttributes
  • setValue
  • setView
  • sgml2XML
  • showZipfileImage
  • soap2Array
  • soap2XML
  • sortArrayByKey
  • sortArrayByKeys
  • sortArrayByLength
  • splitWords
  • streamCmdResults
  • stringBeginsWith
  • stringContains
  • stringEndsWith
  • stringEquals
  • tailFile
  • toFixed
  • truncateWords
  • underConstruction
  • underMaintenance
  • utf2Html
  • verboseNumber
  • verboseSize
  • verboseTime
  • wasqlMail
  • wget
  • xls2CSV
  • xml2Array
  • xml2Array2
  • xml2PDF
  • xmlEncodeCDATA
  • xmlHeader
• extras::convert.php (1)
  • convert2Txt
• extras::whois.php (2)
  • whoisCheckDomain
  • whoisServer
• extras::geonames.php (2)
  • geonamesImportZipcodes
  • geonamesPostalCodeSearch
• extras::webservices.php (14)
  • wsAcronyms
  • wsAonawarePostURL
  • wsBibleDictionary
  • wsComputing
  • wsDictionary
  • wsDomainSearch
  • wsElements
  • wsGazette
  • wsJargon
  • wsLanguageDictionary
  • wsLawDictionary
  • wsMusic
  • wsPHPDocumentation
  • wsThesaurus
• extras::libchart.php (2)
  • libchartColorThemes
  • libchartPieChart
• extras::amazon.php (4)
  • amazonConvertFile
  • amazonConvertFilesS3
  • amazonSendMail
  • amazonUploadFileS3
• extras::phpexcel.php (5)
  • phpexcelArrays2xlsx
  • phpexcelCleanUp
  • phpexcelFputcsv
  • phpexcelXlsx2csv
  • phpexcelXmlObjToArr
• extras::zipcodes.php (2)
  • zipcodesGetClosestRecords
  • zipcodesImportCountry
• extras::system.php (12)
  • getProcessCount
  • getProcessCountXML
  • getProcessList
  • getServerInfoFileData
  • getServerInfoLinux
  • nmap
  • systemConvertToBytes
  • systemGetDriveSpace
  • systemGetPidInfo
  • systemUnixMemsize
  • unix_memsize
  • windows_memsize
• extras::sftp.php (5)
  • sftpGetFile
  • sftpGetFileContents
  • sftpGetFiles
  • sftpListFiles
  • sftpPutFile
• extras::phpmailer_old.php (1)
  • phpmailerSendMail
• extras::mandrill.php (1)
  • mandrillSendMail
• extras::translate.php (2)
  • translateMapText
  • translateUnmapText
• extras::weather.php (9)
  • weatherByStationId
  • weatherByZip
  • weatherGetDistance
  • weatherGetForecast
  • weatherGetLatLon
  • weatherGetStation
  • weatherGetStationList
  • weatherGetStationZip
  • weatherNDFDgenByDay
• extras::office365.php (5)
  • office365Auth
  • office365GetAuthCookies
  • office365GetSecurityToken
  • office365GetSecurityTokenXml
  • office365ParseToken
• extras::facebook.php (1)
  • facebookUpdateStatus
• extras::amqp.php (2)
  • amqpStreamConnection
  • amqpTable
• extras::media.php (2)
  • mediaPoster
  • mediaSound
• extras::tiny.php (1)
  • tinyUrl
• extras::apache.php (2)
  • apacheParseLogFileLine
  • apacheReportCounts
• extras::markdown.php (2)
  • markdown2Html
  • markdownFromHtml
• extras::gitlab.php (1)
  • gitlabAddUpdate
• extras::woocommerce.php (6)
  • woocommerceAddWebhook
  • woocommerceDelWebhook
  • woocommerceEditWebhook
  • woocommerceGetWebhooks
  • woocommerceGetWebhooksCount
  • woocommerceNewClient
• extras::simple_html_dom.php (21)
  • __get
  • __isset
  • __set
  • __unset
  • appendChild
  • childNodes
  • childNodes
  • createElement
  • createTextNode
  • getAttribute
  • getElementById
  • getElementById
  • getElementByTagName
  • getElementByTagName
  • getElementsById
  • getElementsById
  • getElementsByTagName
  • getElementsByTagName
  • hasAttribute
  • removeAttribute
  • setAttribute
• extras::xlsx-reader.php (2)
  • xlsxreaderFormatFieldNames
  • xlsxreaderGetRecords
• extras::twitter.php (7)
  • twitterFetch
  • twitterFollowersStatus
  • twitterFriendsStatus
  • twitterFriendsTimeline
  • twitterPublicTimeline
  • twitterTweets
  • twitterUpdateStatus
• extras::qualtrics.php (8)
  • qualtricsCreateSubscription
  • qualtricsDeleteSubscription
  • qualtricsGetList
  • qualtricsGetSubscription
  • qualtricsListDirectoryContacts
  • qualtricsListSMSDistributions
  • qualtricsSurveyResponse
  • qualtricsSurveyResponses
• extras::dreamhost.php (14)
  • dreamhostAccountStatus
  • dreamhostAccountUsage
  • dreamhostAddFilter
  • dreamhostAPI
  • dreamhostGetDatabaseHosts
  • dreamhostGetDatabases
  • dreamhostGetDomains
  • dreamhostGetPromoCodes
  • dreamhostGetPS
  • dreamhostGetRegistrations
  • dreamhostGetUsers
  • dreamhostListAccessibleCmds
  • dreamhostMailFilters
  • dreamhostRemoveFilter
• extras::resumable.php (3)
  • createFileFromChunks
  • resumableLog
  • rrmdir
• extras::romanize.php (1)
  • romanizeIsASCII
• extras::ffmpeg.php (1)
  • ffmpeg2Mp4
• extras::yo.php (3)
  • yoAll
  • yoCount
  • yoOne
• extras::imagemagick.php (2)
  • imagemagickImage2ico
  • imagemagickImageResize
• extras::git.php (9)
  • gitAdd
  • gitCheckout
  • gitCommit
  • gitConfigList
  • gitDiff
  • gitLog
  • gitPull
  • gitPush
  • gitStatus
• extras::tcpdf.php (2)
  • tcpdfHTML
  • tcpdfXML
• extras::wdns.php (9)
  • wdnsGetDomainException
  • wdnsGetDomainRecord
  • wdnsGetFilterRecord
  • wdnsGetScheduleRecord
  • wdnsGetUserRecord
  • wdnsHandleRequest
  • wdnsLog
  • wdnsNSLookup
  • wdnsProcessAlerts
• extras::asciitable.php (1)
  • asciitableCreate
• extras::c4c.php (4)
  • c4cAddCustomer
  • c4cAddCustomerInteraction
  • c4cEditCustomer
  • c4cGetCustomerById
• extras::evalmath.class.php (7)
  • e
  • evaluate
  • last
  • nfx
  • pfx
  • push
  • trigger
• extras::ai_openai.php (2)
  • ai_openaiAsk
  • openaiUsage
• extras::ms2txt.php (5)
  • ms2txtConvert
  • ms2txtConvertDoc
  • ms2txtConvertDocx
  • ms2txtConvertPptx
  • ms2txtConvertXlsx
• extras::zipfile.php (5)
  • zipCreate
  • zipGetFileContents
  • zipGetFileThumbnail
  • zipPushData
  • zipPushFile
• extras::paypal.php (6)
  • paypalCheckout
  • paypalCreatePlan
  • paypalCreateProduct
  • paypalCreateSubscription
  • paypalSendInvoice
  • paypalSendPayout
• extras::ical.php (2)
  • icalCreateICS
  • icalEvents
• extras::ai_anthropic.php (1)
  • ai_anthropicAsk
• extras::ftp.php (4)
  • ftpGetFile
  • ftpGetFiles
  • ftpListFiles
  • ftpPutFile
• extras::mailbox.php (13)
  • mailboxConnect
  • mailboxDecodeMessagePart
  • mailboxDeleteMessage
  • mailboxDisconnect
  • mailboxGetMessage
  • mailboxGetMessageHeader
  • mailboxGetMessageParts
  • mailboxGetMessages
  • mailboxInfo
  • mailboxList
  • mailboxMoveMessage
  • mailboxParseEmail
  • mailboxParseHeaders
• extras::wcommerce.php (18)
  • wcommerceAdd2Cart
  • wcommerceBuildField
  • wcommerceGetOrder
  • wcommerceGetProductAttributes
  • wcommerceInit
  • wcommerceOrdersAddedit
  • wcommerceOrdersDelivered
  • wcommerceOrdersItemDelivered
  • wcommerceOrdersItemShipped
  • wcommerceOrdersItemsList
  • wcommerceOrdersItemsListExtra
  • wcommerceOrdersListExtra
  • wcommerceOrdersShipped
  • wcommerceProductImages
  • wcommerceProducts
  • wcommerceProductsAddedit
  • wcommerceProductsListExtra
  • wcommerceSettingsAddedit
• extras::qrcode.php (3)
  • qrcodeCreate
  • qrcodeCreateWithLogo
  • qrcodeRoundCorners
• extras::ldap.php (18)
  • ldapAddAttribute
  • ldapAddUser
  • ldapAuth
  • ldapConvert2UserRecord
  • ldapDisable
  • ldapEditAttribute
  • ldapEnable
  • ldapErrorMessage
  • ldapGetMemberOfOu
  • ldapIsActiveRecord
  • ldapIsMemberOf
  • ldapMapField
  • ldapModify
  • ldapModifyAttribute
  • ldapParseEntry
  • ldapParseMemberOf
  • ldapSchema
  • ldapSearch
• extras::wdns_user.php (3)
  • printValue
  • stringBeginsWith
  • stringContains
• extras::cities.php (3)
  • citiesGetClosestRecords
  • citiesGetCountry
  • citiesImportCountry
• extras::eventbrite.php (2)
  • eventbriteGetAttendeeList
  • eventbriteGetEventList
• extras::geoip.php (5)
  • geoipCalculateDistance
  • geoipDistance
  • geoipGetTimeZone
  • geoipInfo
  • geoipRadiusInfo
• extras::opendns.php (2)
  • opendnsGetDomains
  • opendnsIsValidAuth
• extras::phpmailer.php (1)
  • phpmailerSendMail
• extras::google.php (19)
  • adwordsTargetingIdea
  • adwordsTargetingIdeaNS
  • adwordsTargetingIdeaNS2
  • DateAdd
  • endDate
  • getCalEvent
  • getGoogleAuth
  • getGoogleCalendar
  • getGoogleCalendarData
  • getGoogleCalendarList
  • getGoogleData
  • getGoogleStats
  • googleClientLogin
  • googleGetLatLon
  • googleTranslate
  • modCalEvent
  • postCalEvent
  • prepDate
  • prepTime
• extras::plivo.php (2)
  • plivoSendMsg
  • plivoUpdatePlivoLog