Latest Databases Posts

Hello, please refer following link to copy or transtfer your data base fast

https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html

May this will help you !

@bigakis could you enlighten how recurring invoice can be included with this schema!!

I know how you feel - PHP 7 has been trying its best to drive me crazy too.
I know its stricter than PHP 5, so I try to do my utmost best to adhere to the rules, like proper HTML construction.
I see in your code a body tag, but no html tag at the top or at the bottom. I also cannot find the closing body tag.
Did you omit these on purpose? If yes, adding them in might help.
Apart from manual debugging as suggested earlier, you could also try writing out the HTML code first, and running that to see if you have any errors from that end.
Let's know how it goes for you.

I use dbForge Studio for MySQL and for me the fastest way of database transfering is copy mySQL database method. This method is the most simple and requires the fewest clicks.

I changed this thread from code snippet to discussion/question. For future postings, code snippet is reserved for when you are posting a fully working and documented code snippet.

When facing this sort of issue I find myself adding print or echo debug lines so I can see how far the code went before it hung up OR to watch variables along the way. Noted in priors like https://www.php.net/manual/en/debugger.php you find that at some point you have to go old school (add lines to debug it.)

I do not have a clue as to what the problem is with this code. I am running php 7.0. This was an old form I used long ago, decided to upgrade it for random use. It works on php 5.0 but not in 7. I have run it through many php checks and not a problem is found. Does anyone have the answer for me? I would greatly appreciate it. No Errors shown just the white age of death.

<?php

include_once('jcart.php');

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

// Connects to your Database 
mysqli_connect("localhost", "dnk", "here1") or die(mysqli_error()); 
mysqli_select_db("dnnnk") or die(mysqli_error()); 

if (isset($_GET["Type"])) {
$Type = $_GET["Type"];
if (isset($_GET["AppID"])) {
$AppID = $_GET["AppID"];
}
else {
$AppID = 0;
}
$sql = "select * from parts WHERE ID = '$AppID'";
$result = mysqli_query($sql) or die(mysqli_error()); 
$row = mysqli_fetch_array($result);

}

?>
<body link="#293A2B" vlink="#8AAC91" alink="#000080">

<td height="70" style="font-family: Verdana; font-size: 14pt; text-decoration: overline underline; color: #3F5841; font-style: italic; font-weight: bold" width="321">
<p align="center"><?php echo htmlspecialchars($row["Manufacturer"]); ?></td>
<td width="351" align="center" height="70"><div style="width: 351px; height: 70px; overflow: auto">
  <div id="jcart"><?php $jcart->display_cart();?></div>
 </div></td>

<?php
  echo "<form method='post' action='' class='jcart'>
<input type='hidden' name='my-item-id' value='".$row['MfgNum']."'>
<input type='hidden' name='my-item-name' value='".$row['Description']."'>
<input type='hidden' name='my-item-price' value='".$row['Price']."'>
<input type='hidden' name='my-item-url' value=''>
<input type='hidden' name='my-item-core' value='".$row['CoreReq']."'>
";

echo "<tr>";
echo "<td align='left' valign='top' width='240' height='200' style ='font:16px/21px Arial,tahoma,sans-serif;color:navy'>".$row['Img']."</td>"; 
echo "<td align='left' valign='top' width='600' height='200' style ='font:14px/21px Arial,tahoma,sans-serif;color:navy'><br><br><br><b><u>Part Description:</u></b>&nbsp;&nbsp;".$row['Description']."<br>
<b><u>Manufacturer:</u></b>&nbsp;&nbsp;".$row['Manufacturer']."&nbsp;&nbsp;&nbsp;<br><b><u>Part Number:</b></u>&nbsp;&nbsp;".$row['MfgNum']."&nbsp;&nbsp;&nbsp;<br><b><u>Category:</b></u>&nbsp;&nbsp;".$row['Category']."&nbsp;&nbsp;&nbsp;<br><b><u>Core Required?:</b></u>&nbsp;&nbsp;".$row['CoreReq']."&nbsp;&nbsp;&nbsp;<br><br><b><u>Price:</u>&nbsp;&nbsp;</b>$".$row['Price']."<b>&nbsp;</b>".$row['UOM']."<br><br><a href='checkout.php'><img border='0' src='images/checkout.gif' width='119' height='21' alt='Checkout'></a>
<br><br>
<div style ='font:14px/21px Arial,tahoma,sans-serif;color:navy' id='fullTotal'></div> </td>  ";
 {
echo '<td><input type="text" name="my-item-qty" value="1" size="3" ...

Structured Query language (SQL) pronounced as "S-Q-L" or sometimes as "See-Quel"is actually the standard language for dealing with Relational Databases.
SQL is used to communicate with a database.
SQL programming can be effectively used to insert, search, update, delete database records.

There are many best sites where you can learn SQL easily. But if you are a beginner I recommend you to get such a tutorial which covers all the topics of SQL in a sequential order so that you will not have to face any difficulty during your learning phase.

I generally refer https://data-flair.training/blogs/sql-tutorials-home/ to learn SQL topics. As this site contains a complete package of SQL. Also the tutorials available in easy to understand language with good examples. Plus this site doesn't contain the advertisement, so I didn’t feel any distraction while reading their blogs.

Saving data from excel file to database will require a proper connection string to your database. Then on the button click you should add the code that will do the insert. Kindly check this tutorial which doest the exact thing - How to Import Excel File into Database in ASP.NET MVC

I hope it helps you.
Happy coding !

Hello to all.
I am developing software in vb.net for sales invoices. Where i need to import invoice data from excel file to vb.net Grid Data View and then save into access db. I will use db data in future for creating customer invoices. I have code that import excel data into GDV successfully, but i d'nt know how to save data in access db. Access db Name "MyInvoice" and table Name is 'InvoiceData'. Please help me to write correct code.
Thank You.

Imports System.Data.OleDb
Imports System.Data.SqlClient

Public Class MainForm

    Private Sub BtnImpExcelFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnImpExcelFile.Click
    Dim conn As OleDbConnection

    Dim dta As OleDbDataAdapter

    Dim dts As DataSet
    Dim excel As String
    Dim OpenFileDialog As New OpenFileDialog

    OpenFileDialog.InitialDirectory = My.Computer.FileSystem.SpecialDirectories.MyDocuments
    OpenFileDialog.Filter = "All Files (*.*)|*.*|Excel files (*.xlsx)|*.xlsx|CSV Files (*.csv)|*.csv|XLS Files (*.xls)|*xls"

    If (OpenFileDialog.ShowDialog(Me) = System.Windows.Forms.DialogResult.OK) Then

        Dim fi As New FileInfo(OpenFileDialog.FileName)
        Dim FileName As String = OpenFileDialog.FileName

        excel = fi.FullName
        conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excel + ";Extended Properties=Excel 12.0;")
        dta = New OleDbDataAdapter("Select * From [Sheet1$]", conn)
        dts = New DataSet
        dta.Fill(dts, "[Sheet1$]")
        DGVImpData.DataSource = dts
        DGVImpData.DataMember = "[Sheet1$]"
        conn.Close()
    End If
End Sub

End Class

JDBC tools like SQuirreL and jisql let you extract schema and data. I like to use LINUX sed to pipe a select into an insert, no intermediate files.

Convert or connect? Two entirely different problems to solve.

Convert may have use export to a common format and import to SQL. Given all that's on the web, I'll stop here.
Connect to an existing DBF might be what you really wanted. Google shows me I shouldn't write more: https://www.google.com/search?q=vb.net+dbf+connection+string

Hi all,

I have a new project with vb.net.
I need to always connect with older program that run in foxpro, i need to get dbf table and convert it to mysql table.
Can anyone help me ?

+1 for the "second thought"

I wouldn't use Settings variables. They are stored in clear text

(Depending on your language) it's only a few lines of code to encrypt all the info and Base64 encode it for storage in a "plain text" medium. IMHO that's a lot simpler than setting up and using a database and at least as secure.

First off I wouldn't use Settings variables. They are stored in clear text. Plus, you are limiting yourself to only one user. I would set up a small database (I suggest sqlite) and encrypt/scramble the username and password. If you don't want the user to access other parts of the program without registering, just don't display those forms until they have registered and logged in.

On second thought, because you are a beginner I suggest you stick with the Settings variables and clear text until you have the kinks worked out. Just make sure to put your username/password code in a module so that you can later change to a database with encryption without breaking the rest of your application.

Hello, I'm a beginner and I created a log-in form in VB.net using Windows Form and configuring the Settings of the project. I need help on how can I prevent the user from accessing the other parts of the program if they haven't registered yet, as well as deleting the data of the account registered by the user.

Basically, I put a "Forgot your password?" button that the User can click on the Log-In form (main form). When clicked, it leads to the Password Recovery form that asks them security questions to help them recover their account. However, I want to make the Password Recovery form inaccessible if the user hasn't registered yet.

My main questions are:

  • How can the program recognize that the user hasn't registered yet?
  • How can I have the option for the user to delete their account, to make the variables (Settings stuff) empty again? (For example, if they deleted the account, then they will have to register again before they can access other parts of the program.)

This is the code I used so the user couldn't log-in if they're not registered. However it isn't accurate yet because I haven't figured out what code to use if the User isn't registered yet. (If one of the My.Settings.Stuff is empty). I just used an Else statement which works but isn't what I really want.

Private Sub LogIn_Click(sender As Object, e As EventArgs) Handles LogIn.Click
        If username.Text = My.Settings.Username And password.Text = My.Settings.Password Then
            MsgBox("Login ...

The answer to most if not all the questions is yes. I wish folk would number their questions and always end a question with a question mark so everyone can find the question and answer them by the numbers.

But I'm going to stop here and note that if the user can create the logins then there seems to be no reason to have any user security since this person created all 5 accounts. It's one really odd design and even odder to limit it to five. Hardcoding that limit may be adding complexity where leaving it to nearly unlimited might be better. That is, you do the usual please enter you account name then password and check if they are a current user and if so connect to their database.

And yes, SQL would be a great step up in learning the better methods and can push the security back into the database since leaving it in your app means the database is usually insecure.

As to being new, that wears off in time. Mostly by continuing classes and tutorials.

hyperion0 commented: Alright, thank you for informing me! +0

I've realized my mistake of appearing to be asking for others to create my whole program. That is not what I want, as I want to be able to learn how it works and understand the code. I apologize for my mistake and I will keep this in mind.

So, I created a program in VB.Net with Windows Form and I want the user to be able to create a new user, limited to 5 user accounts only. I also want to know if it's possible to change password and delete user accounts.

Can I make it so that each User has their own MS Access database? For example, User 1 can only access Database1 but not Database2. And User 2 can only access Database2 but not Database1.

Here is the log-in form that I created that can only have one user account:

Public Class Form3
    Private Sub Register_Click(sender As Object, e As EventArgs) Handles Register.Click
        Try
            My.Settings.Name = NameTxt.Text
            My.Settings.Username = Username.Text
            My.Settings.Password = Password.Text
            My.Settings.Avatar = OpenFileDialog1.FileName
            My.Settings.status = True
            My.Settings.Save()
            MsgBox("Your account was successfully created.", MsgBoxStyle.Information)
        Catch ex As Exception
            MsgBox("Account failed to register.", MsgBoxStyle.Critical)
        End Try
    End Sub

    Private Sub LinkLabel1_LinkClicked(sender As Object, e As LinkLabelLinkClickedEventArgs) Handles LinkLabel1.LinkClicked
        Try
            OpenFileDialog1.Title = "Add Picture"
            OpenFileDialog1.FileName = ".png"
            OpenFileDialog1.Filter = "All Files|*.*"
            OpenFileDialog1.ShowDialog()
            PictureBox1.Image = System.Drawing.Image.FromFile(OpenFileDialog1.FileName)
        Catch ex As Exception
            'Do nothing'
        End Try
    End Sub
End Class

Is it possible to do that using only Settings of the project? Or do I really need to use MySQL (as I've seen from youtube tutorials)? I am only a beginner with little knowledge about programming, so please bear with me if my questions seem silly.

You appear to be asking for all the code for your application rather than help with your code. That's where you write your request for freelancers to create your app and deliver it good to go. Here we are fine with helping you with your code and it's trouble spots but for a total application and its code you need to post in a For Hire type posting.

Hi, I'm creating a project using VB.Net Windows Form and I want to create a Log-In form that can Add New User (Limited to 5 User Accounts), Delete User Account, and Change Password. I want to use Microsoft Access with it. What are the codes I should use to create it?

I also want each User to have their own database. For example, User 1 can only access Database1 but not Database2. And User 2 can only access Database2 but not Database1.

I am a beginner and I only see MySQL tutorials on YouTube but I don't have MySQL.

On my main form, I put two textbox where the user can log-in, a "Log-In" button, and a "Register" button. Register button leads to another form where the user can register.

Rhemiel commented: Thanks for the reply Alan +0

This is the process I want to attain:

  1. I have 4 buttons
  2. Each 4 buttons have categories under it
  3. When those categories is selected it shows list of datas
  4. The datas are like powerpoint empty slides

Can Someone give me some idea how to create relational database base on that idea?

Flow of the Category:
https://www.screencast.com/t/rYKS7zkXlKCD

Best Regards

I think there should be Column_name insted of Database_name
and there should be "if @mxdbvlu is null" insted of "if @mxdbvlu = null"
I tried after these changes and its working

i wants make pos software database guaide me

rproffitt commented: Safeer, asking in a 9+ year old discussion buried your plea for help. Make a new post, read the forum rules. -3

Can you tell me what you meant by "drop their out projects"? If it's a spelling error, fine but do correct this so folk know what you are asking.

Also why Turbo C++? It's from 1990, not that old is bad but for students, my advice is to move to something current like GNU C++, Visual Studio (Community Version is free) so they are not dealing with a near 30 year old system that will likely instill bad practices.

Hey! I am really stressed out about my TURBO CPP project. I wrote a program on periodic table using file handling. when i compiled it crashed and not the project is unusable. I want to submit it at the earliest. I was hoping some one might drop their out projects. Thanks.

mysql is free. you can also get it in xampp. many tutorial sites are available to explain it. you can also ask me for free help if you get stuck in tutorials

I just need a ton of information

Here it is:
MySQL docs.

You can test it here:

SQLfiddle

Vin vin commented: Thanks man, this will help even more :D +0

I have to Create an application that enables the user to create a file named grades.txt in which
to store grades. The app should allow the user to write to grades.txt file: student
number, student name, surname, subject, individual assignment grade, group
assignment grade, test grade.
When you click Create button grades.txt should be created in your app Debug folder.
When you click display button the file contents should display on datagridview.
Display at least 10 records.
Use LINQ to read and display file contents to datagridview. I'm not sure where to start.