Telegram Bots - How Can I create Reply Menus with icons like mypokerbot?
You should use emoji, taking from here:
http://apps.timwhitlock.info/emoji/tables/unicode
Clicking on Unicode
column you can get values in different encodings.
Concatenate emoji string with your message to build your keyboard text.
For Java it will be:
String s = new String(new byte[]{(byte) 0xF0, (byte) 0x9F, (byte) 0x98, (byte) 0x81}, "UTF-8");
or
String s = "\uD83D\uDE4C" + "myKeyboardTest";
For PHP I think something like this:
"\xF0\x9F\x98\x81" . "your super keyboard"
Find two consecutive rows
Assuming the rows have sequential IDs, something like this may be what you're looking for:
select top 1 *
from
Bills b1
inner join Bills b2 on b1.id = b2.id - 1
where
b1.IsEstimate = 1 and b2.IsEstimate = 1
order by
b1.BillDate desc
Related Topics
Query With Multiple Values in a Column
Php 7 With Phpmyadmin Gives Lots of Deprecation Notices
How to Change PHP Version in Xampp
Count Same Values in Array and Combine into Array
How to Replace Newline or \R\N With <Br/>
Laravel App Storage Images Failed to Load and Redirect to 404
Codeigniter Call to a Member Function Num Rows on Boolean
Php Get Number of Week for Month
Check If Username and Email Already Exists in Database
Warning: Mysqli_Connect(): (Hy000/1049): Unknown Database in MAC Terminal Only
What Is the Easiest Way to Check If Time Is Set in Datetime Variable
I Have Three Columns, I Want to Combine Them All in One Main_Table
Finding the Longest Gap Between Multiple Intervals
Laravel 5 - How to Access Image Uploaded in Storage Within View