Google API addslashes array element

[codelancer]

Thanks for you time in advance

I am working on a little script for the Google API,

I want to grab the results from the search results and put them in a database, however I want to addslashes to the elements before they are printed to the screen, I have tried everything but still can not get it right..

// snippet below

  for ($i = 0; $i < $MaxResults; $i++)
  {
    $Element     = $QueryResult[$i];
    $Snippet[$i] = utf8_decode($Element ["snippet"]);
    $URL[$i]     = $Element["URL"];
    $Title[$i]   = utf8_decode($Element["title"]);

// who can I addslashes to the elements before out putting to the browser..

thanks for any assistance

[codelancer]

// here is the output from the script

INSERT INTO home_loans ( title , snippet , url ) VALUES ('Home Loans, Mortgage Loans, & Home Mortgage Loan Refinancing', 'The Home Loans Advisor provides free mortgage refinancing, home
loan, home improvement, and home equity loan quotes. ... ', 'http://www.homeloanadvisor.com/');

INSERT INTO home_loans ( title , description , base ) VALUES ('Loan Guaranty Homepage', 'Information on the Home Loan Program. ... Veterans Information Portal / Information
on the Home Loan Program / Am I Eligible for a VA Loan? ... ', 'http://www.homeloans.va.gov/');

.....etc

// so as you can see this insert command can get pretty hariy if there are no addslashes

eg..

[PHPMagician]

To understand better the problem it would be better to show us a more complete code sample. At the moment, I don't even know which variable you are printing, if you are looping through the results correctly, etc.

[codelancer]

Thanks for any help ..this is the results.php file for the google api,

what I want to do is take these elements , which are passed to smarty and addslashes to the output.. After this is outputted to the browser, I want to insert this out put into the database..

$Element = $QueryResult[$i];
$Snippet[$i] = utf8_decode($Element ["snippet"]);
$URL[$i] = $Element["URL"];
$Title[$i] = utf8_decode($Element["title"]);

#############################
####resuslts.php
#############################

<?php
include_once('nusoap.php');
include_once('htmlfuncs.php');

include_once('background.php');
include_once('pagemenu.php');
include_once(SmartyClass());

function SearchResults()
{
//Create template object.
$ResultsTemplate = new Smarty;
$ResultsTemplate->compile_dir = FullSmartyCompileDir();

$Query = GetParam("Query", "");

if ($Query == "")
{
  return;
}

$Site = GetParam("Site", "");
if ($Site != "")
{
  $Site = " site:$Site";
}

$Start = intval(GetParam("Start", 0));

$GoogleKey    = GoogleKey();
$GoogleAPIURL = GoogleAPIURL();
$MaxResults   = MaxResults();

$Param = array("key"         => $GoogleKey,
               "q"           => $Query.$Site,                 
               "start"       => $Start,
               "maxResults"  => $MaxResults,
               "filter"      => false,
               "restrict"    => "",
               "safeSearch"  => false,
               "lr"          => "lang_en",
               "ie"          => "",
               "oe"          => "");             

// Create a new client by providing the endpoint to the constructor.
$Client = new soapclient($GoogleAPIURL);

$QueryResult = $Client->call("doGoogleSearch", $Param, "urn:GoogleSearch");
$Searchtime  = $QueryResult["searchTime"];
$Begin       = $Start + 1;
$End         = $Start + $Param["maxResults"];
$Total       = $QueryResult["estimatedTotalResultsCount"]; 

if ($Total > 0)
{
  $QueryResult = $QueryResult["resultElements"]; 

  for ($i = 0; $i < $MaxResults; $i++)
  // must add slashes here
  {
    $Element     = $QueryResult[$i];
    $Snippet[$i] = utf8_decode($Element ["snippet"]);
    $URL[$i]     = $Element["URL"];
    $Title[$i]   = utf8_decode($Element["title"]);




  }

  $ResultsTemplate->Assign('Snippet', $Snippet);
  $ResultsTemplate->Assign('URL', $URL);
  $ResultsTemplate->Assign('Title', $Title);

  $Result  = $ResultsTemplate->fetch('results.tpl.htm') . PageMenu($Query, $Site, $Start, $Total, $MaxResults);
}
else
{
  $Result = $ResultsTemplate->fetch('noresults.tpl.htm');
}

return $Result;    

}

?>

###################################
results.tpl.htm file for smarty
###################################

{section name=i loop=$Title}

INSERT INTO home_loans ( title , description , base ) VALUES
('{$Title}',
'{$Snippet}',
'{$URL}');

{/section}

###################################

go give you an idea of what I am trying to do go here
http://usedcaralabama.com/google/index.php?Query=home%20loans


As you can see I want to cut and paste these directly into a phpmyadmin..


I am a beginner so please be patient..


God Bless

[PHPMagician]

I am a bit confused of your intent. You want to addslashes, so I am not really sure why you don't just use (http://www.php.net/addslashes) to all the output (why do you want to addslashes to output?).

Basically:

<?php
include_once('nusoap.php');
include_once('htmlfuncs.php');
include_once('background.php');
include_once('pagemenu.php');
include_once(SmartyClass());

function SearchResults()
{
//Create template object.
$ResultsTemplate = new Smarty;
$ResultsTemplate->compile_dir = FullSmartyCompileDir();

$Query = GetParam("Query", "");

if ($Query == "")
{
return;
}

$Site = GetParam("Site", "");
if ($Site != "")
{
$Site = " site:$Site";
}

$Start = intval(GetParam("Start", 0));

$GoogleKey = GoogleKey();
$GoogleAPIURL = GoogleAPIURL();
$MaxResults = MaxResults();

$Param = array("key" => $GoogleKey,
"q" => $Query.$Site,
"start" => $Start,
"maxResults" => $MaxResults,
"filter" => false,
"restrict" => "",
"safeSearch" => false,
"lr" => "lang_en",
"ie" => "",
"oe" => "");

// Create a new client by providing the endpoint to the constructor.
$Client = new soapclient($GoogleAPIURL);

$QueryResult = $Client->call("doGoogleSearch", $Param, "urn:GoogleSearch");
$Searchtime = $QueryResult["searchTime"];
$Begin = $Start + 1;
$End = $Start + $Param["maxResults"];
$Total = $QueryResult["estimatedTotalResultsCount"];

if ($Total > 0)
{
$QueryResult = $QueryResult["resultElements"];

for ($i = 0; $i < $MaxResults; $i++)
// must add slashes here
/* EDITED: So we will addslashes (???) */
{
$Element = $QueryResult[$i];
$Snippet[$i] = addslashes(utf8_decode($Element ["snippet"]));
$URL[$i] = addslashes($Element["URL"]);
$Title[$i] = addslashes(utf8_decode($Element["title"]));




}

$ResultsTemplate->Assign('Snippet', $Snippet);
$ResultsTemplate->Assign('URL', $URL);
$ResultsTemplate->Assign('Title', $Title);

$Result = $ResultsTemplate->fetch('results.tpl.htm') . PageMenu($Query, $Site, $Start, $Total, $MaxResults);
}
else
{
$Result = $ResultsTemplate->fetch('noresults.tpl.htm');
}

return $Result;
}

?>

I don't really understand why you want to copy and paste URL into phpMyAdmin, when this system could be fully automatic instead of you manually doing it.

[codelancer]

Hi Magician,

Thanks for your help..

I don't really understand why you want to copy and paste URL into phpMyAdmin, when this system could be fully automatic instead of you manually doing it.

The reason why I am not doing this ..is because I have not figured out how to do it..(I am working on it though)

// the addslashes didn't cause any errors 🙂, however maybe I am not explaining clearly enough of what I want to achieve...

example::

INSERT INTO home_loans ( title , description , base ) VALUES
(
'FCIC: Borrower's Guide to Home Loans',
'Borrower's Guide to Home Loans. equity loans, ... ',
'http://www.puebloloans.com);

(
Borrower's Guide causes problems when I paste this into phpmyadmin bc of the 's
)

So this is what my plan is .. I am learning the steps one by one..( unfortunately it is manual) once I learn how to do it manually ..hopefully I will be able to figure out a way to do it automatically.

// The ideal system would be to do a search, grab the results and automatically put them in a database.... once I have them in the database things will be rocking 🙂

basically I want to have about 100 different links for each category..for my directory I am creating... If you want to message me I can show you more in depth ...the project I am working on..

Peace..

codelancer

[PHPMagician]

The addslashes should have added slashes to that portion of the query (if I understood the code correctly). The only thing which may be causing additional conflicts is magic_quotes_runtime (http://ie2.php.net/manual/pt_BR/ref.info.php#ini.magic-quotes-runtime)

The only other thing is you could be looping incorrectly through the results - though probably not the case.