<?xml version='1.0'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:georss="http://www.georss.org/georss" xmlns:atom="http://www.w3.org/2005/Atom" >
<channel>
	<title><![CDATA[BOL: Insert data through ajax into MySql database.]]></title>
	<link>https://bioinformaticsonline.com/blog/view/36413/insert-data-through-ajax-into-mysql-database?</link>
	<atom:link href="https://bioinformaticsonline.com/blog/view/36413/insert-data-through-ajax-into-mysql-database?" rel="self" type="application/rss+xml" />
	<description><![CDATA[]]></description>
	
	<item>
	<guid isPermaLink="true">https://bioinformaticsonline.com/blog/view/36413/insert-data-through-ajax-into-mysql-database</guid>
	<pubDate>Wed, 25 Apr 2018 12:43:51 -0500</pubDate>
	<link>https://bioinformaticsonline.com/blog/view/36413/insert-data-through-ajax-into-mysql-database</link>
	<title><![CDATA[Insert data through ajax into MySql database.]]></title>
	<description><![CDATA[<p>Insert data through ajax into MySql database.1. Create form.php and copy below code into file.</p><blockquote><p>&lt;script type="text/javascript"&gt;<br /> <br /> $(document).ready(function(){<br /> $('#submit').click(function(){<br /> var name= $('#name').val();<br /> var email= $('#email').val();<br /> var sdatatring='name1='+ name +'&amp;email1='+ email;<br /> $.ajax({<br /> type:"POST",<br /> url:"insert.php",<br /> data:sdatatring,<br /> cache: false,<br /> success:function(result){<br /> alert(result);</p><p>}});</p><p>});</p><p>});<br />&lt;/script&gt;<br /> &lt;form method="post" action="" name="frm"&gt;<br /> Name:&lt;input type="text" name="name" id="name" value=""&gt;&lt;br&gt;<br /> Email:&lt;input type="text" name="email" id="email" value=""&gt;&lt;br&gt;<br /> &lt;input type="button" name="submt" id="submit" value="submit" /&gt;<br /> <br /> &lt;/form&gt;</p><p>2. Create insert.php and copy below code into file.<br /> &lt;?php<br />print_r($_POST);<br />$con=mysql_connect("localhost","root","");<br />mysql_select_db('dbname');<br />mysql_query('insert into tablename('colname')values(value)');<br /> ?&gt;<br />Note:You need to include jQuery library in form.php.</p></blockquote><p>More at</p><p>https://phpajaxhtml.blogspot.in/2018/03/insert-data-through-ajax-into-mysql.html</p>]]></description>
	<dc:creator>Ram Yash Pal</dc:creator>
</item>

</channel>
</rss>