Saturday, 25 February 2017

how to insert Mathmetical Symbol into mysql database

06:12

Selecting    UTF-8 as default server charset.

Also I created a test database and a table as follows:
(1)The database:
CREATE DATABASE `test` /*!40100 CHARACTER SET utf8 COLLATE utf8_general_ci */

(2)The table:
CREATE TABLE `math` (
    `id` INT(10) NOT NULL,
    `symbol` CHAR(1) NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
ROW_FORMAT=DEFAULT

(3)Then write code for    testing given below to  insert  symbol   ∑ :
<?php
$con=mysqli_connect("localhost","root","","abhi");
mysqli_set_charset($con,"utf8");
$sql="insert into cat1(c_name)values('∑')";
mysqli_query($con,$sql);
?>


and  if  you want to go for  inserting   Mathematic  Equation  into your  Mysql Database then follow  given  instruction:



  • Convert the math symbols to their corresponding Unicode Entities
  • Make sure your MySql database is unicode compliant
  • Store the "unicodified"  data in the database
  • After retrieving the data from mysql, you may need to convert the unicode characters to their corresponding html entities so that the browser can display them.

Written by

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.

2 comments:

  1. Thanks for sharing information about PHP programming language, I read your entire post and realize that your post is really informative. Such type of post is really helpful for those people who want to learn PHP programming language. Apart from this I read another informative post for same kind of information. For your further information I am sharing that informative post about PHP programming language. http://www.ducatindia.com/phpsixmonthstraining/

    ReplyDelete
  2. Thanks for sharing this blog. Really good information. Insert Mathematical Symbol Into MySQL Database is useful for PHP learners. Learn MySQL PHP Training in Bangalore. VISSICOMP offers finest training in Mumbai

    ReplyDelete

PHP Training Mumbai, PHP MySQL Training Mumbai, PHP Course Mumbai, PHP Institute Mumbai

 

© 2013 PHP TRAINING IN MUMBAI BY OM SIR . All rights resevered. Designed by OM SIR

Back To Top