Day: March 24, 2021

Posted on

Multilingual SEO and Content Localization for WordPress

Featured Imgs 26

Multilingual SEO and Content Localization for WordPressWordPress SEO and Multilingual SEO go together so that they reach certain crucial audiences that may or may not speak your language. There are so many people who look at WordPress blogs and reside in different nations. If you want to drive traffic to your website, you can’t miss these key demographics. According to current […]

The post Multilingual SEO and Content Localization for WordPress appeared first on WPExplorer.

Posted on

Check if there is a duplicate username in MySQL database

558fe5180e0e8fc922d31c23ef84d240

Good day! I am new in vb.net and I want to detect if there is a duplicate of the record that a user will try to add. If the user adds an existing username from the database then it will show an error that the username has already been used.
Here is my code:
conn.Open()

        Dim qadd As String = "INSERT INTO tbl_user (uname, pword, ulvl) VALUES ('" & txt_uname.Text & "' , '" & txt_pword1.Text & "' , '" & txt_pword2.Text & "') ON DUPLICATE KEY UPDATE uname = ' " & txt_uname.Text & " '"
        Dim cmd As New MySqlCommand(qadd, conn)
        Dim data As MySqlDataReader = cmd.ExecuteReader
        MsgBox("User has been added!", MsgBoxStyle.Information)
        txt_uname.Clear()
        txt_pword1.Clear()
        txt_pword2.Clear()
        txt_uname.Focus()
        conn.Close()