December 2014 - Estuff Code - Advanced Coding Blog

How to Export Data into CSV file using PHP and Functions.

<div dir="ltr" style="text-align: left;" trbidi="on">
In this Tutorial, We are going to show you how to export data into CSV file using PHP and Functions. Just create a table with following fields written below and insert data into it. But note here that we have created one date field with date set value.<br />
<br />
In this, we have connect database and hostname with server in the beginning and then use the following query for retrieve data and write into the CSV file using PHP function. you can use this script into your live projects. its very important in larger project.<br />
If you are familiar with PHP and its function then you can easily use this script according to your need.<br />
<pre class="brush:php;">

<!--php

// Database Connection or include dbconnection.php

$host="localhost";
$uname="root";
$pass="";
$db = "estuffcode"; 
$conn=mysql_connect($host,$uname,$pass); // connection of host to server

echo mysql_error();

$selectdb=mysql_select_db($db) or 
     die("Database could not be selected"); 
$result=mysql_select_db($db)
     or die("database cannot be selected <br-->");

// These are the fields of database table from where we are retrieving data.
$myArr = "#, Transaction No, CAFID, MOBILE, COUNTRY GROUP, AMOUNT, RECEIPT NO, REQUEST DATE, STATUS, EXECUTIVE NAME, REMARKS"."\n";  	
  
if($_REQUEST['code']==1)
 {
     $nums = 1;
     $query = mysql_query("SELECT * from #_receipt ORDER BY pid DESC;");
     while ($line = mysql_fetch_array($query))
      {
            $myArr  .= $nums.",";
			$myArr  .= $line['$Transaction'].",";              
			$myArr  .= $line['$CAFID'].",";
			$myArr  .= $line['$MOBILE'].",";             
			$myArr  .= $line['$COUNTRY'].",";             
			$myArr  .= $line['$AMOUNT'].",";
			$myArr  .= $line['$RECEIPT'].",";
			$myArr  .= date("d-m-Y", $line['$REQUEST']).",";
			$myArr  .= $line['$STATUS'].",";             
			$myArr  .= $line['$EXECUTIVE'].",";
			$myArr  .= $line['$REMARKS'].","."\n";
			
			$nums++;
	     }
	   	
	$fname = "Recharge_".time().'_report.csv';
	$fp    = fopen($fname,'w');
	fwrite($fp,$myArr);
	fclose($fp);
	
	// used header for downloading file or download option from browser.
	header('Content-type: application/csv');
	header("Content-Disposition: inline; filename=".$fname);
	readfile($fname);
	unlink($fname);
  }

?>

</pre>
If still you have any query or problem regarding this Export data into the .CSV file then feel fre to contact us as soon as possible. we will contact and help you regarding the same.<br />
Don't forget to send feedback or comment in post.<br />
<br />
Thanks, Happy Coding.<br />

<br /></div>

How to Export Data into CSV file using PHP and Functions.

How to Export Data into CSV file using PHP and Functions.

In this Tutorial, We are going to show you how to export data into CSV file using PHP and Functions. Just create a table with following fie...

Explain MySQL and its Features and its Disadvantages?

<div dir="ltr" style="text-align: left;" trbidi="on">
<b>In this Tutorial</b>, We are going to introduce MySQL.<br />
MySQL is <b>RDBMS</b>(<b> Relational Database Management System</b>) which is an open source database. MySQL database is used for storing PHP variable values or Customer input so that it can be manipulate according to user and display on screen as output value.<br />
<br />
<b>There are some features we are going to introduce :-</b><br />
<br />
<b>1). </b>MySQL Performance is very high against access data from the database. This is possible due to its unique storage engine architecture.<br />
<b>2).</b> MySQL database supports many and large number of applications those makes it flexible.<br />
<b>3). </b>MySQL productivity is very Higher then other database due to Trigger, Views and stored procedures.<br />
<b>4). </b>MySQL Transaction can be roll back and crash recovery is possible into it.<br />
<br />
<br />
<b>Some Disadvantages about the MYSQL like :-</b><br />
<br />
<b>1).</b> MySQL can not be <b>ROLE</b>, stores Procedures and <b>COMMIT </b>in lesser version 5.0 into it.<br />
<b>2). </b>MySQL is unable to support large size database efficiently.<br />
<b>3).</b> In MYSQL, Transaction are unable to handle efficiently use of it.<br />
<br />
If you have any query regarding Code and any other language then feel free to contact us or Comment us below Comment area.<br />
<br />
We also Appreciate your feedback.<br />
Thanks,<br />
<br /></div>

Explain MySQL and its Features and its Disadvantages?

Explain MySQL and its Features and its Disadvantages?

In this Tutorial , We are going to introduce MySQL. MySQL is RDBMS ( Relational Database Management System ) which is an open source data...

How to Show Counter for Textarea or maxlength for Textarea Counter?

<div dir="ltr" style="text-align: left;" trbidi="on">
In this tutorial, We are showing how to add JavaScript Textarea character counter into the form. Using this, Just you have to add this below code into your page. Keep <script> -- code -- </script> tag into the </head> tag and other form code after body code.<br />
<br />
This is the running code you can use it directly into your project or browse into browser. After filling 500 character into the Textarea it will show you the alert type "Textarea value can only be 500 characters in length".<br />

<pre class="brush:php;">
<script type="application/javascript">
 function textareaCounter( field, countfield, maximumlimit ) 
    {
      if ( field.value.length > maximumlimit )
        {
           field.value = field.value.substring( 0, maximumlimit );
           alert('Textarea value can only be 500 characters in length.');
           return false;
        }
      else
        {
       countfield.value = maximumlimit - field.value.length;
        }
     }
</script>

</pre>
This part is your HTML part which you have to use into <body> </body> tag.<br />
<br />
<pre class="brush:php;"><form name="textcount" id="textcount">
 <textarea cols="60"  rows="12" class="input_field_textarea" id="description" name="description" onkeypress="textareaCounter(this,this.form.textcounter,500);" onblur="textareaCounter(this,this.form.textcounter,500);"></textarea>
 <br/>
 Max length - <input type="text" readonly="readonly" name="textcounter" maxlength="3" size="3" value="500" onblur="textareaCounter(this.form.textcounter,this,500);"> charters are remaining.
</form></pre>
<br />
You can also run this in same page. just copy both the written code and copy in same page then run in browser.<br />
If you are still facing any difficulty then feel free to contact us using the contact form or use Facebook page comment.<br />
Don't forget to send feedback Friends.<br />
<br />
Happy Coding<br />
Thanks,<br />
<div>
<br /></div>
</div>

How to Show Counter for Textarea or maxlength for Textarea Counter?

How to Show Counter for Textarea or maxlength for Textarea Counter?

In this tutorial, We are showing how to add JavaScript Textarea character counter into the form. Using this, Just you have to add this belo...

PHP interview questions fresher to 2 years experience - Mostly Asked Questions

<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Q1. How many type of header function in PHP? what are the uses of Header() Function in PHP?</b><br />
<b>Ans. </b><br />
In PHP Programming, It's very important to know about Header() function. Header function is always calles before the actual output code is send. For getting the result output we need to run function just before the HTML or any type of ECHO statement.<br />
There are the following uses of header function in PHP<br />
<br />
1). Header function is use to redirect the page to another page.<br />
2). Header function is used to send HTTP header to client at Browser.<br />
3). Header function is used to refresh the page at given time in function.<br />
4). Header function is used to send email content Example: - CC, BCC, Reply and data and other information.<br />
<br />
<b>Q2. In how many ways can we retrive the data from the database in the table?</b><br />
<b>Ans.</b><br />
We can retrive the data from the database with the help of 4 ways like: -<br />
<br />
1). mysqli_fetch_row  - By this method we get the result as an Enumerated array.<br />
2). mysqli_fetch_array - By this method we get the result in associated and numeric array.<br />
3). mysqli_fetch_object - By this method we get the result set as object.<br />
4). mysqli_fetch_assoc  - By this method we get the result with associative array.<br />
<br />
These are the 4 ways by that we can easily get the data result from the database.<br />
<br />
<b>Q3. What are the GET and POST Method in form Submit in PHP Programming?</b><br />
<b>Ans.</b> These Methods are used from the server side for sending data into the database.<br />
<br />
<b>1). GET Method </b>- In this Method, sent data display into the URL in Browser address. This method is used for sending the small amount of data and sensitive data take place into the GET Method.<br />

<b>2). POST Method </b>- In this Method, sent data doesn't display into the URL in browser address. This method is used for sending a large amount of data using browser. this post methods are used into banking web application  where data is more sensitive.<br />
<b>3). Request Method</b> - In this Method, We retrieve or receive the data from the Browser URL which is sent by GET or POST Method whatever is this.<br />
<br />
<b>Q4. What are the different type of errors and warnings in PHP Programming? </b><br />
<b>Ans.</b><br />
In PHP, There are 3 Types of errors.<br />
<b>1). Notices :</b>- Notices error generates when variable is not defined in the Web-Application.<br />
<b>2). Warnings : </b>- In this error, warning is show on error but page script do not terminates while executing the PHP page.<br />
<b>3). fatel errors : </b>- In this error, this type of errors occurs when not defined function or class is called. this errors immediate terminate the PHP script or page execution while running.<br />
<br />
<b>Q5. What is the Value of "$days" in the below written code? </b><br />
<b>Ans. </b><br />
<pre class="brush:php;">
$Tuesday= 1;    
$days = ($Tuesday==1) ? 'Today' : 'Tommorrow';
// $days is set to 'today'.

</pre>
This question was about <b>Ternary operator</b>. most of the companies ask the question about ternary operator because this operator has minimized the use of if else condition using this.<br />
<br />
<b>Q6. How to determine the total number of element of an array?</b><br />
<b>Ans.</b><br />
With the help of PHP functions we can easily determine the total number of elements into an array.<br />
<b>Example: - </b><br />
<br />
<b>1).</b> <b>sizeof</b>($array_variable)<br />
<b>2).</b> <b>count</b>($array_variable)<br />
But if we pass only simple variable instead of an array then it will return 1.<br />
<br />
<b>Q7. How to determine or find Current Date and Time?</b><br />
<b>Ans. </b><br />
With the Help of Date()  function we can find the or retrieve the current date and time value. but if we use only time() function then it will return only the unix timestamp.<br />
<br />
<b>Q8. What is the difference between these 2 variable -> $variable and $$variable? </b><br />
<b>Ans. </b><br />
$$variable sets the value of $variable as a variable.<br />
<pre class="brush:php;">
            $days='Tuesday';
            $$days='Second day of week';
            echo $Tuesday; 
   
     //outputs 'Second day of week'.
</pre>
<b>Q9. How to set and destroy cookie in PHP Programming?</b><br />
<b>Ans.</b><br />
<b>Cookies </b>are the flat files those stores into the users or clients computer when the visits any website. Don't worry about these files because it do not damage client computer.<br />
for setting the cookies: -  setcookie(name, value, expire, path, domain);<br />
We always set the cookie in past for destroying it.<br />
<br />
<b>Example:- </b><br />
setcookie("user", "ashok", time()+3600);<br />
setcookie("user", "", time()-3600); for destroy cookies from the system.<br />
<br />
<b>Q10. How can we find the number of rows in a result set using PHP? </b><br />
<b>Ans. </b><br />
For finding the number of rows from the database. we have to perform the following query and PHP function like.<br />
<b>Example: -</b><br />
<pre class="brush:php;">

$result_rows = mysql_query($sql_query, $db_link);
$num_of_rows = mysql_num_rows($result_rows);
echo $num_of_rows['field_name'];     // Number of rows found

</pre></div>

PHP interview questions fresher to 2 years experience - Mostly Asked Questions

PHP interview questions fresher to 2 years experience - Mostly Asked Questions

Q1. How many type of header function in PHP? what are the uses of Header() Function in PHP? Ans. In PHP Programming, It's very impor...

How to Remove Index.php from URL in Codeigniter or .htaccess if Codeigniter not working?

<div dir="ltr" style="text-align: left;" trbidi="on">
<b>In this Tutorial,</b> My Team is going to show and solving your problem related with i<b>ndex.php</b> page URL in Codeigniter.<br />
While Making the project we were suffering from this problem and searching for solution on other sites. but didn't found any solution regarding this problem But In the end I solved it. why it is not working on index.php and sub pages links not working without index.php page.<br />
<br />
I had seen many articles those has written same code only copy paste one another and we were searching for solution on different site.<br />
So Today, I am going to share you the exact code.<br />
<br />
If your site is on root directory or on root than open your htaccess file and paste below code as it is written.<br />
<pre class="brush:php;">
Options +FollowSymLinks All -Indexes<br />
Options All -Indexes<br />
DirectoryIndex index.php<br />
RewriteEngine on<br />
RewriteBase /<br />
RewriteCond %{REQUEST_FILENAME} !-f<br />
RewriteCond %{REQUEST_FILENAME} !-d<br />
RewriteRule .* index.php/$0 [PT,L]<br />
</pre>
But if your website is in the sub folder after the root like example: - <br />
<b>www.main site.com/yoursubfolder/</b><br />
<br />
Now here you have to paste this below code into the <b>.htaccess</b> file in codeigniter website.<br />
<pre class="brush:php;">
Options +FollowSymLinks All -Indexes<br />
Options All -Indexes<br />
DirectoryIndex index.php<br />
RewriteEngine on<br />
RewriteBase /yoursitefolder<br />
RewriteCond %{REQUEST_FILENAME} !-f<br />
RewriteCond %{REQUEST_FILENAME} !-d<br />
RewriteRule .* index.php/$0 [PT,L]<br />
</pre>
Along with this your have to perform some changes into your <b>config.php</b> file too.<br />
<br />
<b>application/config/config.php</b><br />
<pre class="brush:php;">
$config['index_page'] = '';<br />
$config['uri_protocol'] = 'REQUEST_URI';<br />
</pre>
If you still facing any problem then feel free to contact our Team.<br />
or you can mail us at - <b>estuffcode@gmail.com</b><br />
<br />
<b>Thanks,</b><br />
<div>
<br /></div>
</div>

How to Remove Index.php from URL in Codeigniter or .htaccess if Codeigniter not working?

How to Remove Index.php from URL in Codeigniter or .htaccess if Codeigniter not working?

In this Tutorial, My Team is going to show and solving your problem related with i ndex.php page URL in Codeigniter. While Making the pr...

How to use Alexa Ranking feature for your website using PHP?

<div dir="ltr" style="text-align: left;" trbidi="on">
<b>In this Tutorial,</b> We are going to show you How to Get Alexa rank for you website or blog.<br />
After searching or making changes into the coding. we created a function that will display you exact rank of you website.<br />
<br />
We had tried so many codes of Alexa those return rank of website but not exactly works fine for you and return always 0. So Due to this reason we had to make new script for getting Alexa rank.<br />
<br />
Just copy this code and paste it into your PHP file.<br />
<br />
<b>Note: - </b> If you use this code into your localhost server then it will also works fine and get back you the exact ran for your website.<br />
<pre class="brush:php;">

', $str1[1]));
        $str1 = explode('"', $str1);
        return $str1[3];
    }
echo "Your Alexa Ranking is: " . alexa_Rank("http://www.yahoo.com");
 ?>

</pre>
If this works for you also then just feel free and give comment below or send your feed back from contact form.<br />
You can also send your query too.<br />
<b><br /></b>
<b>Thanks,</b></div>

How to use Alexa Ranking feature for your website using PHP?

How to use Alexa Ranking feature for your website using PHP?

In this Tutorial, We are going to show you How to Get Alexa rank for you website or blog. After searching or making changes into the codi...

How to Set Currency Option in Dropdown in header at Homepage in Magento?

<div dir="ltr" style="text-align: left;" trbidi="on">
After Searching a wide area in programming, Finally got the option that how to set currency option in Drop-down.<br />
In this Tutorial, We are showing to set currency option in Drop-down way into the header on homepage in Magento. If you are managing currency option in Magento and unable to set Drop-down currency option then you have to follow Some Steps like: -<br />
<br />
Just go through the navigation below.<br />
<pre class="brush:php;">

1). Goto System -> Configuration -> GENERAL -> Currency Setup

2). In the left side menu option you have to find -> "Current Configuration  Scope".

3). Now Here, you have to select your desired store

4). Here in Currency Options" you will find "Default Display Currency".

5). Select any one from your desired currency from the selection list.

</pre>
you have to select the store you have done the above changes and you will find the price in Desired Currency.<br />
Now put this below code where you want to see your display currency converter.<br />
<br />
Use this into you store Theme where you want to show or display currency Drop-down option.<br />
<pre class="brush:php;">
getLayout()->createBlock('directory/currency')->setTemplate('directory/currency.phtml')->toHtml(); ?>

</pre>
Thanks<br />
If you still facing problem , Then you can contact me through Contact form.</div>

How to Set Currency Option in Dropdown in header at Homepage in Magento?

How to Set Currency Option in Dropdown in header at Homepage in Magento?

After Searching a wide area in programming, Finally got the option that how to set currency option in Drop-down. In this Tutorial, We are ...

How to Show Product category on right side or left side in Magento Commerce?

<div dir="ltr" style="text-align: left;" trbidi="on">
In this Tutorial, We are going to show How to display product category on right or left side with only simple changes.<br />
First we will have to build new block into the XML for displaying the category navigation like: -<br />
<br />
<pre class="brush:php;">
/app/design/frontend/default/default/layout/catalog.xml
</pre>

Open Catelog.xml page and then search for keyword "Default layout, loads most of the pages".<br />
after fining this keywords then you have to put below code into that block.<br />
<pre class="brush:php;">

<reference name="right">
<block type="catalog/navigation" name="catalog.righthomenav" template="catalog/navigation/right_home_nav.phtml" />
</reference>

</pre>
If you want to change the position of layout in Magento then you can also change into the reference name as (RIGHT, LEFT, FOOTER, etc).<br />
<br />
Now Build a new page on navigated path: -<br />
<br />
/app/design/frontend/default/default/template/catalog/navigation/ right_home_nav.phtml<br />
<br />
Now paste this below code again into new build page named right_home_nav.phtml<br />
<pre class="brush:php;">

<h2>Browse</h2>
<div class="block">
<ul id="nav_category" class="nav_category">
 getStoreCategories() as $_category): ?>
  drawItem($_category) ?>
 
</ul>
</div>
getChildHtml('topLeftLinks') ?>

</pre>
Important Note -> If you want to display categories list on Home Page so paste below code in riht_home_nav.phtml<br />
<pre class="brush:php;">

getRequest()->getRouteName();

$identifier = Mage::getSingleton('cms/page')->getIdentifier();
 if($routeName == 'cms' && $identifier == 'home') { ?>
    <h2>Related Category</h2>
   <div class="block">
   <ul id="nav_category" class="nav_category">
    getStoreCategories() as $_category): ?>
     drawItem($_category) ?>
    
   </ul>
    </div>
 
getChildHtml('topLeftLinks') ?>

</pre>
Now remove the cache and refresh the page the reload.<br />
Thanks<br />
<br />
If you have and query then feel free to contact me or you can ask your query related to Advanced Programming.</div>

How to Show Product category on right side or left side in Magento Commerce?

How to Show Product category on right side or left side in Magento Commerce?

In this Tutorial, We are going to show How to display product category on right or left side with only simple changes. First we will have ...

How to Insert Data-field Value into Database using PHP and MySQL?

<div dir="ltr" style="text-align: left;" trbidi="on">
In this Tutorial, We are going to show that How to insert data-field values into the MySQL database using PHP Coding.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
So Now executing all the process, First create database with name (<b>mydatabase</b>) into the <b>WAMP </b>server that is made for Windows <b>Apache </b>Server. Then create one table into this database with 4 data fields.<br />
<br />
NOTE: - Here we are creating 4 fields because first field always made for unique field like ID or PID for uniquely identified.<br />
<br />
<b>First     </b>- ID or PID<br />
<b>Second</b>  - Name<br />
<b>Third </b>   - Number<br />
<b>Fourth</b>  - Address<br />
<br />
Now database creation work is completed.<br />
<br />
Now we have to insert some value into this database using PHP coding.<br />
Just create one HTML page and make 3 field from which our PHP coding will get the data for storing into the database.<br />
<br />
Now PHP coding is like: -<br />
This Code is used for Connect with database or Communicating with our database.<br />
<pre class="brush:php;">

</pre>
<br />
Now Final PHP Code is: -<br />
<pre class="brush:php;">

</pre>

<br />
Thanks

If you have any query then feel free to contact Us or you can ask your query related to Advanced Programming Also.
<br />
</div>

How to Insert Data-field Value into Database using PHP and MySQL?

How to Insert Data-field Value into Database using PHP and MySQL?

In this Tutorial, We are going to show that How to insert data-field values into the MySQL database using PHP Coding. So Now executing ...

Getting Date Before or After 7 Days from the Current Date using PHP Function?

<div dir="ltr" style="text-align: left;" trbidi="on">
In this Tutorial, We are going to show you getting date 7 days before or after from the current date. some time we require into the live project and we get stuck for getting the date from the current date.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiNrIqSNyFLIkwBfHrAI17wemn6de-R1_60tTKfhhCyIL8f5KFv02FrRZd3F1r_t9EDS_arf2MBqMbOWIosRT778LtL3sz60BR7GcFfO37qORx5fjei0XDiq0xqO0GNdyIL6h9FxRR0i4/s1600/datetime.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiNrIqSNyFLIkwBfHrAI17wemn6de-R1_60tTKfhhCyIL8f5KFv02FrRZd3F1r_t9EDS_arf2MBqMbOWIosRT778LtL3sz60BR7GcFfO37qORx5fjei0XDiq0xqO0GNdyIL6h9FxRR0i4/s1600/datetime.jpg" width="320" /></a></div>
<br />
With the help of easy example we can understand this: -<br />
<pre class="brush:php;">

</pre>

Note: - According to your project you need to change into you code. how many days you need or want to type after or before or both current date.<br />
In the Example we are using 7 days example in this tutorial. you can do some changes into the code like: - "($currentdate-7)" 7 number.<br />
<br />
Also getting Date after 7 days from the current date.<br />
<pre class="brush:php;">

</pre>
Note: - For after current date changes, The difference of date by changing the  "($currentdate+7)" 7 number to get  according yourself.<br />
<br />
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2000007629395px;">
<b><span style="color: #e06666;">You Might Also Read: - </span></b></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2000007629395px;">
<ul>
<li><a href="http://estuffcode.blogspot.in/2014/12/how-to-configure-php-and-php-myadmin-to.html" style="color: #999999; text-decoration: none;">How to Connect PHPmyadmin to Oracle Database.</a></li>
<li><a href="http://estuffcode.blogspot.in/2014/12/how-to-swap-two-variable-value-without.html" style="color: #999999; text-decoration: none;">How to Swap Two Variable without using Third Variable.</a></li>
<li><a href="http://estuffcode.blogspot.in/2014/12/how-to-split-datetime-value-into.html" style="color: #999999; text-decoration: none;">How to Split datetime value into Separated year, months and days?</a></li>
<li><a href="http://estuffcode.blogspot.in/2014/12/what-is-websocket-in-html5-and-how-to.html" style="color: #999999; text-decoration: none;">What is webSocket in HTML5? How to use it in Programming?</a></li>
<li><a href="http://estuffcode.blogspot.in/2014/12/generate-four-digit-random-number-for.html">Generating 4 Digit Random Number  Using PHP function and Code?</a></li>
</ul>
</div>
</div>

Getting Date Before or After 7 Days from the Current Date using PHP Function?

Getting Date Before or After 7 Days from the Current Date using PHP Function?

In this Tutorial, We are going to show you getting date 7 days before or after from the current date. some time we require into the live pr...

Generate Four Digit Random Number for storing file or Image uniquely in Database?

<div dir="ltr" style="text-align: left;" trbidi="on">
In this coding Tutorial, We are generating random number with four digit uniquely. We can use this random number generation into many ways in PHP Programming. We can use this random number after or before any image or file for storing information into database for future use.<br />
<br />
We can simply write this code with Example: -<br />
<pre class="brush:php;">

$uniquenumber_long      = uniqid(rand(), true);
$fourdigit_uniquenumber = substr(str_shuffle($uniquenumber_long), 0, 4);
$final_random_code      = preg_replace('/[^a-zA-Z0-9_ -]/s', '', $fourdigit_uniquenumber);

</pre>
<br />
In this code, first we are using rand function of PHP and after that providing this function a number value for number generation start number to end number. Then converting this into final_random_code variable. When we refresh this code again then we will get new random code each time.<br />
<br />
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2000007629395px;">
<b><span style="color: #e06666;">You Might Also Read: - </span></b></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2000007629395px;">
<ul>
<li><a href="http://estuffcode.blogspot.in/2014/12/how-to-configure-php-and-php-myadmin-to.html" style="color: #999999; text-decoration: none;">How to Connect PHPmyadmin to Oracle Database.</a></li>
<li><a href="http://estuffcode.blogspot.in/2014/12/how-to-swap-two-variable-value-without.html" style="color: #999999; text-decoration: none;">How to Swap Two Variable without using Third Variable.</a></li>
<li><a href="http://estuffcode.blogspot.in/2014/12/how-to-split-datetime-value-into.html">How to Split datetime value into Separated year, months and days?</a></li>
<li><a href="http://estuffcode.blogspot.in/2014/12/what-is-websocket-in-html5-and-how-to.html">What is webSocket in HTML5? How to use it in Programming?</a></li>
</ul>
</div>
</div>

Generate Four Digit Random Number for storing file or Image uniquely in Database?

Generate Four Digit Random Number for storing file or Image uniquely in Database?

In this coding Tutorial, We are generating random number with four digit uniquely. We can use this random number generation into many ways ...

How to Split datetime value into separate day, months and years ?

<div dir="ltr" style="text-align: left;" trbidi="on">
In this Tutorial, we are going to show how to split datetime into day, months and years.<br />
<br />
we can easily execute it using Jquery function and can use it into our live project as we did.<br />
<br />
We have different types of 3 Input Field.<br />
<br />
First for datetime format: -<br />
<input type="text" id="DateTime" value="2010-10-18 10:06" /><br />
<br />
Second for Date format: -<br />
<input type="text" id="Date" value="" /><br />
<br />
Third one is for Time format: -<br />
<input type="text" id="Time" value="" /><br />
<br />
This is our submit button for submitting value.<br />
<input type="button" id="bttnSubmit" value="Submit" /><br />
<pre class="brush:php;">

<script type="text/javascript">
    $(function () {
        $('#bttnSubmit').click(function () {
            var dateTimeSplit = $('#DateTime').val().split(' ');
            var dateSplit = dateTimeSplit[0].split('-');
//year            
alert(dateSplit[2]);
//month 
alert(dateSplit[1]);
//day
alert(dateSplit[0]);
     
        });
    });
</script>

</pre>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2000007629395px;">
<b><span style="color: #e06666;">You Might Also Read: - </span></b></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2000007629395px;">
<ul>
<li><a href="http://estuffcode.blogspot.in/2014/12/how-to-configure-php-and-php-myadmin-to.html" style="color: #999999; text-decoration: none;">How to Connect PHPmyadmin to Oracle Database.</a></li>
<li><a href="http://estuffcode.blogspot.in/2014/12/how-to-swap-two-variable-value-without.html" style="color: #999999; text-decoration: none;">How to Swap Two Variable without using Third Variable.</a></li>
</ul>
<div>
If you have any query regarding this post the feel free to contact us or write feedback into the comment section at every post. </div>
<div>
<br /></div>
<div>
Thanks and Keep Visiting.</div>
<div>
<br /></div>
</div>
</div>

How to Split datetime value into separate day, months and years ?

How to Split datetime value into separate day, months and years ?

In this Tutorial, we are going to show how to split datetime into day, months and years. we can easily execute it using Jquery function a...

What is Websocket in HTML5 and how to use it in Programming world?

<div dir="ltr" style="text-align: left;" trbidi="on">
Web-Socket is a communication technology to which next generation going to use or We can say that a next generation technology for web application for getting response from server and to send data to server like GET and POST Method.<br />
<br />
Like in JQuery: -<br />
<pre class="brush:php;">

$.post() Or $.get() or $.ajax() etc

</pre>
<div>
<div>
How this function works for us in programming ?</div>
<div>
This function used for sending and receiving data to server and from server.</div>
<div>
This is one to one communication between client to server and server to client structure.</div>
</div>
<pre class="brush:php;">

Syntax: var Socket = new WebSocket(url, [protocal] );

</pre>

<div>
We can easily understand with the help of Example: - </div>
<pre class="brush:php;">

<script type="text/javascript">
function WebSockettest()
{
   if("WebSocket" in window)
  {
  alert("WebSockets are supported by our Browser!");
  // Lets open a web socket 
  var ws = new WebSocket("www.your-url.com/par"); 
  ws.onopen = function() 
   {
   // Web Socket is connected now, send data using send() Method
   ws.send("Message send to server");
   alert("Message sent now");
       };
   ws.onmessage = function (evt) {
   var receive_msg = evt.data;
   alert("Message is received by server");
   };
   ws.onclose = function() {
   // websocket is now closed. 
   alert("Connection is closed from server");
   }; 
     }
}
</script>
</pre>
<pre class="brush:php;">

<div id="ides"><a href="javascript:WebSockettest()">Execute WebSocket</a></div>
</pre>
<div>
<b><span style="color: #e06666;">You Might Also Read: - </span></b></div>
<div>
<ul style="text-align: left;">
<li><a href="http://estuffcode.blogspot.in/2014/12/how-to-configure-php-and-php-myadmin-to.html">How to Connect PHPmyadmin to Oracle Database.</a></li>
<li><a href="http://estuffcode.blogspot.in/2014/12/how-to-swap-two-variable-value-without.html">How to Swap Two Variable without using Third Variable.</a></li>
</ul>
</div>
</div>

What is Websocket in HTML5 and how to use it in Programming world?

What is Websocket in HTML5 and how to use it in Programming world?

Web-Socket is a communication technology to which next generation going to use or We can say that a next generation technology for web appl...

How to Configure PHP and PHP myadmin to connect with Oracle using XAMP server.

<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
In this Tutorial, we are going to show how to connect oracle database with php using XAMP server with the help of example.<br />
For preforming this task we need to go through with 2 step.<br />
<br />
In the first step we are configuring XAMP server according to oracle database communication.<br />
In second step - we will execute query and connect with the database.<br />
<br />
<b>Step First: -</b><br />
First of all check that whether we have oracle client installed already or not.<br />
<br />
<b>1.</b> In XAMP start up, Goto PHP info page, then look for string <b>oci8</b>.<br />
   if this string found then it says that connection is available and then execute <b>step3</b>. Otherwise do<br />
<b>2.</b> find string <b>;extenstion = php_oci8.dll </b>and then remove the <b>semicolon(;)</b> from the beginning of string to activate the extension of oracle.<br />
<br />
<b>3.</b> Save you XAMP php.ini file.<br />
<br />
<b>4.</b> Now Download the client package - Basic for window from OTN Instant Client Page. Unzip in the folder name at path to "<b>c:\xampp\php\ext</b>"<br />
<br />
<b>5.</b> Edit the PATH environment setting from the windows environment from start button <b>-></b> control panel <b>-></b> system <b>-></b> Advanced <b>-></b> Environment Variables and then edit path in the system variable list.<br />
<br />
<b>6.</b> Restart your XAMP Server.<br />
<br />
<b>Step Second: -</b><br />
<pre class="brush:php;"> 
<!--php

define('DB_SERVER', 'SERVER_NAME');
define('DB_USERNAME', 'USER_NAME');
define('DB_PASSWORD', 'USER_PASSWORD');
define('DB_DATABASE', 'YOUR_DATABASE_NAME');
$conn= oci_connect(DB_USERNAME, DB_PASSWORD, DB_SERVER)
or die(oci_error());
echo "success...";
//$database = oci_select_db(DB_DATABASE) or die(oci_error());
$stid = oci_parse($conn, 'SELECT * FROM employees'); 
oci_execute($stid); echo "<table border='1'-->\n"; 
while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) 
{     
    echo "<tr>\n";     
	foreach ($row as $item) 
	{         
	   echo "<td>" . ($item !== null ? htmlentities($item, ENT_QUOTES) : " ") . "</td>\n";
	 }    
    	 echo "</tr>\n"; 
 }
 
 echo "</table>\n";

?>
</pre>

<b>There is some problem whenever we connect database with PHPmyadmin. Then it says "PHPMyAdmin unable to connect with root password change.</b>
<br />
<pre class="brush:php;"> 
Error

MySQL said:
Cannot connect: invalid settings.
</pre>

phpMyAdmin tried to connect with PHPmysql server and while connecting server's has rejected the connect connection. During establishing connection with server we should also check our configuration file includes hostname, username, and password. those are needed to connect and also check provided informations are correct correspond to administrator of phpmyadmin.<br />
<br />
We should also take care of configuration parameters.<br />
<pre class="brush:php;">
<!--php

/* Server configurations */
$i = 1;
$cfg['Servers'][$i]['host']         = '127.0.0.1';
$cfg['Servers'][$i]['port']         = '3323';
$cfg['Servers'][$i]['ssl']          = FALSE;
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension']    = 'mysql';
$cfg['Servers'][$i]['compress']     = FALSE;
$cfg['Servers'][$i]['controluser']  = 'root';   
$cfg['Servers'][$i]['controlpass']  = 'rCZ4Xnz78zbLY2Vh';
$cfg['Servers'][$i]['auth_type']    = 'config';
$cfg['Servers'][$i]['user']         = 'root';
$cfg['Servers'][$i]['password']     = 'rCZ4Xnz78zbLY2Vh';
$cfg['Servers'][$i]['nopassword']   = TRUE;

$cfg['Servers'][$i]['bs_garbage_threshold']     = 40;
$cfg['Servers'][$i]['bs_repository_threshold']  = '64M';
$cfg['Servers'][$i]['bs_temp_blob_timeout']     = 1200;
$cfg['Servers'][$i]['bs_temp_log_threshold']    = '64M';

$cfg['blowfish_secret'] = '';
$cfg['DefaultCharset']  = 'utf-8';
$cfg['UploadDir']       = '';
$cfg['SaveDir']         = '';

?-->
</pre>

<b>For Solution: -</b> We need to perform some changes into the configuration file named config.inc in PHPmyadmin directory like: - (C:\xampp\phpMyAdmin) and do some changes in line for matching the password we have entered in PHPmyadmin.<br />

<pre class="brush:php;">

$cfg['Servers'][$i]['password'] = ' ';

</pre>

If you feel any difficulty then feel free to contact me through contact form. i will surely contact you as soon as possible.<br />
<br />
Thanks<br />
<br /></div>

How to Configure PHP and PHP myadmin to connect with Oracle using XAMP server.

How to Configure PHP and PHP myadmin to connect with Oracle using XAMP server.

In this Tutorial, we are going to show how to connect oracle database with php using XAMP server with the help of example. For preforming...

How to Swap two variable value without using third variable in php?

<div dir="ltr" style="text-align: left;" trbidi="on">
In this tutorial, We are going to show swapping between two variable. This question is mostly asked into the interview and i was unable to tell the answer. So finally after searching on search engine and tried on self coding. I got the solution now, which we are showing below.<br />
<br />
We can easily swap two variable value with PHP function like: -<br />
for Exchanging value we can use different types of methods.<br />
Example:<br />
<pre class="brush:php;">

<!--php

$a='kumar'; $b='yogesh';
list($a,$b) = array($b,$a);
echo $a.'-'.$b;

?-->

</pre>
yogesh-kumar     // Answer will be<br />
<br />
We can swap two variable with the XOR method to.<br />
<pre class="brush:php;">

".$a;
echo "b ->".$b;
?>

</pre>
Answer will be: -<br />

a - 11111<br />
b - 33333<br />
<br />
We can swap two variable with the use of our logic to.<br />
<pre class="brush:php;">

</pre>
And using anther one is here: -<br />
<pre class="brush:php;">

$a = $a * $b;<br />
$b = $a / $b;<br />
$a = $a / $b;<br />

</pre>

In the C Language we can easily execute our code like.
<pre class="brush:php;">
    #include <stdio.h>
    void main()
    {
    int a,b;

printf("Enter Number One: a");

scanf("%d",a);

printf("Enter Number Two: b ");

scanf("%d",b);

printf(Value of a and b Before swap a=%d,b=%d"a,b);

a = a + b;
    b = a - b;
    a = a - b;

printf(value of a and b After swap a=%d,b=%d"a,b);

}
 
</pre>
<b>One Another executable code is written below.</b>
<br />
<pre class="brush:php;">
#include <stdio.h>
    void main()
    {
        int x,y;
        printf("Enter First Number :");
        scanf("%d",x);
        printf("Enter Second Number 2: ");
        scanf("%d",y);
        printf(value of x and y before swapping is x=%d,y=%d"x,y);
        y=x+y-(x=y);
        printf(value of x and y after swapping is x=%d,y=%d"x,y);
    }
</pre>
<br />

<h5>Now, We will learn how Swapping of two nibble in byte using c++ ?</h5>

Nibble is an aggregation of 4 bits that is made by octet. we always have 2 nibble in byte.<br /><br />
We can easily understand with the help of example: -
<br />
Hundred(100) is presented in 01100100 in 8 bits. There are 2 nibbles like - (0110) and (0100). But if we swap to both of them together, Then we will get (01000110) with the value of 70 into decimal.
<br /><br />
For swapping of 2 nibble, we generally uses bitwise &, << and >> operators into coding. Showing one example in C program swapping of two nibble in byte.
<pre class="brush:php;">
#include <stdio.h>
 
unsigned char swap_Nibbles(unsigned char y)
{
    return ( (y & 0x0F)<<4 | (y & 0xF0)>>4 );
}
 
int main()
{
    unsigned char y = 100;
    printf("%u", swap_Nibbles(y));
    return 0;
}
</pre>
Output: -
<br />
70
<br /><br />
<h5>Explanation:</h5>

The Binary value of 100 is 01100100. So with this binary value we had split into 2 parts.<br />
First of all, We made one function named - swap_Nibbles() that will receive an argument as a value. We used ((y & 0x0F)<<4)  that gives us last 4 bits of Y variable and ((y & 0xF0)>>4) gives us first 4 bits.<br /><br />

Then we have written main() code and perform printf function to run the swap_Nibbles(y) function.<br /><br />

<b>Now its time to learn swapping in Java: -</b><br /><br />

The above swapping code in c will not work in Java Technology. Till now, Java has not this type of parameters. But with the help of an array variable we can perform this task. In array, we pass the array and 2 index for swapping as 3 Parameters to work in Java.
One Java code program is elaborating this all.<br /><br />

<b>We can easily understand using Java BubbleSort Program: - </b>
<pre class="brush:php;">
public class Bubble_Sort {
   // swap: interchange inside array
   static void swap(int[] a, int i, int j) {
      int t = a[i];
      a[i] = a[j];
      a[j] = t;
   }

// bubbleSort: very short code, but ineffient
   static void bubble_Sort(int[] a) {
      for (;;) {
         boolean sorted = true;
         for (int i = 0; i < a.length - 1; i++)
            if (a[i] > a[i+1]) {
               sorted = false;
               swap(a, i, i + 1);
            }
         if (sorted) break;
      }
   }

static void printArray(int[] a) {
      for (int i = 0; i < a.length; i++) {
         if (i % 4 == 0) System.out.println();
         System.out.print(a[i] + " \t");
      }
      System.out.println();
   }

public static void main(String[] args) {
      int size = Integer.parseInt(args[0]);
      System.out.println("Bubble_Sort, size = " + size);
      int[] r = new int[size];
      for (int i = 0; i < size; i++)
   {
         r[i] = (int)(Math.random()*size*10 + 1);
         long start_Time =System.currentTimeMillis();
        }
      Bubble_Sort(r);
      System.out.println("Elapsed time(millis) "+ (System.currentTimeMillis()-start_Time));
      // printArray(r);
   }
}
</pre>
If you still having any problem then feel free to contact us with the help of contact form or mail us at : - estuffcode(at)gmail(dot)com.<br />
<b> Happy Coding - Don't forget to write your feedback. Thanks.</b><br />
</div>

How to Swap two variable value without using third variable in php?

How to Swap two variable value without using third variable in php?

In this tutorial, We are going to show swapping between two variable. This question is mostly asked into the interview and i was unable to ...

Subscribe to: Posts (Atom)

Top