- 0
how to insert data in a table that has a foreign key of another table using c++ code ?
-
Recently Browsing 0 members
- No registered users viewing this page.
-
Posts
-
By tsupersonic · Posted
That’s why I love classic Notepad from W10 IOT LTSC. It opens up instantly, uses very little resources, is just a plain notepad and nothing more. the title should be notepad has lost focus. -
By dismuter · Posted
Seeing my profile picture in Notepad creeped me out. I do not appreciate that Copilot is opt-out rather than opt-in. I don't want Notepad to have connectivity. The other improvements are fine, including the upcoming Markdown support (although I hate Markdown's handling of newlines with a passion). -
By theefool · Posted
More like Trelane: https://memory-alpha.fandom.com/wiki/Trelane But, yes, Q. -
By fishnet37222 · Posted
This would come in handy to me as an Uber driver. My biggest pet peeve is when passengers listen to their own audio on their phones without using headphones when they can hear I'm already playing music through my car's head unit. -
By hellowalkman · Posted
Astonishing new tech could kill headphones forever as it bends sound right into ears by Sayan Sen Imagine being able to listen to your favorite song or podcast out loud without disturbing anyone nearby even without wearing headphones. That’s what a team at Penn State University has been working on. Led by acoustics professor Yun Jing, they’ve come up with a clever way to create invisible audio zones called “audible enclaves” where sound can be heard only at one exact spot. They use ultrasound, which is normally inaudible to people, along with something called acoustic metasurfaces—tiny lenses that can bend sound in specific directions. By combining two ultrasound beams that travel in curved paths and meet at a single point, they’re able to make sound audible only at that intersection. As Jing explained, “The person standing at that point can hear sound, while anyone standing nearby would not. This creates a privacy barrier between people for private listening.” To make this happen, the system includes two ultrasonic speakers and the metasurface lenses, which were 3D printed by Xiaoxing Xia from Lawrence Livermore National Lab. Each beam has a slightly different frequency, and when they meet, a local reaction makes the sound audible. Neither beam is loud on its own—the sound only forms at that shared point. Jia-Xin “Jay” Zhong, one of the researchers, shared how they tested the idea: “We used a simulated head and torso dummy with microphones inside its ears to mimic what a human being hears at points along the ultrasonic beam trajectory, as well as a third microphone to scan the area of intersection. We confirmed that sound was not audible except at the point of intersection, which creates what we call an enclave.” One of the biggest advantages of their approach is that it works across a wide range of sound frequencies—between 125 Hz and 4 kHz, which covers most of what people can hears. Even in rooms where sound usually bounces around, their system held up well. And it’s surprisingly compact too: the whole setup measures about 16 centimeters, roughly the size of a pencil case. “We essentially created a virtual headset,” Zhong said. In practice, it means that someone standing in the audible enclave can hear what’s being played clearly, while everyone else around hears nothing at all. That could be especially useful in shared spaces like cars, classrooms, or open offices. Right now, the sound can travel about one meter and hits around 60 decibels which is similar to regular talking volume. The team believes they can push those limits further by using stronger ultrasound. All this might seem futuristic, but it’s grounded in solving a basic problem: how to direct sound only where it’s needed. If you’re into tech and sound design, this could open up a whole new world of personalized audio experiences. Source: Penn State, PNAS | Image via Depositphotos This article was generated with some help from AI and reviewed by an editor. Under Section 107 of the Copyright Act 1976, this material is used for the purpose of news reporting. Fair use is a use permitted by copyright statute that might otherwise be infringing.
-
-
Recent Achievements
-
leoniDAM earned a badge
First Post
-
Ian_ earned a badge
Reacting Well
-
Ian_ earned a badge
One Month Later
-
MacDaddyAz earned a badge
Dedicated
-
cekicen went up a rank
Explorer
-
-
Popular Contributors
-
Tell a friend
Question
niniben
I have a Table Bailleur
IDB IDF nameb Adresseb telb
----+------+------+---------------+-------
Where IDF is a foreign key to a table named Fournisseur
The Addresses Table:
IDF namef adressef telf
----+-------+----------+------+
This is a ONE-TO-N Relationship: Each Bailleur Has N fournisseur and each fournisseur has N bailleur
when i generated MPD I have a new table named fournir
IDF IDB
----+------
i want to insert data in "bailleur" by typing the name of founisseur which is namef and the IDF of "fournisseur" will be inserted into column IDF of table "bailleur" all this using c++
here is what ive tried i alredy inserted data in table "Fournisseur"
here im using bailleur in a class called bailleur
int qstate1;
MYSQL_ROW row1;
MYSQL_RES* res1;
void Bailleur::addb( MYSQL* conn){
string idf="";
cin.ignore(1, '\n');
cout << "Enter Nom du bailleur: ";
getline(cin, nomb);
cout << "Enter Adresse: ";
getline(cin, adresseb);
cout << "Enter tel : ";
getline(cin, telb);
cout<<"tapez le nom du fournisseur";
getline(cin,nomf);
string insert_query = ""insert into bailleur (IDF,nomb, tel_b ,adresseb)
values (select IDF from fournisseur where nomf = '"+nomfou+"'
,'"+nomb+"','"+telb+"','"+adresseb+"')";;
const char* q = insert_query.c_str();
qstate1 = mysql_query(conn, q);
if (!qstate1)
{
cout << endl << "Successfully added in database." << endl;
}
else
{
cout << "Query Execution Problem!" << mysql_errno(conn) << endl;
}
}
i expect output to be successfully added in database but its alway query execution problem
sorry for the long post this is my first time posting in neowin
Link to comment
https://www.neowin.net/forum/topic/1385153-how-to-insert-data-in-a-table-that-has-a-foreign-key-of-another-table-using-c-code/Share on other sites
0 answers to this question
Recommended Posts