Suoritettu

Quick Fix After PHP MySQL Add/Insert, get key & use to ADD to 2nd File

Adding a record, then using key after record created to link 2 files. 2nd file should also use same key OR if not possible add plus using key as other field. What's possible, you tell me.

mysql_connect("$hostname", "$username", "$password", "$database");

mysql_select_db("$database");

$sql = "INSERT INTO %%%%%% SET tir_clientstoreid = '".$parentstoreid."', tir_addedassoc = '".$statelaw_verifyassoc."', tir_changeassoc = '".$statelaw_verifyassoc."', tir_width = '".$pickwidth."', tir_name = '".$tirename."', tir_sidewall = '".$pickratio."', tir_rim = '".$pickrim."', tir_pending = '".$pending."', tir_invlocation = '".$invlocation."', tir_price = '".$invprice."', tir_make = '".$pickmake."', tir_addeddate = '".$nowtimestamp."' ";

$res = mysql_query($sql) or die(mysql_error());

//Getting last inserted id for tbl_tires. Same id is id for tbl_tire_law_defects

if (mysqli_query($conn, $sql)) {

$last_id = mysqli_insert_id($conn);

echo "New record created successfully. Last inserted ID is: " . $last_id;

} else {

echo "Error: " . $sql . "<br>" . mysqli_error($conn);

}

mysql_close();

mysql_connect("$hostname", "$username", "$password", "$database");

mysql_select_db("$database");

$sql = "INSERT INTO %%%%%%%% SET tir_law_id = '".$last_id."',

Here's the line that I saw similar code working, but still needs changes:

echo "New record created successfully. Last inserted ID is: " . $last_id;

Then, the last line refers to $last_id:

$sql = "INSERT INTO %%%%%%%% SET tir_law_id = '".$last_id."',

Taidot: HTML, MySQL, PHP, SQL, verkkosivujen suunnittelu

Näytä lisää: php mysql database insert edit delete, php mysql table insert form, php mysql table insert delete script, how to insert data into mysql db using form in php database, how to insert data in mysql using php, php mysqli insert, how to create an html form that stores data in a mysql database using php, how to avoid inserting duplicate records in mysql using php, insert into select mysql php, get insert statement for existing row in mysql, how to insert data in phpmyadmin using php, php mysql confirm insert success, php mysql ajax insert data, php mysql plugin insert update, search fix data php mysql, php mysql ajax insert database, php mysql ajax insert fetch, ajax form php mysql data insert, fix bugs php mysql

Tietoa työnantajasta:
( 10 arvostelua ) Columbus, United States

Projektin tunnus: #19342994

Myönnetty käyttäjälle:

sergeyprince

hello, i saw your project details and i can do it perfectly. mysql database manage & programming is my best work. also i have a enough history in this part. if you see my profile, you will know. i expect hired by Lisää

$10 USD 0 päivässä
(2 Arvostelua)
0.6

20 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

tlchung

I can do the fix for you. I am a skilled developer with over 10 years experience. let discuss more via private message.

$30 USD 2 päivässä
(476 arvostelua)
7.4
shailendra041090

HI, My name is Shail, I have read your brief, I can fix this issue, I can do this now only. I can start the work now only

$10 USD 1 päivässä
(194 arvostelua)
6.8
ykarora26

Hello, I have 8+ year of expertise in WordPress, PHP/MySQL, HTML5, Responsive Design, Ajax, JQuery and CSS. I can develop any type of websites using WordPress like e-Commerce, Real estate, Social Networking, Lisää

$25 USD 1 päivässä
(197 arvostelua)
7.0
techwelfare

Yes! We can do this!just want to discuss more about the [login to view URL] reply us. we are an expert team,we could do everything you [login to view URL] share ever details with us. we are waiting eagerly.

$50 USD 1 päivässä
(198 arvostelua)
7.3
hamidejaz024

Hello I'm experienced php developer and i'm sure i can start work right now. i'll fix it asap. Let me know if you need my help. Thank

$15 USD 1 päivässä
(133 arvostelua)
6.4
kipdev13

Hi! I have experiences for 15+ years about IT programming. I have done your proposal quickly and then u will show good result. I want your detailed schedule. Thanks.

$30 USD 1 päivässä
(67 arvostelua)
6.4
ludwig333

Hello ! I am a full stack developer for over 5 years on the freelancer.com. I have read your description in more detail and have much interest in your project. I have many experiences what I have ever done before Lisää

$25 USD 1 päivässä
(51 arvostelua)
6.1
tainguyen1990

Hello sir, I have read your requirement. I can help you fix the errors of that website I have a lot of experience in programming as .NET,PHP, Wordpress, JQuery, Laravel, Codeigniter , Angularjs, Nodejs etc

$25 USD 1 päivässä
(18 arvostelua)
5.2
aswebsmart

Hi, I have read through your job descriptions, and I understand all of the requirements. I am applying because I believe that I have the required skill set to complete your project. I have been working as a PHP deve Lisää

$25 USD 1 päivässä
(31 arvostelua)
4.5
Dmitry610

Hello Employer, Greetings for the day! ⭐⭐⭐⭐⭐ I CAN START IMMEDIATELY ⭐⭐⭐⭐⭐ My name is Dmitry Kraitor and I am individual full-stack&full-time web developer. I have gone through the project description and I Lisää

$50 USD 1 päivässä
(20 arvostelua)
5.0
finaldragon123

Hello! I think your project is best for me and send you a bid. I am a web expert who knows the value of time, working hard and always working on time. My motivation is to make my employer feel the greatest satisf Lisää

$30 USD 1 päivässä
(10 arvostelua)
4.0
krupa2806

Dear sir/madam, I have 4 years of experience in mobile and web development with wide skill. I am skilled in mobile application development as well as web application development. Qualifications and experience inc Lisää

$45 USD 1 päivässä
(12 arvostelua)
3.7
WebCoderDelowar

Hi, I can help you with your MySQL query but it's not fully clear what you want to achieve. can explain a bit more please?

$25 USD 1 päivässä
(15 arvostelua)
3.5
w3tridip2017

Hi, I've read carefully of your job description about "Quick Fix After PHP MySQL Add/Insert, get key & use to ADD to 2nd File".I am a professional "Full Stack Web Developer".I have more than five years experience in W Lisää

$25 USD 1 päivässä
(18 arvostelua)
3.7
pratamatama10

Hi there, seems like you got a problem right there, I can help you for fixing it. I have experiences on building websites similar to Microsoft To-Do List, Twitter, Pizza Hut and Bukalapak using PHP, Laravel, Vue.js an Lisää

$10 USD 1 päivässä
(0 arvostelua)
0.0
SNSoHaG6

Hello, how are you? I think you're fine. I have a proposal for your project, I'm a new freelancer. I'm only new in this platform. But to be honest i have many experience on web design and developing. Now i'm buildi Lisää

$10 USD 1 päivässä
(0 arvostelua)
0.0
devhammed

I bring years of web/application development experience to the table and i like to think i possess high work ethics, so you wont have to worry about getting the job done efficiently. I'm happy to start working on th Lisää

$50 USD 1 päivässä
(0 arvostelua)
0.0
occultskyrong

as a full stack developer for 10+years ,I have been proficient in php development and database design .This is a simple task and I can discuss with you about the details . I am looking forward to hearing from you .

$25 USD 1 päivässä
(0 arvostelua)
0.0
vw1514518vw

Send the tables structure only or with some data , will give you a code that work and do as you need Best

$105 USD 1 päivässä
(0 arvostelua)
0.0