URL and Link repository

Tuesday, December 5, 2017

Inserting Dates and Times from Visual Basic Web Form to MySQL Database

Not pretty but it resolves that invalid string error.

ASP code / mark up:
<asp:TextBox> TextMode='Date' ID='StartDateBox' runat='server'</asp:TextBox>
<asp:TextBox> TextMode='Time' ID='StartTimeBox'runat='server'</asp:TextBox>
Visual Basic server code:
Dim sTime As DateTime = Convert.ToDateTime(StartTimeBox.Text.toString) 
Dim insertstring as String='INSERT INTO [sometable] (Start_Date, Start_Time) values (@sd, @st)'
Dim mySqlcmnd = New MySqlCommand(insertstring, [your db connection])
mySqlcmnd.Parameters.AddWithValue('sd', StartDateBox.Text)
' 24 hour format
mySqlcmnd.Parameters.AddWithValue('st', sTime.ToString("HH:mm"))
Dim rowCnt as Integer = mySqlcmnd.ExecuteNonQuery

Sunday, November 5, 2017

Android to PHP Calendar Week View

I need to display a week of data between the Sunday and Saturday that surround a given date.

Android:

SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
//current date on mobile
String formattedDate = df.format(Calendar.getInstance().getTime());
//format the get
String url = HOME_PAGE+"/mobile/getsessions.php?sessDate="+formattedDate";

//
PHP:

$sessDate=mysqli_real_escape_string($dbconn, $sessDate);
//

//Get the day number out of 7 days
$weekdaynum = date('w', strtotime($sessDate));
// the following will handle what happens when a date falls on Sunday or Saturday.
// I DO NOT want to slide a week out in either direction
switch ($weekdaynum) {
case 0: // sunday
$startAtSun = strtotime('this sunday', strtotime($sessDate));
$endAtSat = strtotime('this saturday', strtotime($sessDate));
break;
case 6: // saturday
$startAtSun = strtotime('last sunday', strtotime($sessDate));
$endAtSat = strtotime('this saturday', strtotime($sessDate));
break;
default: // all other days
$startAtSun = strtotime('last sunday', strtotime($sessDate));
$endAtSat = strtotime('this saturday', strtotime($sessDate));
break;
}

$format = 'Y-m-d';
$week_start = date($format, $startAtSun);
$week_end = date($format, $endAtSat);

Thursday, November 2, 2017

Android Program for Making a Week View

To follow up on the previous post, now that I have a PHP/MySQL program ready to send proprietary calendar data to the Android app, I need a week view to receive each appointment. The work done on this GitHub code is tremendous and is a good start. https://github.com/AnilMH/Android-WeekView-Demo.
To be continued...

Tuesday, October 31, 2017

PHP Get Start of Current Week

I need to get the start and end date for the week of the current date.

$day = date('w');
$week_start = date('Y-m-d', strtotime('-'.$day.' days'));
$week_end = date('Y-m-d', strtotime('+'.(6-$day).' days'));

Saturday, September 23, 2017

Asus Zenfone Laser 2 - Lost Root Access

See about 3 posts ago. Anyhoos - This is where I have the files that I used to restore root: Google Drive. Of course, I used these files after resetting the device to factory.

Wednesday, September 20, 2017

ASUS_Z00MD Android Moving Apps to SD card

This device is also known as the Asus Zenfone Laser 2 with 6 inch screen.

Moving Apps to the SD Card.

  • First, you must have a very fast SD card
  • Second, you must enable USB debugging and attach device to your PC.
  • Third, open command line and type "adb shell"
  • Fourth, type "sm list-disks"
  • Fifth, note the partition, which in my case was "disk:179,64"
  • Lastly, type "sm partition disk:179,64 private"


  • Now find an app that moves apps to the SD card.

    Good luck.

    Tuesday, September 19, 2017

    Android APK uloaded to Google Play Supports 0 devices

    Recently uploaded a new APK for W.A.R. II only to discover that it now supports exactly 0 devices. This even after I installed the APK on my own devices running Marshmallow and Nougat.
    After e-mailing Google Support who did not identify anything specific in the manifest, I decided to add

    <uses-feature android:name="android.hardware.camera" android:required="true" /> <uses-feature android:name="android.hardware.location.gps" /> <uses-feature android:name="android.hardware.location.network" />
    and remove android:required = true from
    <uses-feature android:glEsVersion="0x00020000" />
    Now the W.A.R. app supports 11268 devices.