I hardly suggest you to use php / mysql otherwise you will just get hacked. I will send you some functions tomorrow.. Going to sleep 4:42 am atm o.o
I'm not very good with databases and don't really know much about the language.. I forget what it was called, but can anyone guide me through to
loading a single columned into a list and
submitting a 9 character length string into it?
I already figured out that I needed mysql connector and I have it installed and imported to my project already. Other than that, I'm lost
I hardly suggest you to use php / mysql otherwise you will just get hacked. I will send you some functions tomorrow.. Going to sleep 4:42 am atm o.o
DawgiiStylz (04-04-2013)
DawgiiStylz (04-05-2013)
If it's MySQL then inserting is something like
INSERT INTO `Database`.`Table` (`Column `) VALUES ('Value');
If You Like My Releases, Hit The Thanks button!
Follow the rules.
Successful Purchases: 2
Successful Sales: 1@The403
@sundy42
Scammed: 1@wZ. Gali
Favorite Quotes:
MySQL has a pretty advanced documentation.
MySQL :: MySQL 5.1 Reference Manual :: 13.2.5 INSERT Syntax
You need to learn SQL.
SQL Tutorial (or any other site)
DawgiiStylz (04-07-2013)
I appreciate the help from everyone
First of all, like a previous comment was intending to say, you should always use php + mysql and simply have the vb.net script act as shell. The vb.net simply should post the needed data at the server to prevent potential server comprising.
Second, to recall information you can say:
"SELECT * FROM `DatabaseName`.`TableName`"
or, let's say you only want to select things from the last 2 weeks (this will be written in php):
"SELECT * FROM `DatabaseName`.`TableName` WHERE `TableName`.`TimeSubmitted` > '" . (time() - (24 * 60 *60 *14)) . "'"
And now, for the kicks and giggles, let's say we want to get information from the last 2 weeks and want it sorted by most recent:
"SELECT * FROM `DatabaseName`.`TableName` WHERE `TableName`.`TimeSubmitted` > '" . (time() - (24 * 60 *60 *14)) . "' ORDER BY `TableName`.`TimeSubmitted` DESC"
Again, these examples are php based as, in my opinion, php is a much better option for sql interaction.
DawgiiStylz (04-11-2013)
How could I get the data and add it to a list?
This what I have so far
Code:Try conn.Open() Dim sqlString As String = "SELECT Code FROM MonsterWarlord ORDER BY Index" Dim reader As MySqlDataReader Dim adapter As New MySqlDataAdapter Dim command As New MySqlCommand With command .CommandText = sqlString .CommandType = CommandType.Text .Connection = conn End With adapter.SelectCommand = command reader = command.ExecuteReader While reader.Read() codeList.Add(reader.GetString(1)) End While Catch ex As Exception End Try
Last edited by DawgiiStylz; 04-08-2013 at 08:36 PM.
If You Like My Releases, Hit The Thanks button!
Follow the rules.
Successful Purchases: 2
Successful Sales: 1@The403
@sundy42
Scammed: 1@wZ. Gali
Favorite Quotes:
I figured it all out. Thank you.
Imports MPGH.NET
Public Class King_Aldrin
Private Sub King_Aldrin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim thanks = mpgh.user.kingaldrin
Dim help As Boolean
If mpgh.user.other = Ask.question Then
help = True
Else
help = False
End If
If help = True Then
If mpgh.user.kingaldrin.answers > 0 Then
MsgBox("Did I helped you? then press the Thanks button!", MsgBoxStyle.Information)
Else
MsgBox("I'm sorry! I think I can't answer your question")
End If
Else
MsgBox("You didn't ask a question, Please ask a new question now by posting a new thread or PM'ing me!")
End If
End Sub
End Class
If you're getting the data in vb.net, i don't know. If you get it in php you can output it via the echo command inside of a while loop for the query and then put a delimiter between each one.
Just saw you figured it out which makes my post kind of useless, but oh well. Again, i still very strongly recommend using php + vb.net.
DawgiiStylz (04-11-2013)
Ok, I'm curious about the security risks that everyone was talking about. How would you go about this while being 'secured'.
Which I'm thinking.. people can check where the program is communicating with.. such as websites and ect.. or via the code where you can look at strings on databases information that no one should have..
I read here that sql and php isn't secured.. what is a better alternative?