Find Jobs
Hire Freelancers

wordpress table insert with multiple rows out of 1 record

$8-15 USD / hour

Igangværende
Slået op over 8 år siden

$8-15 USD / hour

I need some help with following WP query and insert. Query $arrAddress generates 1 record with address data from an address table. That works fine. Second query check if $user_id is present in testament table. If not present it must insert the data from address table into testament table. I do not know how to get the address data into table testament. Each address must get a record in testament table. Fields in wp_mm_testament are: userid, field_id, field_value $arrAddress = $GLOBALS['wpdb']->get_row('SELECT * FROM wp_mm_users_address WHERE user_id = "'.$user_id.'" '); $arrTestament = $GLOBALS['wpdb']->get_row('SELECT userid FROM wp_mm_testament WHERE userid = "'.$user_id.'" '); if(count($arrTestament) == 0) { // fields in wp_mm_testament are: userid, field_id, field_value if(count($arrAddress) > 0) { // wp_mm_users_address has address of user $user_id ['wpdb']->insert('wp_mm_testament', array( here is the problem to solve } } print_r($arrAddress) result: stdClass Object ( [id] => 3 [user_id] => 100 [gender] => m [first_name] => Meindert Hendrik [last_name] => Heide Groot [street_address] => Huizenbrink 12 [zipcode] => 8929GH [city] => Eibergen [country] => Nederland ) Task: write me how to get $arrAddress data into wp_mm_testament. Result of insert() in table wp_mm_testament. is then: userid, field_id, field_value 3, '3' => $arrAddress['first_name'], 3, '4' => $arrAddress['last_name'], 3, '5' => $arrAddress['gender'], 3, '6' => $arrAddress['street_address'], 3, '7' => $arrAddress['zipcode'], 3, '8' => $arrAddress['city'], 3, '9' => $arrAddress['country'] Realisation: today I only need how to insert the result into table wp_mm_testament. with ['wpdb']->insert('wp_mm_testament'
Projekt-ID: 8291318

Om projektet

11 forslag
Projekt på afstand
Aktiv 9 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
11 freelancere byder i gennemsnit $14 USD/time på dette job
Brug Avatar.
Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce,vBulletin , Zen cart-Drupal , android and IOS , I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
$8 USD på 40 dage
4,7 (526 anmeldelser)
8,4
8,4
Brug Avatar.
Hello Sir, Greeting for the day, Hope you are doing well We are Group of professional having more than 8 years’ experience in Windows/Linux Server administration , Website Hosting (Cpanel/Plesk) migration, Mail server configuration management ,CISCO Router Switches, Firewall(ASA,PIX,Sonicwall, cyberoam) ,Cloud Computing(AWS/Azure,office365), We provide support for small and medium companies to build their successful online businesses utilizing different platforms like Microsoft (Asp.net, SQL Server, C#, VB.net), LAMP, CMS like DNN, CATALLOK, Magneto, Word Press. We provide solutions focused web professional with comprehensive background orchestrating the design and development of cutting-edge web sites and user experiences that strategically leverage and maximize online presence. Please initiate chat to discuss your requirement in details. Thanks karun
$15 USD på 8 dage
4,9 (169 anmeldelser)
7,4
7,4
Brug Avatar.
Dear Sir, I am really interested to work on this project . I have very good experience of doing this sort of job, I can start the work now and can assure the best service from my end. I am waiting here to discuss about your project , please come on chat. Regards,
$20 USD på 3 dage
5,0 (242 anmeldelser)
7,1
7,1
Brug Avatar.
Hello , I have read your project details and requirements very carefully and I am very much confident that I can do it in time.. Please talk to me and give me a little chance. Thank You...
$8 USD på 30 dage
4,8 (103 anmeldelser)
7,4
7,4
Brug Avatar.
Get Professional & Creative website that help your business to grow.I am an expert web designer and developer, capable of developing any type of website. I can develop from a standard website to a complete online store. We provide following services: 1) Branding and Creative Design 2) Web Design and Development 3) E Commerce website / Online Store 4) Web Applications 5) Internet Marketing 6) Fashion/Photography Website 7) Web Hosting/ Email Hosting
$15 USD på 10 dage
4,8 (10 anmeldelser)
4,0
4,0
Brug Avatar.
Hello! I am from Nagpur, India. So what you need is to extract the data from the table and put it into the second table. Message me so that I can understand your task correctly...
$16 USD på 3 dage
5,0 (1 bedømmelse)
2,5
2,5
Brug Avatar.
A proposal has not yet been provided
$12 USD på 10 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for NETHERLANDS
Enschede, Netherlands
5,0
37
Betalingsmetode verificeret
Medlem siden jan. 1, 2011

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.