World-easiest-profile-management-crud-application-in-symfony

Hey Guys, I developed this application in one of my interview in Mumbai. Later on i feel that, this application can help to lot of developer (not only in core php but all PHP Frameworks i.g Symfony)...

What cover PMCA (Profile Managment CRUD System)

1. Insert Profile Details with Profile Pic (Preview also) using Ajax with required validation

2. Update Existing Record (required validation too)

3. View All Records with pagination by id

4. List all Profile in single page

5. Delete Single Record

6. Api End Point where, if you request ids (,2,5,10). you will get profile details in Json format.

HERE IS FULL CODE (FREE DOWNLOAD)

HERE IS FULL CODE (FREE DOWNLOAD)

Export Html Table into Excel using Javascript in 2 Minute

Hey guys, Want to export your small/Large Table data with row header in excel.
Also, you want to put some color in first row. then you are in right place.

This code (few lines of code ) will export the same.

No rocket science required.
No external setup
Only Vanilla JavaScript

----------------------------------------------------------

HTML-:

  <table id="exTable" border="1">

    <thead class="lockedRecordsBg">

        <tr>

            <th>S#</th>

            <th>name</th>

            <th>Email</th>

            <th>Phone</th>

            <th>Country</th>

    </thead>

    <tbody>

        <tr>

            <td rel="client">1</td>

            <td rel="regionName">Sudhir K Gupta</td>

            <td rel="date">sudhirgupta.456@gmail.com</td>

            <td rel="shift">+91 89********</td> 

            <td rel="shift">India</td>             

        </tr>

        <tr>

            <td rel="client">2</td>

            <td rel="regionName">Sudhir K Gupta</td>

            <td rel="date">test@gmail.com</td>

            <td rel="shift">+91 89********</td> 

            <td rel="shift">USA</td>             

        </tr>

    </tbody>

</table> 

Javascript-:

<script>

function exportToExcel(tableID){

    var tab_text="<table border='2px'><tr bgcolor='#87AFC6' style='height: 75px; text-align: center; width: 250px'>";

    var textRange; var j=0;

    tab = document.getElementById(tableID); // id of table

    for(j = 0 ; j < tab.rows.length ; j++)

    {

        tab_text=tab_text;

        tab_text=tab_text+tab.rows[j].innerHTML.toUpperCase()+"</tr>";

        //tab_text=tab_text+"</tr>";

    }

    tab_text= tab_text+"</table>";

    tab_text= tab_text.replace(/<A[^>]*>|<\/A>/g, ""); //remove if u want links in your table

    tab_text= tab_text.replace(/<img[^>]*>/gi,""); //remove if u want images in your table

    tab_text= tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); //remove input params

    var ua = window.navigator.userAgent;

    var msie = ua.indexOf("MSIE ");

    if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./))      // If Internet Explorer

    {

        txtArea1.document.open("txt/html","replace");

        txtArea1.document.write( 'sep=,\r\n' + tab_text);

        txtArea1.document.close();

        txtArea1.focus();

        sa=txtArea1.document.execCommand("SaveAs",true,"sudhir123.txt");

    }

    else {

       sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));

    }

    

    return (sa);

}

</script>

Now Put button below the script (must) or put jquery window.load function for this click event.

otherwise it will not work.

<input type="button" value="export" onclick="exportToExcel('exTable')" />

Download Code From Here

Ads.

Know top 10 most interesting and awesome YouTube fact

Do you know why are headphones printed L and R

job doesn’t define how good human being you are

5 funny and interesting fact about your jeans

Author-