insert php code
<?php
$host = "localhost";
$username = "username";
$pass = "";
$db="furniture";
// Create connection
$conn=mysqli_connect($host,$username,$pass,$db);
if(!$conn){
die("Data connection error");
}
?>insert php code
<?php
$host = "localhost";
$username = "username";
$pass = "";
$db="furniture";
// Create connection
$conn=mysqli_connect($host,$username,$pass,$db);
if(!$conn){
die("Data connection error");
}
?>insert into mysql c++
#include <mysql.h>
#include <iostream>
#include <iomanip>
#include <fstream>
using namespace std;
MYSQL *conn, mysql;
MYSQL_RES *res;
MYSQL_ROW row;
int query_state;
int main()
{
const char *server="students";
const char *user="*****";
const char *password="********";
const char *database="*****";
mysql_init(&mysql);
conn=mysql_real_connect(&mysql, server, user, password, database, 0, 0, 0);
if(conn==NULL)
{
cout<<mysql_error(&mysql)<<endl<<endl;
return 1;
}
query_state=mysql_query(conn, "select * from Instrument");
if(query_state!=0)
{
cout<<mysql_error(conn)<<endl<<endl;
return 1;
}
res=mysql_store_result(conn);
cout<<"MySQL Tables in mysql database."<<endl<<endl;
while((row=mysql_fetch_row(res))!=NULL)
{
cout<<left;
cout<<setw(18)<<row[0]
<<setw(18)<<row[1]
<<setw(18)<<row[2]
<<setw(18)<<row[3]<<endl;
}
cout<<endl<<endl;
ifstream infile;
infile.open("Instrument.txt");
if(infile.fail())
{
cout<<"ERROR. Could not open file!"<<endl;
return 1;
}
infile.seekg(0, infile.end);
int len=infile.tellg();
infile.seekg(0, infile.beg);
string instnum, insttype, maker, year, plID, name, salary, startdate;
string rating;
string instrument="INSERT INTO Instrument (InstrumentID, InstrumentType, MakerName, YearMade) VALUES ( '"+instnum+"', '"+insttype+"', '"+maker+"', '"+year+"')";
string player="INSERT INTO Player (PlayerID, Name, Salary, StartDate) values (plID, name, salary, startdate)";
string plays="INSERT INTO Plays (InstrumentID, PlayerID, Rating) values (instnum, plID, rating)";
// mysql_query(conn, "DELETE FROM Instrument WHERE MakerName='maker'");
while(infile)
{
infile>>instnum;
cout<<instnum<<endl;
infile>>insttype;
cout<<insttype<<endl;
infile>>maker;
cout<<maker<<endl;
infile>>year;
cout<<year<<endl;
query_state=mysql_query(conn, instrument.c_str());
}
if(query_state!=0)
{
cout<<mysql_error(conn)<<endl<<endl;
return 1;
}
cout<<endl<<endl;
mysql_free_result(res);
mysql_close(conn);
return 0;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
