Search This Blog typing in English or Telugu, and sometimes Hindi

Showing posts with label PHP Scripts. Show all posts
Showing posts with label PHP Scripts. Show all posts

Thursday, October 12, 2017

1023 php script to design a SqLite & SqLite3 database tables record-by-record editor


As an aficionado (in the meaning of devotee) of Open Source Software, I am tempted to present here, a php script for a Sqlite (& Sqlite3) Database Creation, Table Creation, Editor for SQlite file databases which can be embedded and used in USB Pendrives, or Offline/Online Computers, without installing the database files in Memory. SqLite (&SqLite3) seem to suit this purpose of going for file databases. In case of file databases, the data is stored in .sqlite files. Though the .sqlite files are not like flat files genre such as 'csv' (Comma Separated Values) files which can be opened and read/edited in text editors, yet, at least file databases have independent existence in the respective folders either on USB drives, or in Computer Hard-disk folders. Unlike other mainstream databases such as mysql, postgresql, which require database files to be stored in Computer Memories, file databases, especially sqlite databases can use pdo sqlite connections, and can not only be stored in USB pen drives, but also be conveniently backed up/copied among usb-to-usb, usb-to-computer, computer-to-usb etc. In the absence of suitable php scripts (I felt that there is a paucity of such non-commercial scripts), we may have to use packages such as sqlmanageers, and sqlite managers. For editing purpose, some extra proficiency in creating and executing sql statements will be needed if we have to make use of packages such as 'sqlite managers'.

First I shall give a screenshot of an SQLite Manager, which I could get, wherefrom I do not know, probably I might have obtained as default with my php sqlite3 installation, which I have tried to use for working with sqlite databases:


The php script which is presented here below does not require such 'sql' proficiencies, which sqlite managers need. First I copy and paste below, the php script used by me to design an sqlite3 database creator, table creator, rows inserter, rows updater, rows deleter, searcher for strings in columns of tables. After the php script, I shall explain some prerequisites for the script to work, some precautions, some pros and cons.

Some Pre-requisites


I have tested this script on Ubuntu (Linux) version 15.04 and 16.04. As php is platform-independent, it can be tested on Windows and probably Mac.
,br />Apache2 server (or its equivalent) is to be installed, and is to be configured to facilitate operations on http://localhost or http://127.1.1 .

An appropriate folder is to be identified for use as a sort of 'public_html' for read, write access of sub-folders and files. And this public_html folder should be such that even if it is exposed to Public, there should be no risk. That means sensitive files should not be stored on this folder. This precaution is very important not only for SqLite, but also for any other php scripts.

Our php script file, with some name such as phppdosqliteexp.php should also be stored in the same folder.

Configuring of php can be checked by using a phpinfo.php file, with three lines inside the file: <?php linebreak phpinfo(); linebreak ?> .

I have given database name as 'dyb1'. Readers can give their own database names. If that database does not exist in SqLite, it will create.

I have given table name as 'tyb1'. Readers can give their own names.

I have used total 11 columns in each table, as default, and standard for uniformity. Readers will have to change the php script, for changing the number of columns and column names.

Column names used by me in each table:
First column: The column name used by me in the above script is 'idpk'. It is an integer (number) column. pk signifies 'primary key'. I have also used the attribute 'AUTOINCREMENT', which means we need not fill up this column. The PHP itself will give id numbers automatically. We have to keep in mind, the distinction between the column idpk and row-numbers (record numbers) in a table. When a particular record with a particular idpk no. is deleted, it will not get replaced. That particular NO. will be missing in the Serial Order. When we search for a record, with that deleted particular idpk record, we can only get blank text areas. Deleted 'idpk' records cannot be revived (to the best of my experience. Readers may have a different experience).

Row Numbers on the other hand are rather liquid, like line numbers in a text editor. When a record is deleted, the next record will occupy the row. Hence, searching row-numbers will not be convenient. Searching with idpk column, or any other text string in columns such as f1,f2,f3,f4,f5 will show results, if there are rows which contain the search string. The flexibility is: We can search in any column of our choice, one-by-one.

text columns: f1, f2, f3, f4, f5.
Decimal columns suitable for mathematical calculations: d1, d2, d3, d4, d5.

To facilitate searches even in large tables, this php script opens with default search in, default database say dyb1, table say tyb1, default search in column f1, and search string as 'a' The letter 'a' has been taken as default search string because, there will be very few tables which do not use 'a' as value in their text columns. After, running the php script, if Readers want to search for any other search string, they can simply change the search string in the search box, type the new search string, keep the ok box above submit button as blank, and click the submit button. Search Results will be shown record-by-record (i.e. row-by-row). This is necessary because, we may want to edit that particular record and update it, or delete it altogether. If we wish to go to next record, we have to type n in the ok box, and click submit.

The ok box (text area) supports following letters:
s - for searching.
i - for inserting.
u - for updating.
d- for deleting.
n - n to go to next record
p - g to go to previous record.
g - First we should type the idpk number we want, in the idpk box. Then type g in the ok box. Then Click submit button.


Note: There seems to be some bugs, when the search results / records go beyond the last row, or past the first row. The java script 'alert' of 'past the first record', 'past the last record' seems to be annoying. This, I shall try to resolve and post a fresh php script, as soon as I rectify them.


I welcome suggestions, corrections, and criticism.

To come back, to continue adding, deleting, modifying.

Tuesday, August 1, 2017

1016 PHP Script to work as front end for using Gladius db for flat database files


First, I apologise to my Readers for the interregnum (time gap which has taken place, since the last post No. 1015 here). Reason: I was designing and experimenting with a php script, to use as a front end for Gladius database, which is written in pure PHP. It is based on flat-database files. They are portable in the sense that each database is stored in the form of a folder, and tables are stored in the form of files in the respective database folders. This, we can see, is in contrast to traditional database packages like sqlite, mysql, postgresql, the databases and tables relating to which, we cannot see as separate files. Besides, all the three principal traditional databases sqlite, mysql, postgresql, need installation. They, themselves, do not provide gui-s (graphic user interfaces) for carrying out data entry operations. We have to use third party tools for data entry, or alternatively use command-line. Of course, mysql and postgresql facilitate multi-user environment, admin, user creation, user rights, passwords, 'connect' using the user names and passwords. From the security point of view both mysql and postgresql score high. Though, not using usernames, passwords, etc. may pose security risks, certain type of databases and tables do not require much of security. The information they contain may be of innocuous public opensource type, where secrecy and security are not important. Gladius DB will be of good utility in such situations, because the hastles of getting connected through usernames and passwords can be avoided.

First, I present below a PHP script for creating and using Gladius Databases and tables. After that, I shall list out some precautions and pre-requsites for effective of use of Gladius, and this PHP script.

Most PHP Scripts are portable and platform independent.


That means, they can be used on all the OSes including Windows, Linux all flavours, Mac., etc. They can also be stored on USB pen drives, and transferred from one machine to another machine. But, there is one word of caution: .PHP files can be tested and worked with, off-line only when there are properly configured Apache2 Server (or some other equivalent server), and PHP (in case of Gladius php5 version or later). At present, I use Ubuntu 15.04 and 16.04 versions. In the earlier versions such as Ubuntu 10.04, 10.10, 11.04, 12.04 etc. there was greater freedom in the sense that any folder can be designated as 'DocumntRoot' or public_html or 127.0.0.1 or localhost. In Ubuntu 15.04 and 16.04 more security restrictions have come. Consequently, we cab designate only a particular folder such as 'Public' as DocumentRoot and local host for the Apache2 Server and the PHP files. Significant number of threads are available on the internet for troubleshooting problems in designating localhost (127.0.0.1), in the place of folders like var/www which require use of Admin/Root Passwords. Once Apache and PHP are appropriately configured, working with PHP becomes very easy, flexible and rewarding.

Creating databases and tables by PHP and Gladius DB

Creating databases and tables in Gladius folder requires user permissions and accesses for 'Create and Delete iles', 'Read and Write' for files. In respect of files created by PHP and Gladius, the owner of the files will be 'www-data', and not the user of the machine.

Link to Gladius DB


Click here to go https://sourceforge.net/projects/gladius/- for a download.

The Gladius is available as a zip file. After downloading, we have to unzip it in a folder which has been designated as folder for DocumentRoot / localhost / 127.0.0.1. Then only, php will work. We have to make sure that all access create, delete, read, write rights are given to the folders and files. It may also be necessary to read about the Disclaimers of the Gladius Creators, and licensing restrictions. Though it is free and open-source, we cannot use for commercial purposes. Those Readers who are interested in reading the source files can also read them, by opening the php files in a text editor.

Apparently, there is no GUI in the above downloaded zip file, for creating Gladius db databases, and tables.

I am also unable to trace any sample databases and tables. The database name 'myshop' I seen in the above screenshot, I got from one website. Link: . Whatever be the name, we have to create the databases, and tables. I believe our php script presented here below, can serve the purpose.


Very important


Because of conflict with blogger 'textarea' in the above script, I have used '&lessthan ;' before '<' and '&greaterthan ;' before '>' before and after the word textarea in the above script. Pl. correct all the '&lessthan ;' as '<' and all '&greaterthan ;' as '>' after you paste the above script in a text editor, and saving as a .php file. This problem is a blogger-editor problem, which I tried to overcome in a roundabout way.

Some deficiencies in the above php script designed by me


1. I have not followed standard naming conventions.
2. Creation of the first table in a new database is not working properly. First table may have to be created using a simpler php file, which I shall present in another future port shortly. Creation of 'second table' onwards I did not observe any problem.

More suggestions in the next blog post.

To come back, and continue adding / deleting / modifying. सशेष. ఇంకా ఉంది.

Saturday, October 15, 2016

819 PHP 5 Script for a user editable Medical Dictionary


In the last blog post No. 818 here, Click to go to post No. 818 we have adventured into a Java 8 Code .java file creation for an offline usable, user editable medical dictionary with sample text. We now take up a php5 script for designing an online/offline user editable medical dictionary with a sample text file.

Some features of PHP Scripts.
1. PHP Scripts are browser-based, i.e. we have to use them with the help of browsers like Firefox, Google Chrome, Chromium, Opera, Safari etc.

ONLINE USE



2. For online use of php scripts, we have to upload php files, and the supporting data files to a host server who will give shelter to all our files. All the paid web-hosts normally allow php scripts on their servers. On the net, there are "Free" web-hosters also, with 'their advertisements' and without their advertisements. Often, they also give us a dub-domain name.

OFFLINE USE



3. For offline use of php scripts, and their testing, we need to install an apache server and php on our desktop. I have tested the following script with PHP5 supported by firefox web browser, and an apache2 server. The apache server has to be configured for localhost access with something like http://localhost/...php. For the sample medical dictionary text file, you can create your own sample medical text file with every word entry in the following model:

^`word: meaning.
^`word: meaning.
^`word: meaning.
^`word: meaning. Like this you can enter any number of words. "^" is used as a delimiter between one recorde and another record. ":' is used as a separator between 'word' and its 'meaning'.

Or if you want a sample text file, which I have designed, you can use the file given by me in our blogpost No. 817 (See link at the beginning) in the ybmedicdicti.zip file uploaded by me at SourceForge.Net. It has about 10,000 words collected from American Government websites. That file and the Java code is not for Commercial Use. It is for educational purposes. This PHP5 script is also intended for Educational Purposes only.

Question: Can we use this script for general dictionaries, Telugu Dictionaries?



Ans: This script uses a text file as data, with a delimiter "^". You can create any number of dictionaries. Not only medical dictionaries, but also general dictionaries. Both php5 and Java 8 support utf-8. If there are Telugu fonts on the Desktop, almost all browsers particularly Firefox and Google Chrome, Chromium support UTF-8 coding. Hence we can use even for Telugu Dictionaries.
Here is the script. This script contains both html and php tags. Unfortunately, at this blogspot web-page, all the script is not showing correctly. I am googling, to find ways to show these html and php tags correctly with syntax highlighting of tags, variables.

This script, you have to save as a php file in a text editor. It is to be saved in your public_html directory. In Ubuntu all versions, its default location will be /var/www. But /var/www is a secured area. File saving filesinto it, you have to use a sudo password.


To continue . सशेष. ఇంకా ఉంది.

Sunday, September 25, 2016

811 People of Other States of India, and probably people of other countries, can learn lessons from FORCED BIFURCATION OF ANDHRA PRADESH



Click to go to http://www.andhrajyothy.com/artical?SID=315068.

Click to go to http://www.andhrajyothy.com/artical?SID=314816.

Click to go to the http://www.andhrajyothy.com/artical?SID=314920 .

In Andhrajyothy.com dated 26.9.16, print edition, first page headlines, Andhra Jyothy Telugu daily has given a brief outcome of the TV discussion which has taken place between Mr. Jaipal Reddy, Former Senior Union Minister, and Mr. Undavalli Arun Kumar, Former Congress M.P. from Rajahmundry. The above news items are very brief. But the TV interview is very lively and worth seeing.

1. తెలంగాణ బిల్లు ఆమోదం పొందలేదు.. రాజ్యాంగబద్ధంగా హెడ్‌కౌంట్‌ జరపలేదు. (Telangana Bill did not receive acceptance of Lok Sabha. Headcount was not conducted as per Constitution).

2. లెక్కించినట్లు స్పీకర్‌ నటించారు.. ఆరోజు బిల్లు ఆమోదానికి తగిన బలం లేదు. (Speaker pretended/acted as if headcount was done. There was not enough strength in the House, for acceptance of the Bill on that day.)

సింపుల్‌ మెజారిటీ కూడా లేదు.. 236 మంది హెడ్‌కౌంట్‌ కుట్ర కాక మరేమిటి? (There was not even a simple majority. The head count of 236 was what, if not conspiracy?)

బిల్లుకు కమల్‌, సుష్మ సిద్ధంగా లేరు.. వారిని ఒప్పించి చెప్పే నేర్పు జైపాల్‌కుంది. (Kamal(Kamalnath) and Sushma (Ms. Sushma Swaraj) were not ready. Shri Jaipal has the skill/talent to convince them).

జైపాల్‌ కూడా ఇలా వ్యవహరిస్తారా.. తప్పు పునరావృతం కాకూడదనే నా పుస్తకం (Should Shri Jaipal Reddy also conduct / transact in this manner? )

జైపాల్‌ రెడ్డి గారూ.. మనసు గాయపరిచి ఉంటే క్షమించండి: ఉండవల్లి (Shri Jaipal Reddy ji, If I have hurt you, pl. pardon me.)
ఆంధ్రప్రదేశ్‌ పునర్వ్యవస్థీకరణ బిల్లు లోక్‌సభలో రాజ్యాంగబద్ధంగా ఆమోదం పొందలేదు.(AP Reorganisation Bill did not receive acceptance of Lok Sabha, as per Constitutional Provisions).
రాజ్యాంగంలోని 367-3 నిబంధన ప్రకారం కూడా హెడ్‌ కౌంట్‌ జరపలేదు. (Head count also was not conducted as per Art. 367-3.)
జైపాల్‌ రెడ్డి సూచన మేరకు అప్పటి స్పీకర్‌ మీరా కుమార్‌ లోక్‌సభలో ‘30... 70’ అంటూ లెక్కించినట్లు నటించారు. (As per the advice of Shri Jaipal Reddy, the then Speaker Ms. Mira Kumar, had acted/pretended the counting '30...70').
ఆ తర్వాత ఆ కౌంటింగ్‌ను కూడా వదిలేశారు. (After that, she has left even the counting).

బిల్లు ఆమోదం పొందిందని నిర్ధరించినా.. ఆమోదం పొందలేదని తేల్చినా మళ్లీ ఉమ్మడి రాష్ట్రం ఏమీ రాదు. అటువంటి ఆలోచన కూడా నాకు లేదు. (I know that, we cannot get back our United State, even if it is confirmed that the bill did not receive the acceptance of Lok Sabha. I have no such thinking/idea.)

అయితే, రాష్ట్ర విభజన సందర్భంగా జరిగిన తప్పులు భవిష్యత్తులో పునరావృతం కాకూడదg. అన్న ఉద్దేశంతోనే నేను వాటిని అక్షరబద్ధం చేశాను. (However, with an intent that the errors/mistakes/irregularities which have taken place during the State's Bifurcation should not recur, I have reproduced them in writing).


ybrao-a-donkey's humble views. वैबीराव गधे के विनम्र राय . వైబీరావు గాడిద వినమ్ర అభిప్రాయం



Supreme Court, could have, if it wanted to, prevented this unjust cruel bifurcation of United Andhra Pradesh, had it acted in time. Even at the cost of incurring the wrath of Supreme Court for contempt of court, I must say that, Supreme Court declined to intervene, in response to writ petitions filed by aggrieved persons from Residual Andhra Pradesh, For every petition, Supreme Court / High Courts were telling 'too early', 'come later' etc. Now, when the High Courts / Supreme Courts deal with the petitions, they will say "Now, it is fait accompli. Everything is over. We can't turn back the clock etc. etc.". This is the misfortune of people living in Residual Andhra Pradesh. Of course, they are also Indians. They are not aliens.

It is a tradition in India, that the neighbors do not bother about what happens for their fellow-neighbors.

When Alexander invaded India, and trampled on Paurus, one King Ambhi helped Alexander, instead of Paurus. Kings of all other neighborhood kingdoms did not bother. When Greek soldiers were marching tromping on ripe fields, farmers in the neighboring fields went on doing their own chores, unconcerned about what was befelling to their fellow farmers.

In the same way, people of other States did not bother, when Andhra Pradesh Bifurcation Bill was passed (pretended to have been passed) in Lok Sabha, through dubious means, on 18th Feb. 2014, closing its doors, switching off TV cameras, people of other States might have thought that they did not have any concern with it. What they ought to be beware about is: this type of closing Lok Sabha doors, switching off cameras, etc. by joint conspiracies of the Ruling Party (Congress) and the Main Opposition Party (BJP), may recur again. Only thing is, roles may change. Ruling Party may become Opposition Party, and the Opposition Party may become a Ruling Party.

Next turn may come for some other State's bifurcation. Or for some other purpose such as introducing reservation for some caste, or removing reservation for some other caste.

With due respect to Ms. Meera Kumar, I must say that she has not followed minimum principles of democratic governance. Whatever the rules may say, a Speaker has to adhere to a minimum sense of decency, dignity, and propriety. After all, bifurcation of a State is not as simple as cutting an apple or a bread into slices. This is particularly true, when one party is vehemently in favor of it, and another party is against it. It is not that amicable solutions were not available. The truth is, neither the Ruling Party nor the Opposition Party (BJP) were not willing to work out an amicable solution. Because, both of them wanted to curry favour with KCR & Co., and conquer Telangana, claiming themselves as their benefactors. Speaker of Lok Sabha was just a tool.

Since both the Congress and BJP both were supporting the Bifurcation, the Bill could have been passed by following more democratic practices. Considering the seriousness involved in Andhra Pradesh Bifurcation, even voting "Division" is not sufficient, because members cannot express their true intent openly. Secret Ballot alone could have obtained the true majority intent of all the Lok Sabha Members. Leaving aside the crucial question of "oppression of minority" by majority in a house (Lok SabhaMembers belonging to Residual Andhra Pradesh were driven out of the House on that day), at least the FREE CONSENT OF THE REMAINING MEMBERS PRESENT ought to have been obtained in a democratic manner. If the House was not in order that day, Secret Ballot ought to have been conducted next day. Why didn't Ms. Meera Kumar chose a Secret Ballot?

Why did Ms. Meera Kumar prefer a violent method of closing Lok Sabha doors? If Lok Sabha Cameras did not function (Lok Sabha cameras could have shown transparently the proceedings of the House, as to whether they were being conducted in a fair and just manner), why Ms. Meera Kumar could not wait for their setting up right by the Technicians? Lok Sabha might have employed Service Engineers and Technicians for spot repairs. Why didn't she wait?

The people of Residual Andhra Pradesh, the People's Representatives of Residual Andhra Pradesh were also not against Bifurcation, provided it is done in a fair and just manner. KCR & Company has numerous ulterior motives. Actually, they wanted to drive out all the people of Residual Andhra Pradesh from the City of Hyderabad, and buy all the Real Estates of Hyderabad at throw away prices, or occupy the homes vacated by Residual Andhra People who were living in Hyderabad, because it was the State Capital. It is something similar to what has happened in Pakistan in 1947, when Hindus migrated to India (that was a bizarre experience.). KCR does not seem to be doing it now, because the property prices rise has somewhat slowed down, because now Hyderabad will have floating populaation only from 10 Districts. It will take sometime for Hyderabad to recapture recoup its real estate demand and prices. Of course, that will happen, but it will be at a lower scale. Now Hyderabad, will be like Bhopal or Lucknow or Patna. Of course, it will DO GOOD to both the residents of Hyderabad and the people of Telangana. (Yet, I always have a personal feeling that Telangana should be split into two smaller States North Telangana and South Telangana).

Both Congress and BJP National Leaders pampered KCR, with selfish motives. Congress thought that KCR would merge his TRS with their Party after the bifurcation. He gave them a hand. BJP thought that they could make a dent in Telangana. Ms. Sushma Swaraj called herself 'Chinnamma' (younger maternal aunt) of Telangana, with Ms. Sonia Gandhi being the 'peddamma' (elder maternal aunt), of Telangana. Thus Telanana State had the blessings of both the 'peddamma' and 'chinnamma'. And the people of Residual Andhra Pradesh were orphans. ayyO !!!

Mr. Nara Chandra Babu Naidu, the present Chief Minister of Andhra Pradesh, was jubilant, because he was dreaming of the Rs. 5,00,000/- crore (5000 billion Rupees, or about $80 billion) which the Central Government would be giving him for constructing a New Capital for Andhra Pradesh. (It is a different thing, that his dreams have gone haywire, because Mr. Narendra Modi has got full majority in Lok Sabha, and Mr. Nara Chandra Babu Naidu has become a persona non grata in the eyes of BJP).

Mr. Y.S. Jaganmohan Reddy too had his own dreams, after his bitter nightmarish experience at Mahaboobabad Railway Station (also called mAnu kOTa, a castle of Wood), in Warangal District. Notwithstanding strong cases of Quid pro Quo cases against him which are sub-judice, he is instigating people for a Special Status.

We should not forget the role of Mr. Venkaiah Naidu in this sordid drama. In Rajya Sabha, he asked for 10 years Special Status to Andhra Pradesh. Today he says that Special Status is an 'ajAgaLa stanam' (the beard of a goat, which is sometimes erroneously taken as breasts of a goat. Just as a goat's beard cannot yield milk, Special Status also cannot yield benefits. This was true, even at the time of passing of the AP Bifurcation Bill in Lok Sabha. But then, why did Mr. Manmohan Singh promise it? Why did Mr. Venkaiah Naidu support it, asking for 10 years? For this fiasco, and volta face, if Mr. Venkaiah Naidu, has any sense of self-respect, he ought to have resigned and apologised to the people of the Residual Andhra Pradesh. He will not do. People of Residual Andhra Pradesh do not ask him. Instead, they felicitate him.

I wish to reiterate my personal view that the present Residual Andhra Pradesh needs to be divided into three smaller States: 1. North Andhra 2. South Andhra 3. Rayala Sima (if possible + Bellary + North Arcot + Gadwal-Alampur-Wanparty). Else, they will remain backward.

TAIL PIECE. धूमकेतु తోకచుక్క



Deccan Chronicle.com has published a news item that English Oxford Dictionary has included an Indian word 'Aiyoh', in its lexicon. The word is a sort of interjection, to indicate despair.

Many people may not know, the word has a Telugu language origin- 'ayyO'. It may be a result of combination of 'ayya + Oh!'. Ayya in Telugu language means = father. This father can be a biological father, or the God himself, who is also regarded as 'Father' globally, in almost all the religions. Thus its intended meaning of despair will be "Oh my God!". The word 'ayyO' might have had a cowherd / shepherd origin. Usually, cowherd / shepherd boys are entrusted to guard their cattle / sheep in fields, hills and dales. When the boys felt lonely or when they find something threatening to themselves or to the cattle/sheep, they call their father loudly 'ayyO' , meaning O father ! Come immediately and rescue us.

There is also a good Telugu film song called 'ayyayyo cEtilo Dabbulu pOyenE ', in the Telugu film kula gOtrAlu. English: Alas! The money in the hands is lost. (In that Telugu film, actor Late Ramana Reddy lost all his money in gambling with playing cards. He was expressing his despair).

My own personal experiene with 'ayyo'. अय्यो से मेरा स्वयं अनुभव. అయ్యో తో నా స్వంత అనుభవం



About four/five years back, I was searching on the Net for a 'free web-host' sub-domain, who will permit me to use my php scripts. At that time, I have developed a huge data with 25,000 Multiple Choice Questions for Competitive Examinations, with onling answering, and online comparison of marks and results.

At that time, I found such facility was available at a site by name Zymic.Com. While I was registering with them, I was asked to choose a sub-domain name, with NOT LESS THAN FOUR LETTERS. They have reserved all the sub-domains of less than four words for themselves. Hence, Minimum four letters were apparently made compulsory. I have tried several four-letter names of all languages, decent, mediocre, ugly, whatever occurred to my mind. Every request, their software turned down saying 'already booked / Not available'. Finally, in despair, I typed 'ayyo'. It got accepted. It was how, my first sub-domain http://ayyo.zxq.net was born. It was available for some years, free on the net, kind courtesy Zymic.Com. But, one fine morning, I found it disappeared. Probably, the Free-host might have removed it, because of low activity. ayyO !!! = Alas.

Then, I searched for another freehost. I continued the old name "ayyO'. My readers can visit this Multiple Choice Questions page in 1000 Subjects, at Click to go to http://ayyo.x10.mx. Kind courtesy Xhosting.Com. At this sub-domain you can see my Mahabharata Vyasa multi-search, Telugu Verses Search, Thesaurus Search etc., apart from the 25,000 Multiple Choice Questions in 1000 Subjects, using a PHP script. Some of the GK questions need to be updated. Unfortunately, my priorities have changed. But, I hope, someday, I shall update, and add new questions there.

I have, after much search on net, with the help of numerous benefactors who have given suggestions/advice on net, developed a PHP script for development of User-modifiable dictionaries. In the next posts, I shall make available the phpscript for use of all our readers. The php script can be used both online and offline. For offline use, we need an apache2 server with local host. MySQL or SQLite3 or PostGreSql or XML will not be necessary. If my readers wish to have their own online dictionaries, they may need sub-domains / their own websites which permit php scripts.

To continue.

From Post Nos. 001 to 500

1      |      2      |      3      |      4      |      5      |      6      |      7      |      8      |      9      |      10      |      11      |      12      |      13      |      14      |      15      |      16      |      17      |      18      |      19      |      20      |     
21      |      22      |      23      |      24      |      25      |      26      |      27      |      28      |      29      |      30      |      31      |      32      |      33      |      34      |      35      |      36      |      37      |      38      |      39      |      40      |     
41      |      42      |      43      |      44      |      45      |      46      |      47      |      48      |      49      |      50      |      51      |      52      |      53      |      54      |      55      |      56      |      57      |      58      |      59      |      60      |     
61      |      62      |      63      |      64      |      65      |      66      |      67      |      68      |      69      |      70      |      71      |      72      |      73      |      74      |      75      |      76      |      77      |      78      |      79      |      80      |     
81      |      82      |      83      |      84      |      85      |      86      |      87      |      88      |      89      |      90      |     
91      |      92      |      93      |      94      |      95      |      96      |      97      |      98      |      99      |      100      |     

101      |      102      |      103      |      104      |      105      |      106      |      107      |      108      |      109      |      110      |      111      |      112      |      113      |      114      |      115      |      116      |      117      |      118      |      119      |      120      |     
121      |      122      |      123      |      124      |      125      |      126      |      127      |      128      |      129      |      130      |      131      |      132      |      133      |      134      |      135      |      136      |      137      |      138      |      139      |      140      |     
141      |      142      |      143      |      144      |      145      |      146      |      147      |      148      |      149      |      150      |      151      |      152      |      153      |      154      |      155      |      156      |      157      |      158      |      159      |      160      |     
161      |      162      |      163      |      164      |      165      |      166      |      167      |      168      |      169      |      170      |      171      |      172      |      173      |      174      |      175      |      176      |      177      |      178      |      179      |      180      |     
181      |      182      |      183      |      184      |      185      |      186      |      187      |      188      |      189      |      190      |      191      |      192      |      193      |      194      |      195      |      196      |      197      |      198      |      199      |      200      |     

201      |      202      |      203      |      204      |      205      |      206      |      207      |      208      |      209      |      210      |      211      |      212      |      213      |      214      |      215      |      216      |      217      |      218      |      219      |      220      |     
221      |      222      |      223      |      224      |      225      |      226      |      227      |      228      |      229      |      230      |      231      |      232      |      233      |      234      |      235      |      236      |      237      |      238      |      239      |      240      |     
241      |      242      |      243      |      244      |      245      |      246      |      247      |      248      |      249      |      250      |      251      |      252      |      253      |      254      |      255      |      256      |      257      |      258      |      259      |      260      |     
261      |      262      |      263      |      264      |      265      |      266      |      267      |      268      |      269      |      270      |      271      |      272      |      273      |      274      |      275      |      276      |      277      |      278      |      279      |      280      |     
281      |      282      |      283      |      284      |      285      |      286      |      287      |      288      |      289      |      290      |      291      |      292      |      293      |      294      |      295      |      296      |      297      |      298      |      299      |      300      |     

301      |      302      |      303      |      304      |      305      |      306      |      307      |      308      |      309      |      310      |      311      |      312      |      313      |      314      |      315      |      316      |      317      |      318      |      319      |      320      |     
321      |      322      |      323      |      324      |      325      |      326      |      327      |      328      |      329      |      330      |      331      |      332      |      333      |      334      |      335      |      336      |      337      |      338      |      339      |      340      |     
341      |      342      |      343      |      344      |      345      |      346      |      347      |      348      |      349      |      350      |      351      |      352      |      353      |      354      |      355      |      356      |      357      |      358      |      359      |      360      |     
361      |      362      |      363      |      364      |      365      |      366      |      367      |      368      |      369      |      370      |      371      |      372      |      373      |      374      |      375      |      376      |      377      |      378      |      379      |      380      |     
381      |      382      |      383      |      384      |      385      |      386      |      387      |      388      |      389      |      390      |      391      |      392      |      393      |      394      |      395      |      396      |      397      |      398      |      399      |      400      |     
401      |      402      |      403      |      404      |      405      |      406      |      407      |      408      |      409      |      410      |      411      |      412      |      413      |      414      |      415      |      416      |      417      |      418      |      419      |      420      |     
421      |      422      |      423      |      424      |      425      |      426      |      427      |      428      |      429      |      430      |      431      |      432      |      433      |      434      |      435      |      436      |      437      |      438      |      439      |      440      |     
441      |      442      |      443      |      444      |      445      |      446      |      447      |      448      |      449      |      450      |      451      |      452      |      453      |      454      |      455      |      456      |      457      |      458      |      459      |      460      |     
461      |      462      |      463      |      464      |      465      |      466      |      467      |      468      |      469      |      470      |      471      |      472      |      473      |      474      |      475      |      476      |      477      |      478      |      479      |      480      |     
481      |      482      |      483      |      484      |      485      |      486      |      487      |      488      |      489      |      490      |      491      |      492      |      493      |      494      |      495      |      496      |      497      |      498      |      499      |      500      |     
Remaining 500 posts are at the bottom. మిగిలిన 500 పోస్టులు (501 to 1000) క్రింది భాగంలో ఉన్నాయి. बाकी ५०० पोस्ट् निम्न भाग में है।


501 to 1000 Post Nos. here.

Post Nos. 1 to 500 are at the top.
501      |      502      |      503      |      504      |      505      |      506      |      507      |      508      |      509      |      510      |      511      |      512      |      513      |      514      |      515      |      516      |      517      |      518      |      519      |      520      |     
521      |      522      |      523      |      524      |      525      |      526      |      527      |      528      |      529      |      530      |      531      |      532      |      533      |      534      |      535      |      536      |      537      |      538      |      539      |      540      |     
541      |      542      |      543      |      544      |      545      |      546      |      547      |      548      |      549      |      550      |      551      |      552      |      553      |      554      |      555      |      556      |      557      |      558      |      559      |      560      |     
561      |      562      |      563      |      564      |      565      |      566      |      567      |      568      |      569      |      570      |      571      |      572      |      573      |      574      |      575      |      576      |      577      |      578      |      579      |      580      |     
581      |      582      |      583      |      584      |      585      |      586      |      587      |      588      |      589      |      590      |      591      |      592      |      593      |      594      |      595      |      596      |      597      |      598      |      599      |      600      |     


601      |      602      |      603      |      604      |      605      |      606      |      607      |      608      |      609      |      610      |      611      |      612      |      613      |      614      |      615      |      616      |      617      |      618      |      619      |      620      |     
621      |      622      |      623      |      624      |      625      |      626      |      627      |      628      |      629      |      630      |      631      |      632      |      633      |      634      |      635      |      636      |      637      |      638      |      639      |      640      |     
641      |      642      |      643      |      644      |      645      |      646      |      647      |      648      |      649      |      650      |      651      |      652      |      653      |      654      |      655      |      656      |      657      |      658      |      659      |      660      |     
661      |      662      |      663      |      664      |      665      |      666      |      667      |      668      |      669      |      670      |      671      |      672      |      673      |      674      |      675      |      676      |      677      |      678      |      679      |      680      |     
681      |      682      |      683      |      684      |      685      |      686      |      687      |      688      |      689      |      690      |      691      |      692      |      693      |      694      |      695      |      696      |      697      |      698      |      699      |      700      |     


701      |      702      |      703      |      704      |      705      |      706      |      707      |      708      |      709      |      710      |      711      |      712      |      713      |      714      |      715      |      716      |      717      |      718      |      719      |      720      |     
721      |      722      |      723      |      724      |      725      |      726      |      727      |      728      |      729      |      730      |      731      |      732      |      733      |      734      |      735      |      736      |      737      |      738      |      739      |      740      |     
741      |      742      |      743      |      744      |      745      |      746      |      747      |      748      |      749      |      750      |      751      |      752      |      753      |      754      |      755      |      756      |      757      |      758      |      759      |      760      |     
761      |      762      |      763      |      764      |      765      |      766      |      767      |      768      |      769      |      770      |      771      |      772      |      773      |      774      |      775      |      776      |      777      |      778      |      779      |      780      |     
781      |      782      |      783      |      784      |      785      |      786      |      787      |      788      |      789      |      790      |      791      |      792      |      793      |      794      |      795      |      796      |      797      |      798      |      799      |      800      |     

801      |      802      |      803      |      804      |      805      |      806      |      807      |      808      |      809      |      810      |      811      |      812      |      813      |      814      |      815      |      816      |      817      |      818      |      819      |      820      |     
821      |      822      |      823      |      824      |      825      |      826      |      827      |      828      |      829      |      830      |      831      |      832      |      833      |      834      |      835      |      836      |      837      |      838      |      839      |      840      |     
841      |      842      |      843      |      844      |      845      |      846      |      847      |      848      |      849      |      850      |      851      |      852      |      853      |      854      |      855      |      856      |      857      |      858      |      859      |      860      |     
861      |      862      |      863      |      864      |      865      |      866      |      867      |      868      |      869      |      870      |      871      |      872      |      873      |      874      |      875      |      876      |      877      |      878      |      879      |      880      |     
881      |      882      |      883      |      884      |      885      |      886      |      887      |      888      |      889      |      890      |      891      |      892      |      893      |      894      |      895      |      896      |      897      |      898      |      899      |      900      |     


901      |      902      |      903      |      904      |      905      |      906      |      907      |      908      |      909      |      910      |      911      |      912      |      913      |      914      |      915      |      916      |      917      |      918      |      919      |      920      |     
921      |      922      |      923      |      924      |      925      |      926      |      927      |      928      |      929      |      930      |      931      |      932      |      933      |      934      |      935      |      936      |      937      |      938      |      939      |      940      |     
941      |      942      |      943      |      944      |      945      |      946      |      947      |      948      |      949      |      950      |      951      |      952      |      953      |      954      |      955      |      956      |      957      |      958      |      959      |      960      |     
961      |      962      |      963      |      964      |      965      |      966      |      967      |      968      |      969      |      970      |      971      |      972      |      973      |      974      |      975      |      976      |      977      |      978      |      979      |      980      |     
981      |      982      |      983      |      984      |      985      |      986      |      987      |      988      |      989      |      990      |      991      |      992      |      993      |      994      |      995      |      996      |      997      |      998      |      999      |      1000      |     

From 1001 (In gradual progress)

1001      |      1002      |      1003      |      1004      |      1005      |      1006      |      1007      |      1008      |      1009      |     
1010      |           |     
1011      |      1012      |      1013      |      1014      |      1015      |     
1016      |      1017      |      1018      |      1019      |      1020      |     


1021      |      1022      |      1023      |      1024      |      1025      |     
1026      |      1027      |      1028      |      1029      |      1030      |     


     |      1031      |           |      1032      |           |      1033      |           |      1034      |           |      1035      |           |      1036      |      1037      |      1038      |      1039      |      1040      |     


     |      1041      |      1042      |      1043      |           |      1044      |           |      1045      |     


     |      1046      |      1047      |      1048      |           |      1049      |           |      1050      |     

     |      1051      |      1052      |      1053      |           |      1054      |           |      1055      |     
     |      1056      |      1057      |      1058      |           |      1059      |           |      1060      |     
     |      1061      |      1062      |      1063      |           |      1064      |           |      1065      |     
     |      1066      |      1067      |      1067      |      1068      |      1069      |      1069      |      1070      |     
     |      1071      |      1072      |      1073      |      1074      |      1075      |      1076      |     
1077      |      1078      |      1079      |      1080      |     
     |      1081      |      1082      |      1083      |      1084      |      1085      |      1086      |     
1087      |      1088      |      1089      |      1090      |     
     |      1091      |      1092      |      1093      |      1094      |      1095      |      1096      |     
1097      |      1098      |      1099      |      1100      |     
     |      1101      |      1102      |      1103      |      1104      |      1105      |      1106      |     
1107      |      1108      |      1109      |      1110      |