Hi guys im working on a chat app, i watched the video got the source code and nothing worked lol.
Anyways after some time and code change i got it working mostly properly on xampp. The DB works as do the tables....i imported it to my web hosted server but can't connect no matter what i try...
Whats need to go from xampp to my hosted phpmyadmin?
Yes i left the root and no password as i didn't want to post my details, but i did change them.
Code:
Imports System.IO
Imports System.Security.Cryptography
Imports MySql.Data.MySqlClient
Module DataModule1
Public con As New MySqlConnection("server=localhost" & My.Settings.Host & "; user=root" & My.Settings.User & "; password=" & My.Settings.Pass & "; database=chat_db " & My.Settings.dbName)
Public usernamefriend As String
Public Sub Connect()
If con.State = ConnectionState.Open Then
con.Close()
con.Open()
Else
con.Open()
End If
End Sub
Public Function login(username As String, password As String)
Connect()
Dim cmd As New MySqlCommand("select * from users where username = @username and password = @password", con)
cmd.Parameters.AddWithValue("@username", username)
cmd.Parameters.AddWithValue("@password", password)
Dim dt As New DataTable
Dim dr As MySqlDataReader = cmd.ExecuteReader
dt.Load(dr)
Return dt
End Function