PHP - Saving Google Adsense Code In Php Variable For Reuse Throughout Site?

I wrote this basic script yesterday to process and generate a Google Site Map. And it works! BUT I want to advance this script to accommodate for something else and I don't know the correct path to take from here, but I will tell you what I've found out so far..

Current Situation:

1 - Currently my below script generates urls in the site map like:
http://abcdefg.com/index.php?dispatch=products.view&product_id=29826

2 - I have .htaccess configured to rewrite the urls to the products name data like:
http://abcdefg.com/pennies/wheat-pennies/lincoln-wheat-penny-cent.html (just an example) and these urls are ONLY active if clicking on the site links themselves - meaning if I enter: http://abcdefg.com/index.php?dispatch=products.view&product_id=29826 directly into the url, the url does not resolve to this natural friendly url name.

What Id like to achieve (which I don't know what direction I should be looking!):

- I'd like my xml output urls (as current) to be written in the natural format (as in #2 above).

FYI here is a current example output item in my sitemap:

Code: [Select]
<url>
  <loc>http://abcdefg.com/index.php?dispatch=products.view&amp;product_id=29803</loc>
  <changefreq>weekly</changefreq>
  <lastmod>2010-09-24T08:00:00+04:00</lastmod>
 </url>
Can anyone give me some guidance on what method might work for this? Do you think it's more a mod_rewrite issue? Or can this be handled easier with straight up modifications to my below? I'm just a bit confused on what direction I should be looking.. Thanks for any input.

<?php
header("Content-Type: text/xml;charset=iso-8859-1");
  echo '<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
 //include('config.local.php');
  $cxn = mysqli_connect($config['db_host'], $config['db_user'], $config['db_password'], $config['db_name']);
  $query = "SELECT cscart_product_descriptions.product_id, cscart_products.product_id, cscart_products.timestamp
FROM cscart_product_descriptions JOIN cscart_products ON cscart_product_descriptions.product_id = cscart_products.product_id
WHERE cscart_products.status='A' LIMIT 10000";
  $result = mysqli_query($cxn, $query);
  $row = mysqli_fetch_array($result);
  while ($row = mysqli_fetch_array($result)) {
  $formatedTime = $row['timestamp'];
      echo '<url>
  <loc>http://abcdefg.com/index.php?dispatch=products.view&amp;product_id=' . $row['product_id'] . '</loc>
  <changefreq>weekly</changefreq>
  <lastmod>'. date('c',$formatedTime) .'</lastmod>
  </url>';
  } //while ($row = mysqli_fetch_array($result))
  echo '</urlset>';
?>

my value,

selectname.push(element.name);
selectqty.push(element.qty);

How to pass Google charts function,

 

$.each(data, function(index, element) {

                        selectname.push(element.name);
                        selectqty.push(element.qty);

                        google.charts.load('current', {
                            'packages': ['corechart']
                        });
                        google.charts.setOnLoadCallback(drawChart);

                        function drawChart() {
                            var data1 = google.visualization.arrayToDataTable([
                                ['Task', 'Hours per Day'],
                                ['Work', 11],
                                ['Eat', 2],
                                ['Commute', 2],
                                ['Watch TV', 2],
                                ['Sleep', 7]
                            ]);


                            //    var data1 = google.visualization.arrayToDataTable([
                            //         [element.name, element.qty],
                            // //
                            //     ]);
                            var options = {
                                title: 'Top 5 Best Selling Products'
                            };

                            var chart = new google.visualization.PieChart(document.getElementById('piechart'));

                            chart.draw(data1, options);
                        }

 

Can I use the data fetched with the mysql_fetch_assoc command more than once?  What I'm trying to do is query a MySQL DB, and print a list of the results by gender.  So far I've only been able to do it by querying the DB twice, and I know there's got to be a more efficient way.  I think I should be able to go through the array once, print all the males, then go through the array again and print all the females.  But I'm stumped as to how to do it.

Here's basically what I'm doing to get my results:

Code: [Select]
$cxn=mysqli_connect("localhost","username","password","table_name") or die ("Could not connect to database");               
$query= "SELECT * FROM blah blah blah";
$result=mysqli_query($cxn,$query) or die ("Couldn't execute query.");
                           
while ( $row = mysqli_fetch_assoc($result))
{
           extract($row);
           IF ($gender == 'M')
               {
                  echo "Here is my data for Males";
                }
}
I basically want to re-run the WHILE statement, but check for $gender == 'F', without having to re-run the $result=mysqli_query command again.  But when I do that, nothing is displayed and the script ends. Is it just a matter of moving a pointer to the beginning of an array or something similar?

Thanks in advance.

I want to reuse the data from getFaq for different levels of a website. 

$fcid is the variable. 
 

Creating the full page in the getFaq function could work but limits the function to one set of results,

Do I need to create a new function if I want to create another page with the data and a new call to the database?

It seems to me there must be a way to store the array from $fcid  and call it from another page to get a subset of the data. 

I added the getFP class as an attempt to do just that but I am getting no results. 

If I place the code in the getFP class in the getFAQ function the script works as envisioned. 

I want to create a getFAQpage, a getFAQheader and a getFAQsubset based on  categories. 

The data is all there in $fcid but I have no idea on how to access it from outside the class. 

Dbh is the PDO connection. 

 

Class GetData extends Dbh {
	
			
		public function getFaq($site) {
			$sql = "SELECT faq_cats.faqc_name, faqs.faq_question, faqs.faq_answer FROM faq_cats INNER JOIN faqs ON faq_cats.faqc_id = faqs.faq_cat WHERE faq_cats.faqc_site = ? ORDER BY faq_cats.faqc_name";
			$stmt = $this->connect()->prepare($sql);
			$stmt->execute([$site]);
			$fcid = $stmt->fetchAll();
			return $fcid;	
		}

	}

	Class getFP extends GetData {

		
		public function getFaqPage([$fcid]) {
			
			$fcid = $this->fcid;
			$fhead = null;		
				foreach ($fcid as $faq) {
					$fname = $faq["faqc_name"];			
					$fquest = $faq["faq_question"];
					$fans = $faq["faq_answer"];
					
						if ($fhead != $fname) {
							echo "<h2>".$fname."</h2>";
						}
	
					echo $fquest."<br />".$fans."<br /><br />";
					$fhead = $fname;
				}
		}
	

	}
	
	
	$faqob = new getFP(); 
	$faqob->getFaqPage([$fcid]);

 

Hi   I am trying to create a google chart from data in query.php and using the google api to load it. Everything works until I want to change the MetalSourceID from a drop select box.    PHP CODE FOR DROP DOWN BOX:  

<form>
<select name="users" onchange="showUser(this.value);drawChart();">
<option value=""> Select a Metal: </option>
<?php
$query = "SELECT TOP(31) tblMetalPrice.MetalSourceID, tblMetalSource.MetalSourceName from tblMetalPrice INNER JOIN tblMetalSource ON tblMetalPrice.MetalSourceID=tblMetalSource.MetalSourceID ORDER BY tblMetalPrice.DateCreated DESC ";
$result = sqlsrv_query( $conn, $query);
while( $row = sqlsrv_fetch_object ($result)) {
echo "<option value='".$row->MetalSourceID ."'>". $row->MetalSourceName ."</option>";
}
sqlsrv_close( $conn);
?>
</select>
</form>

This works fine and generates all the correct values. One part of this changes contents of a table which works fine. But I also echo the MetalSourceID into the javascript for the google api, JS script below:  

<script type="text/javascript">
google.load('visualization', '1', {'packages':['corechart']});
google.setOnLoadCallback(drawChart);


function drawChart() {
var jsonData = $.ajax({
url: "query.php",
dataType:"json",
async: false,
data: { 'MetalSourceID' : <?php $q = intval($_GET['q']); echo $q; ?> }
}).responseText;


var data = new google.visualization.DataTable(jsonData);


var chart = new google.visualization.LineChart(document.getElementById('chart_div'));
chart.draw(data); 
}


</script>

This then runs the query.php script and returns the google line chart, a copy of the query.php script is below:  

Hello,
I need to do the following:

I have 2 forms on two different pages:
Form 1: Name, Email, Phone
Form 2: Name, Email, Phone, Address, etc.

1. User fills out Form 1, presses submit
2. Form 1 gets processed and I receive an email with the visitors Name, Email, Phone
3. After the Form has been processed I need to redirect the visitor to a new page (Form 2)
4. When Form 2 loads, fill in the form with the posted variables (Name, Email, Phone) from the previous process

Here is my code:

Form 1

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
</head>
<body>
<form method="post" action="process_form.php">
<input type="text" name="name" />
<input type="text" name="email" />
<input type="text" name="phone" />
<input type="submit" name="submit" value="submit" />
</form>
</div>
</body>
</html>


process_form.php
<?php
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];

$to = 'email@provider.com';
$subject = "Contact Form";

$message = 
"Contact Information\r\n"
."$name\r\n"
."$email\r\n"
."$phone\r\n\";

$headers = "From: $email\r\n";

mail($to, $subject, $message, $headers);

// Redirect
header("Location: http://www.domain.com/form2/");
?>


Form 2

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
</head>
<body>
<form method="post" action="process_form_2.php">
<input type="text" name="name" />
<input type="text" name="email" />
<input type="text" name="phone" />
<input type="text" name="address" />
<input type="text" name="city" />
<input type="text" name="state" />
.
.
.
<input type="submit" name="submit" value="submit" />
</form>
</div>
</body>
</html>


The form does get processed and I do get an email with the visitor's info. But I'm not able to pass on the variables from From1 to Form2.

Thank you in advance.

I'm starting to fear that this is impossible.. I will severely appreciate any kind of advice!

On site A, I have a link (an affiliate type link) that redirects to site B. When clicking the link on site A, I use this code to redirect..

header('HTTP/1.1 301 Moved Permanently');
header('Location: ' .  $url);
exit;

the $url var is just site's A URL. What I can't figure out is how to pass a variable from the redirection script onto site B without using a query string in the URL itself ( for example, http://www.siteB.com/?var_to_pass=something)

Can passing a variable between two sites be achieved with js.. or XML? I'm willing to use anything as long as I don;t have to add the variable in the URL.

Hey guys im a little stumped.

My pages has the following links.

<a href="?page=yes">Yes</a>


to Change content i use

  <?php
            if (isset($_GET['page']))
   {
      include ("include/".$_GET['page'].".php");
   }
   else
   {
      echo 'Welcome to Liquids Scripts PHP Code repository. Just select the categorie from the top and get all the info required ';
   }
   ?>


Will this be tracked by google analytics?

Any help would be awsome.

I got this code made for me to put on my google search code.

<?php

$click_value = '0.001'; //Amount in dollars that each click is worth

function increment_clicks() {
    //Get current click count
    if(file_exists('click_count.txt'))
        $clicks = file_get_contents('click_count.txt');
    else
        $clicks = 0;
   
    //Add current click to count
    $clicks++;
   
    //Save new value to file
    $file = fopen('click_count.txt', 'w');
    fwrite($file, $clicks);
    fclose($file);
}

function get_click_amount() {
    global $click_value;
   
    //Get current click count
    if(file_exists('click_count.txt'))
        $clicks = file_get_contents('click_count.txt');
    else
        $clicks = 0;
   
    //Return value of all clicks based on $click_value, formatted to 2 decimal places
    return number_format($clicks * $click_value, 3);
}

if (isset($_POST['search'])) {
    //Search button was clicked, increment count
    increment_clicks();
}

$click_amount = get_click_amount();

?>
<html>
<head>
</head>

<body>
<center>

<p id="click_amount">$<?php echo $click_amount; ?></p>
<form action="" method="POST">
    <input type="text" name="search" value="" />
    <input type="submit" value="Search" />
</form>

</center>
</body>
</html>

Now i do not know how to put it in my google code if you put it on a page by itself it works.

I do not know if i can list my google code here so if anyone can help i will pm them m google code.

THANKS

Hello Everyone,

I'm using PHP with MySQL.  One of the fields in the database is website.  The code I'm using is as follows:

variable:

$web=mysql_result($result,$i,"web");

html/php code:

<td><font face="Arial, Helvetica, sans-serif"><a href="<? echo "$web"; ?>">Website</a></font></td>

What it should do is have the clickable word Website with the correct url from the database.  Instead it's repeating the website the page is on.  For example it's doing this:

http://mywebsite/www.enteredwebsite.com

Any help is appreciated.

Hi guys,

this is the geocoding part of the code.

I ran this ion my localhost and it runs ok. Then when i uploaded it to my server i got

500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed.

When i take out the php the html code run ok... so its not that. Can anyone help?

I have taken out my key and db connection.

Im hosted on black knight if thats any help

Code: [Select]
<?php
require("config.php");

define("MAPS_HOST", "maps.google.com");
define("KEY", "****");

// Opens a connection to a MySQL server
$connection = mysql_connect("localhost", "root", "password");
if (!$connection) {
  die("Not connected : " . mysql_error());
}

// Set the active MySQL database
$db_selected = mysql_select_db("database", $connection);
if (!$db_selected) {
  die("Can\'t use db : " . mysql_error());
}

// Select all the rows in the markers table
$query = "SELECT * FROM users WHERE 1";
$result = mysql_query($query);
if (!$result) {
  die("Invalid query: " . mysql_error());
}

// Initialize delay in geocode speed
$delay = 0;
$base_url = "http://" . MAPS_HOST . "/maps/geo?output=xml" . "&key=" . KEY;

// Iterate through the rows, geocoding each address
while ($row = @mysql_fetch_assoc($result)) {
  $geocode_pending = true;

  while ($geocode_pending) {
    $address = $row["address1"];
    $id = $row["id"];
    $request_url = $base_url . "&q=" . urlencode($address);
    $xml = simplexml_load_file($request_url) or die("url not loading");

    $status = $xml->Response->Status->code;
    if (strcmp($status, "200") == 0) {
      // Successful geocode
      $geocode_pending = false;
      $coordinates = $xml->Response->Placemark->Point->coordinates;
      $coordinatesSplit = explode(",", $coordinates);
      // Format: Longitude, Latitude, Al
  itude
      $lat = $coordinatesSplit[1];
      $lng = $coordinatesSplit[0];

      $query = sprintf("UPDATE users " .
             " SET lat = '%s', lng = '%s' " .
             " WHERE id = '%s' LIMIT 1;",
             mysql_real_escape_string($lat),
             mysql_real_escape_string($lng),
             mysql_real_escape_string($id));
      $update_result = mysql_query($query);
      if (!$update_result) {
        die("Invalid query: " . mysql_error());
      }
    } else if (strcmp($status, "620") == 0) {
      // sent geocodes too fast
      $delay += 100000;
    } else {
      // failure to geocode
      $geocode_pending = false;
      echo "Address " . $address . " failed to geocoded. ";
      echo "Received status " . $status . "
\n";
    }
    usleep($delay);
  }
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title>Your Profile Page</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/1.css" type="text/css" media="screen,projection" />

</head>
 
<body>

<div id="wrapper" class="fixed">

<div id="header">

<h1>Find A Tag Team</strong></h1>

<ul id="nav">

<li><a href="home.html">Home</a></li>

<li><a href="index.html"></a>Logout</li>

<li><a href="Links.php">Links</a></li>

<li><a href="Videos.php">Videos</a></li>



</ul>

</div>

<div id="sidebar_left">

<h2>Your Profile Page</h2>

<p>


</p>

<p>

From here you can ...<br />
-Edit all your information <br />
-Search for other users <br />
-View any emails you may have recieved</br />

</p>

<p>



</p>

</div>




<div id="content">

<h1>Profile</h1>
<div class ="message"> The map has been succesfully updated. <br />
<a href = "map.php">View the Map</div>

<div id="footer">


</div>
</div>

</body>
</html>

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=356789.0

can curling my pages interfere with my adsense?