php - Insert array of variables into mysql database -


so… have echo statement:

echo  $results['results'][0]['url'].',' .$results['results'][1]['url'].',' .$results['results'][2]['url'].',' .$results['results'][3]['url'].',' .$results['results'][4]['url'].',' .$results['results'][5]['url'].',' .$results['results'][6]['url'].',' .$results['results'][7]['url'].',' .$results['results'][8]['url'].',' .$results['results'][9]['url'].','  .$results['results'][0]['title'].',' .$results['results'][1]['title'].',' .$results['results'][2]['title'].',' .$results['results'][3]['title'].',' .$results['results'][4]['title'].',' .$results['results'][5]['title'].',' .$results['results'][7]['title'].',' .$results['results'][8]['title'].',' .$results['results'][9]['title'].','  .$results['results'][0]['desc'].',' .$results['results'][1]['desc'].',' .$results['results'][2]['desc'].',' .$results['results'][3]['desc'].',' .$results['results'][4]['desc'].',' .$results['results'][5]['desc'].',' .$results['results'][6]['desc'].',' .$results['results'][7]['desc'].',' .$results['results'][8]['desc'].',' .$results['results'][9]['desc'];

that works, , outputs first 10 url’s, first 10 titles, , first 10 descriptions in google scraper have (i’m showing prove script works) (there many files show, not show them here). input data mysql database.

this echo, echos values this: keyword…

    http://cars.mainetoday.com/,http://www.nowvauxhall.co.uk/,http://www.youtube.com/watch?v=ndvggf0ltvo,......

like can see, separated commas, , ready input mysql database. connection , selection of data base taken care of small script working (or think). (once again, not going show files because connected , 5 or 6 of them , long), so… input code i’m using put row table:

mysql_query(  "insert  'seo'.'serp' ( `keyword` , `url1` , `url2` , `url3` , `url4` , `url5` , `url6` , `url7` , `url8` , `url9` , `url10` , `title1` , `title2` , `title3` , `title4` , `title5` , `title6` , `title7` , `title8` , `title9` , `title10` , `description1` , `description2` , `description3` , `description4` , `description5` , `description6` , `description7` , `description8` , `description9` , `description10` ) values ( 'cars sale',   ".htmlentities($results['results'][0]['url']).", ".htmlentities($results['results'][1]['url']).", ".htmlentities($results['results'][2]['url']).", ".htmlentities($results['results'][3]['url']).", ".htmlentities($results['results'][4]['url']).", ".htmlentities($results['results'][5]['url']).", ".htmlentities($results['results'][6]['url']).", ".htmlentities($results['results'][7]['url']).", ".htmlentities($results['results'][8]['url']).", ".htmlentities($results['results'][9]['url']).",  ".htmlentities($results['results'][0]['title']).", ".htmlentities($results['results'][1]['title']).", ".htmlentities($results['results'][2]['title']).", ".htmlentities($results['results'][3]['title']).", ".htmlentities($results['results'][4]['title']).", ".htmlentities($results['results'][5]['title']).", ".htmlentities($results['results'][6]['title']).", ".htmlentities($results['results'][7]['title']).", ".htmlentities($results['results'][8]['title']).", ".htmlentities($results['results'][9]['title']).",  ".htmlentities($results['results'][0]['desc']).", ".htmlentities($results['results'][1]['desc']).", ".htmlentities($results['results'][2]['desc']).", ".htmlentities($results['results'][3]['desc']).", ".htmlentities($results['results'][4]['desc']).", ".htmlentities($results['results'][5]['desc']).", ".htmlentities($results['results'][6]['desc']).", ".htmlentities($results['results'][7]['desc']).", ".htmlentities($results['results'][8]['desc']).", ".htmlentities($results['results'][9]['desc']));

the input row seems dislike table… ;) tried:

mysql_query(  "insert  'seo'.'serp' ( `keyword` , `url1` , `url2` , `url3` , `url4` , `url5` , `url6` , `url7` , `url8` , `url9` , `url10` , `title1` , `title2` , `title3` , `title4` , `title5` , `title6` , `title7` , `title8` , `title9` , `title10` , `description1` , `description2` , `description3` , `description4` , `description5` , `description6` , `description7` , `description8` , `description9` , `description10` ) values ( 'cars sale',   ".$results['results'][0]['url'].", ".$results['results'][1]['url'].", ".$results['results'][2]['url'].", ".$results['results'][3]['url'].", ".$results['results'][4]['url'].", ".$results['results'][5]['url'].", ".$results['results'][6]['url'].", ".$results['results'][7]['url'].", ".$results['results'][8]['url'].", ".$results['results'][9]['url'].",  ".$results['results'][0]['title'].", ".$results['results'][1]['title'].", ".$results['results'][2]['title'].", ".$results['results'][3]['title'].", ".$results['results'][4]['title'].", ".$results['results'][5]['title'].", ".$results['results'][6]['title'].", ".$results['results'][7]['title'].", ".$results['results'][8]['title'].", ".$results['results'][9]['title'].",  ".$results['results'][0]['desc'].", ".$results['results'][1]['desc'].", ".$results['results'][2]['desc'].", ".$results['results'][3]['desc'].", ".$results['results'][4]['desc'].", ".$results['results'][5]['desc'].", ".$results['results'][6]['desc'].", ".$results['results'][7]['desc'].", ".$results['results'][8]['desc'].", ".$results['results'][9]['desc']);

and still no results… no errors! ??? if echo works why can’t insert row??? , why not show errors? i’ve been working on 15 hours! i’m sure it’s simple...

i've tried foreach loops, 2 of them, 1 each subset of variables. no error, no rows inserted.

can help? thanks, miguel

like this?

mysql_query(  "insert  'seo'.'serp' ( `keyword` , `url1` , `url2` , `url3` , `url4` , `url5` , `url6` , `url7` , `url8` , `url9` , `url10` , `title1` , `title2` , `title3` , `title4` , `title5` , `title6` , `title7` , `title8` , `title9` , `title10` , `description1` , `description2` , `description3` , `description4` , `description5` , `description6` , `description7` , `description8` , `description9` , `description10` ) values ( 'cars sale',    '".htmlentities($results['results'][0]['url'])."', '".htmlentities($results['results'][1]['url'])."', '".htmlentities($results['results'][2]['url'])."', '".htmlentities($results['results'][3]['url'])."', '".htmlentities($results['results'][4]['url'])."', '".htmlentities($results['results'][5]['url'])."', '".htmlentities($results['results'][6]['url'])."', '".htmlentities($results['results'][7]['url'])."', '".htmlentities($results['results'][8]['url'])."', '".htmlentities($results['results'][9]['url'])."',  '".htmlentities($results['results'][0]['title'])."', '".htmlentities($results['results'][1]['title'])."', '".htmlentities($results['results'][2]['title'])."', '".htmlentities($results['results'][3]['title'])."', '".htmlentities($results['results'][4]['title'])."', '".htmlentities($results['results'][5]['title'])."', '".htmlentities($results['results'][6]['title'])."', '".htmlentities($results['results'][7]['title'])."', '".htmlentities($results['results'][8]['title'])."', '".htmlentities($results['results'][9]['title'])."',  '".htmlentities($results['results'][0]['desc'])."', '".htmlentities($results['results'][1]['desc'])."', '".htmlentities($results['results'][2]['desc'])."', '".htmlentities($results['results'][3]['desc'])."', '".htmlentities($results['results'][4]['desc'])."', '".htmlentities($results['results'][5]['desc'])."', '".htmlentities($results['results'][6]['desc'])."', '".htmlentities($results['results'][7]['desc'])."', '".htmlentities($results['results'][8]['desc'])."', '".htmlentities($results['results'][9]['desc'])."')")

not working, no errors...

ther connect file:

<?php  $conn_error = 'could not connect.';  $mysql_host = 'localhost'; $mysql_user = 'root'; $mysql_pass = '';  $mysql_db = 'seo';  if (!mysql_connect($mysql_host, $mysql_user, $mysql_pass)||!mysql_select_db($mysql_db)) {  die($conn_error); } echo 'connected'; ?>

like see @ echo @ top of page, gives "connected" @ end...

any other sugjestions?

you have enclose text data in ' this

'".htmlentities($results['results'][0]['url'])."', ^                                               ^

others well


Comments

Post a Comment

Popular posts from this blog

Why does Ruby on Rails generate add a blank line to the end of a file? -

running rails generate controller foo home results in: class foocontroller < application controller def home end end (there's nothing on line in actual file, blank line) is there purpose blank line? it's common use newline indicate end of line, last line. many editors (like vi, use) add in newline silently. consensus text files (especially in unix world) should end in newline, , there have been problems historically if wasn't present. why should text files end newline? the tool used count lines in file "wc" counts newlines in file, without trailing newline show 3 instead of 4. it improves readability of templates used in generator. consider: https://github.com/rails/rails/blob/master/railties/lib/rails/generators/rails/controller/templates/controller.rb to remove trailing newline, template have last line of: end<% end -%> instead of: end <% end -%> that seems less readable me. the discussion below refers ...
Read more

node.js - Bad Request - node js ajax post -

i'm using express 3.0 , node v0.11.0. have button submits form , i'm using ajax post data json object node server. client code is: $('#contact').submit(function(e) { console.log('submit called'); var formdata = json.stringify($('form').serializeobject()); console.log(formdata); $.ajax({ url: "http://localhost:3000/savedata/", type: "post", datatype: 'json', data: {objectdata: formdata}, contenttype: "application/json", complete: function() { console.log('process complete'); }, success: function(data) { console.log('process sucess'); }, error: function() { console.log('process error'); }, }); return false; }); then on server: var express = require('express'); var app = express(); app.set('views', __dirname + '/views'); app.set('view engine', 'jade'); app.use(express.bodyparser());...
Read more

uitableview - Create and use custom prototype table cells in xamarin ios using storyboard -

Image
is possible create , use 'custom' prototype table cells in xamarin ios (monotouch) using storyboard? i find stuart lodge explaining method using xib/nibs: http://www.youtube.com/watch?feature=player_embedded&v=vd1p2gz8jfy let's answer question! looking one. :) 1) open storyboard have viewcontroller tableview: add prototype cell (if there no cell added before): customize cell want (in case there custom uiimage , label): remember set height of cell. select whole tableview , properties window select "layout" tab. on top of properties window should see "row height" - put appropriate value: now select prototype cell once again. in properties window type name of class (it create code-behind class it). in case "friendscustomtableviewcell". after provide "identifier" cell. can see "friendcell". last thing set "style" property set custom. "name" field should empty. once click ...
Read more