Skip to main content

How to Simple Wiktionary data stored in MySQL

Wiktionary.php

Wiktionary.php is a PHP "library" to convert Simple Wiktionary HTML page convert to text and find out the definition of the word. MySQL Database connection to store a definition of each word, select.php?word="" to fetch data from the database, display in Json format and database can't fetch data of word internal call to the simple Wiktionary website to fetch the data to be stored in MySQL database and display to JSON format.

Supported Syntax

  • == Heading ==
  • === Subheading ===
  • ==== Subsubheading ====
  • ''''' Bold-italic '''''
  • ''' Bold '''
  • '' Italic ''
  • ---- Horizontal Line
  • : Indentation
  • :: Subindentation
    • Unordered list (up to four levels "**** text")
  • Ordered list (up to four levels "#### text")

  • [[file:http://example.com/image.jpg title]] an image ([[file|img:http|https|ftp://example.com/image.jpg optional]])
  • [http://example.com An Example Link] a link ([http|https|ftp://example.com optional])
  • #: example of word

Howto use

// Include the library (obviously)
require_once("wiky.inc.php");

// Create a new wiky to any variable You'd like. Could be $mooming
// If you pass true to __construct (new wiky(true)), "S" PCRE modifier will be added to all regular expressions. This gives a performance boost when running parse thousands of times. Extreme usage only.
$wiky=new wiky;

// Call for the function parse() on the variable You created and pass some unparsed text to it, it will return parsed HTML or false if the content was empty. In this example we are loading the file input.wiki, escaping all html characters with htmlspecialchars, running parse and echoing the output
$input=file_get_contents("input.wiki");
$input=htmlspecialchars($input);
echo $wiky->parse($input);

Command Line to list of data stored in database

// word_list.list are many number of word

$ php word_select.php > log.json

$ sudo vi word_list.list

// Output :
[
 {
     "word": "addition",
     "text": [
         "Addition",
         "The part of arithmetic where numbers are added together.",
         "The act of adding something.",
         "Anything that is added."
     ]
 }
] 

Author

Manish Kumar Paner
https://github.com/ManishPaneri/wiktionary.php

Comments

Popular posts from this blog

Java Currency Formatter Solution

Given a  double-precision  number,  , denoting an amount of money, use the  NumberFormat  class'  getCurrencyInstance  method to convert   into the US, Indian, Chinese, and French currency formats. Then print the formatted values as follows: US: formattedPayment India: formattedPayment China: formattedPayment France: formattedPayment where   is   formatted according to the appropriate  Locale 's currency. Note:  India does not have a built-in Locale, so you must  construct one  where the language is  en  (i.e., English). Input Format A single double-precision number denoting  . Constraints Output Format On the first line, print  US: u  where   is   formatted for US currency.  On the second line, print  India: i  where   is   formatted for Indian currency.  On the third line...

Java Loops II print each element of our series as a single line of space-separated values.

We use the integers  ,  , and   to create the following series: You are given   queries in the form of  ,  , and  . For each query, print the series corresponding to the given  ,  , and   values as a single line of   space-separated integers. Input Format The first line contains an integer,  , denoting the number of queries.  Each line   of the   subsequent lines contains three space-separated integers describing the respective  ,  , and   values for that query. Constraints Output Format For each query, print the corresponding series on a new line. Each series must be printed in order as a single line of   space-separated integers. Sample Input 2 0 2 10 5 3 5 Sample Output 2 6 14 30 62 126 254 510 1022 2046 8 14 26 50 98 Explanation We have two queries: We use  ...

Java Static Initializer Block

Static initialization blocks are executed when the class is loaded, and you can initialize static variables in those blocks. It's time to test your knowledge of  Static initialization blocks . You can read about it  here. You are given a class  Solution  with a  main  method. Complete the given code so that it outputs the area of a parallelogram with breadth   and height  . You should read the variables from the standard input. If   or    , the output should be  "java.lang.Exception: Breadth and height must be positive"  without quotes. Input Format There are two lines of input. The first line contains  : the breadth of the parallelogram. The next line contains  : the height of the parallelogram. Constraints Output Format If both values are greater than zero, then the  main  method must output the area of the  parallelogram . Otherwise, pri...