A record in aps- where it will show in PA server
IN POA 1.Click on Operations Director–>Dns Manager->Click on the domainname you used in the package 2.Click the DNS Tab 3.Click on Dns Records here it will show A,AAA,NS record etc.
url with ‘https’ Curl function in aps package not working why?
in this case please add the following line in the curl function curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false); This will work…….. 🙂
Curl function not working in aps package/PA Server Why?
See the below example curl_setopt($curl,CURLOPT_HTTPHEADER,array (“Accept:application/json”)); curl_setopt($curl, CURLOPT_POST, 1); // Do a regular HTTP POST curl_setopt($curl, CURLOPT_POSTFIELDS, ‘client_id=’ . urlencode($client_id) . ‘&’ . ‘client_secret=’ . urlencode($client_secret) . ‘&’ . ‘grant_type=client_credentials’ . ‘&’ . ‘scope=openid’); curl_setopt($curl, CURLOPT_RETURNTRANSFER, TRUE); curl_setopt($curl, CURLOPT_USERAGENT, “Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)”); curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 0); curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($curl, CURLOPT_URL, $token_url);… Read More »
Drop table
note:if you use drop command then you cant recover the data deleted. drop table mydoubts_table_users
Delete query in mysql
see the examples # delete * from mydoubts_table_users # delete from mydoubts_table_users where name=’vasanthan’
Operators in the where clause
#Example for “=”. select * from mydoubts_table_users where name=’vasanthan’ —————————————————— |id|Name |Age| —————————————————— |1|vasanthan|32| ——————————————————- #Example for “!=” select * from mydoubts_table_users where name!=’vasanthan’ output —— —————————————————— |id|Name |Age| —————————————————— |2|John |44| |3|Michael |34| |4|Rani |39| |5|Raina |38| |6|Rajendra |25| |7|Sharon |18| ——————————————————- #Example for “>” select * from mydoubts_table_users where age>29 output —— ——————————————————… Read More »
Where query in mysql
Example: select * from mydoubts_table_users where name=’vasanthan’ output —— —————————————————— |id|Name |Age| —————————————————— |1|vasanthan|32| ——————————————————-
Mysql ‘Select’ query
query example and sample output as below “Select * from mydoubts_table_users output —— —————————————————— |id|Name |Age| —————————————————— |1|vasanthan|32| |2|John |44| |3|Michael |34| |4|Rani |39| |5|Raina |38| |6|Rajendra |25| |7|Sharon |18| ——————————————————-
Insert in mysql
Below query will insert data into the mydoubts_table_users. insert into mydoubts_table_users(name,age)values(‘Seetha’,’33’);
‘In’ clause in mysql
‘In’ clause wirll replace many ‘OR’s Example for fetching data using ‘In’. —————————————————— |id|Name |Age| —————————————————— |1|vasanthan|32| |2|John |44| |3|Michael |34| |4|Rani |39| |5|Raina |38| |6|Rajendra |25| |7|Sharon |18| ——————————————————- Select * from mydoubts_table_users where age IN(34,32,38); —————————————————— |id|Name |Age| —————————————————— |1|vasanthan|32| |3|Michael |34| |5|Raina |38| ——————————————————- Suppose if we use the query using ‘or’… Read More »