In the previous tutorial we covered some basic structure of a C# program and what it looks like. I would like to build upon that knowledge and cover some of the basic syntax of C#, some of this may be slightly repetitive from the previous tutorial but it is important to get this basic syntax down. Continue reading “C# for Beginners [Part 2]”
Ok so yesterday I received a request to do a C# tutorial covering the basics of the C# language. This will be a short multi-part tutorial on the basics of C#. In Part 1 we’re going to cover some basic structure and syntax. I do not intend to get too in-depth but cover just enough to allow others to be able to start writing simple programs and get comfortable with the language syntax.
Building off the previous tutorial SQLite in C# [Part 1] we are going to get a little more in detail with SQLite and populate our database with some information that we can pull back out later.
Lets start off with inserting information into our database. We will do this in a similar fashion as we did creating our database table. By creating a query string, passing it to a SQLiteCommand, and then executing the command.
I can’t tell you how many times I am working on an application that I want to store data in an organized fashion but I don’t want the dependency of an external server. Maybe I want to be able to use the application offline? Or maybe the device I am running it on doesn’t have the ability to hold a database server.
Enter the realm of SQLite. I have used it extensively in the past with simple Python and PHP applications, but now I figured I’d give a good overview of using it with C# and .NET.
Most common applications and “home-brew” sites use sessions for storing temporary data as well as authentication. However,
sometimes a developer may want the session to span over multiple domains and or servers, and some may just be very security
conscience. It is common knowledge that session data is stored in a text file on the webserver, however if you are using
a shared server (as most cannot afford dedicated hosting or VPS) then any user on that server may see your session files.
To prevent this, and allow your user’s sessions to span over multiple domains the answer is easy: store the session data in a
MySQL database! Most of you may not be sure how to do this, or may have even been unaway that this is possible, however it is
very easy. When storing sessions in a database PHP makes the work easy for us with the use of a function called
session_set_save_handler(), this function can control the way that sessions are stored, retrieved, destroyed, etc. Continue reading “Storing Sessions in a database”
PHP as you all know is a very powerful and yet fairly loose language, however one of it’s very usefully abilities is the ability to upload files. PHP can upload literally any type of file you allow it to. However this can also open up many holes for many exploits, which is why we’ll also cover some basic security along with uploading the files. Continue reading “Uploading Files”