Category: PHP and MYSQL

If you have been working with websites as long as we have, you have probably seen a few shares of odd requests. This is our take on sharing the web development world.

Posted on

SB Admin PHP – Fixed Table Header with Scrollable Body

Hi guys,

This question was raised to me recently and it peeked my interest to solve and find out how to do this. After digging around i found 2 working codes for my case.

To explain further my tables are generated dynamically so the column widths and gaps differ by each refresh of the table

There are the 2 options that i found

////////////// OPTION 1 //////////////////////
table tbody { display:block; max-height:450px; overflow-y:scroll; }
table thead, table tbody tr { display:table; width:100%; table-layout:fixed; }

table width=”100%” class=”table table-striped table-hover” id=”dataTables-example”
////////////// OPTION 2 //////////////////////
table {
overflow-y: auto;
height: 10vh;
}
thead th {
position: sticky;
top: 0;
}

table width=”100%” class=”table table-striped table-hover” id=”dataTables-example”

Hope this code helps out somebody out there. If you have any questions, just drop me a line.

Coffee Cup

Posted on

How to change table row count in the bootstrap website?

I have been working with bootstrap websites for quite some time and making admin backend pages have been a new experience for me.

Lately the default 10 row table data have a lot of people ask if we can increase it to a certain number other than 10.

Fortunately, I came across the code to grant this request. But we need to go into the source code page to accomplish this.

Inside the HTML page, at the bottom, you will see a script section

We need to add more code to it.

When you refresh the page, you will see that it now starts at 50 rows

That’s just about it.

Enjoy,

Coffee Cup

Youtube link is
https://www.youtube.com/watch?v=GdH3IkYBwI4

Posted on

Automatically Let Google Translate Your Webpage

Let Google translate your webpage

There was a requirement before that the webpage needs to be converted to any language that the guest will be coming from.

So I got digging and found the code that will let Google translate convert it on the fly. Take note that this might need a few web source tinkering.

Here it is :

And the output you will see is :

I’m not sure why I cannot copy and paste code to WordPress for now. I am suspecting that you cannot copy <DIV> statements. But soon I will know why. But for now, a screenshot will do.

Now, of course, there is a downside to using this one. The translation going back from Chinese-to-English for example might not yield the same result. Just be careful if you are using words like Parent’s Portal that might be translated as an intergalactic dimension.

Just to be safe, we can keep it to plain or simple words that google can understand.

As always stay safe

Coffee Cup

You can view the youtube video here :
https://youtu.be/Q0Hqbn-4p6I

Posted on

PHP tip : how to remove columns and save to another file

Hello guys,

Had a special request to trim the csv fields in the file.

After searching, found a code to satisfy the request.

Posted the URL from the original link

Enjoy,

Coffee Cup

http://stackoverflow.com/questions/8608970/writing-to-csv-using-fgetcsv

$input = 'input.txt';
$output = 'output.txt';

if (false !== ($ih = fopen($input, 'r'))) {
    $oh = fopen($output, 'w');

    while (false !== ($data = fgetcsv($ih))) {
        // this is where you build your new row
        $outputData = array($data[0], $data[1], $data[4], $data[5], $data[6]);
        fputcsv($oh, $outputData);
    }

    fclose($ih);
    fclose($oh);
}