Insert data through ajax into MySql database.

1. Create form.php and copy below code into file.

<script type="text/javascript">

$(document).ready(function(){
$('#submit').click(function(){
var name= $('#name').val();
var email= $('#email').val();
var sdatatring='name1='+ name +'&email1='+ email;
$.ajax({
type:"POST",
  url:"insert.php",
  data:sdatatring,
  cache: false,
  success:function(result){
  alert(result);

  }});


});

});
</script>
  <form method="post" action="" name="frm">
  Name:<input type="text" name="name" id="name" value=""><br>
  Email:<input type="text" name="email" id="email" value=""><br>
  <input type="button" name="submt" id="submit" value="submit" />
 
  </form>

 2. Create insert.php and copy below code into file.
 <?php
print_r($_POST);
$con=mysql_connect("localhost","root","");
mysql_select_db('dbname');
mysql_query('insert into tablename('colname')values(value)');
 ?>
Note:You need to include jQuery  library in form.php.

bloginfo() function in wordpress.

Displays information about the current site.



Get data about your site, for the most part assembled from the data you supply in your User Profile and General Settings WordPress Administration Screens. It can be utilized anyplace inside a layout record. This dependably prints an outcome to the program. If you need the values for use in PHP, use bloginfo() function.
bloginfo() function not a PHP function, it's created by WordPress.


Example:

"name" – Get the "Site Title", This data is retrieved from the "blogname" record in the wp_options table.
<?php echo bloginfo('name'); ?>

"description" – Get the "Tagline", This data is retrieved from the "blogdescription" record in the wp_options table.
<?php echo bloginfo('description'); ?>

also you can use (wpurl,url,admin_email,charset,version,html_type,text_direction,language,stylesheet_url,stylesheet_directory,template_url,pingback_url,atom_url,rdf_url,rss_url,rss2_url,comments_atom_url,rdf_url,rss_url,rss2_url,comments_atom_url,comments_rss2_url)

"siteurl" – Deprecated since version 2.2. Echo home_url(), or use bloginfo("url").
"home" – Deprecated since version 2.2. Echo home_url(), or use bloginfo("url").

What is WordPress Memory Limit Error?

WordPress is composed in PHP, which is a server-side programming dialect. Each site needs a WordPress facilitating server for it to work legitimately.

Web servers are much the same as some other PC. They require memory to effectively run different applications in the meantime. Server managers apportion particular memory size to various applications including PHP.

At the point when your WordPress code requires more memory than the default designated memory, you get the opportunity to see this mistake.

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 2348617 bytes) in /home4/example/public_html/wp-includes/plugin.php on line 356



By default, WordPress automatically tries to increase PHP memory limit if it is less than 64MB. However, 64MB is often not high enough.

Having said that, let’s see how to easily increase PHP memory limit in WordPress to avoid memory exhausted error.

Increase PHP Memory Limit in WordPress
First you need to edit the wp-config.php file on your WordPress site. It is located in your WordPress site’s root folder, and you will need to use an FTP client or file manager in your web hosting control panel.

Next, you need to paste this code in wp-config.php file just before the line that says ‘That’s all, stop editing! Happy blogging.’

define( 'WP_MEMORY_LIMIT', '256M' );
This code tells WordPress to increase the PHP memory limit to 256MB.

Once you are done, you need to save your changes and upload your wp-config.php file back to your server.