database - PHP mysqli adding multipe entries for one insert -


the following short php code should adding 1 entry database table. when run find 3 identical entries.
mysql server version: 5.5.39 - mysql community server

php/5.4.31 

<?php // connect temp db $db_host = "localhost"; $db_username = "root"; $db_password = ""; $db_name = "tempdb";  // create connection $conn = new mysqli($db_host, $db_username, $db_password, $db_name); if ($conn->connect_error)    {  die("connection failed: " . $conn->connect_error);  } $mysqlstr = "    insert      tempproduct (         `productname`, `merchantid`,  `merchant`, `mylink`, `thumbnail`,          `bigimage`, `price`, `retailprice`, `category`, `subcategory`,          `description`,          `custom1`, `custom2`, `custom3`, `custom4`,  `custom5`,          `lastupdated`, `productstatus`, `manufacturer`,          `partnumber`, `merchantcategory`, `merchantsubcategory`,          `shortdescription`,          `isbn`, `upc`, `sku`, `crosssell`,          `merchantgroup`, `merchantsubgroup`, `compatiblewith`,          `compareto`, `quantitydiscount`, `bestseller`, `addtocarturl`,          `reviewsrssurl`, `option1`, `option2`, `option3`, `option4`,          `option5`, `mobileurl`, `mobileimage`, `mobilethumbnail`     )      values(          'fossil editor leather ladies watch es3242', '32800', 'pricefalls.com',  '[some url]', '[some url]',           '[some url]', '113.10', '145', 'fashion', 'jewelry',           'stainless steel case. white leather strap. white dial. day date , 24-hour time. quartz movement. water resistant 50 meters. case 38mm. buckle closure.',           'silver', 'stainless steel', '', '38', 'female',           '2015-06-24 14:21:30',  'instock', 'fossil',           'es3242', 'jewelry & watches', 'watches',           'stainless steel case. white leather strap. white dial. day date , 24-hour time. quartz movement. water resistant 50 meters. case 38mm. buckle closure.',           '', '691464976040', '4907551', '', '', '', '', '', '',           '0', '', '', '', '', '', '', '', '', '', ''     )"; mysqli_query($conn,$mysqlstr); // $conn->query($mysqlstr);   echo "done";  $conn->close(); ?>


Comments

Post a Comment

Popular posts from this blog

user interface - how to replace an ongoing process of image capture from another process call over the same ImageLabel in python's GUI TKinter -

i trying use following code create interactive gui changes color-space(hsv, rbg, grayscale etc) on event of button click. display opencv video in tkinter using multiprocessing being new python having problems multiprocessing , attempts on making gui change it's color space on button clicks hangs entire system. on it's implementation highly appreciated. thankyou. below code: import cv2 pil import image,imagetk import tkinter tk import numpy np multiprocessing import process , queue def quit_it(root,process): root.destroy() process.terminate() def black_andwhite(root,process): process.terminate p=process(target=capture_image, args=(5,queue, )) p.start() root.after(0, func=lambda: update_all(root, image_label, queue)) def update_image(image_label, queue): frame = queue.get() = image.fromarray(frame) b = imagetk.photoimage(image=a) image_label.configure(image=b) image_label._image_cache = b root.update() def update_all(root...
Read more

javascript - Restarting Supervisor and effect on FlaskSocketIO -

in index.html (html/javascript) have: $(document).ready(function(){ namespace = '/test'; var socket = io.connect('http://' + document.domain + ':' + location.port + namespace); socket.on('connect', function() { socket.emit('join', {room: 'venue_1'}); }); socket.on('my response', function(msg) { $('#log').append('<br>received #' + ': ' + msg.data); }); }); on server have: @socketio.on('connect', namespace='/test') def test_connect(): if session.get('venue_id'): emit('my response', {'data': 'connected'}) session.pop('venue_id', none) else: request.namespace.disconnect() @socketio.on('join', namespace='/test') def join(message): join_room(message['room']) room = message[...
Read more

android - Format a french phone number -

i have format "0612345678" "06 12 34 56 78". i'm using : private string formattel(string number) { try { string formattednumber = ""; int i; (i = 0; < 10; += 2) { formattednumber += number.substring(i, + 2) + " "; } return formattednumber.substring(0, formattednumber.length() - 1); } catch (indexoutofboundsexception e) { return number; } } it works on emulator running api 16 (jellybean 4.1.1) : on it, result looks want ("06 12 34 56 78") on own phone, (api 22, lollipop 5.1.1), doesn't work : result "0 61 23 45 67" whereas method same ! i did research , i've found string.format method. it's here need help, it's hard me... ! thank in advance :d edit : working method, using libphonenumber : private string formattel(string number) { string formattednumber = number; try { phonenumberutil phonenumberutil = ph...
Read more