PHP - Google Friend Connect

Right ive got a user profile that i want a add friend button but i coded a little something what i fort wud work but no luck
<?php
session_start();
include "includes/db_connect.php";
include "includes/functions.php";
include"includes/smile.php";
logincheck();
$username=$_SESSION['username'];
$viewuser=$_GET['viewuser'];

$fetch=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$viewuser'"));
if (!$fetch){
echo "No such user";


$totalf = mysql_num_rows(mysql_query("SELECT * FROM friends WHERE username = '$viewuser' AND active='1'"));

$invite_text="<div>$username Has Sent You A Friend Request<br>
<input name=Yes_Accept type=submit id=yes value=Accept Invite class=abutton>&nbsp;<input name=No_accept type=submit value=Decline Invite class=abutton></div><input type=hidden name=invite_id value=$bar2>";
if (($_GET['fri'])){
$exicst=mysql_query("SELECT * FROM users WHERE username='$viewuser'");
$nums=mysql_num_rows($exicst);
$adding=mysql_fetch_object($exicst);
$already=mysql_num_rows(mysql_query("SELECT * FROM friends WHERE type='Friend' AND person='$viewuser' AND username='$username'"));
if ($already != "0"){
echo "<center><font color=orange><b><br>This user is already your friend.<br><br></font>";
}elseif ($already == "0"){


mysql_query("INSERT INTO `friends` ( `id` , `username` , `person` , `type` , `active`) 
VALUES (
'', '$username', '$viewuser', 'Friend' , '0'
)");
mysql_query("INSERT INTO `friends` ( `id` , `username` , `person` , `type` , `active`) 
VALUES (
'', '$viewuser', '$username', 'Friend' , '0'
)");
mysql_query("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `subject` , `date` , `read`) 
VALUES (
'', '$viewuser', '$username', '$invite_text' , 'Friend Request' , '$date' , '0'
)");
$bar2=mysql_insert_id();
echo "<center><font color=orange><br>Your Friend Invitation Was Sent To $viewuser<br><br></font>";
exit();
}
}}
?>
<a href=?fri=Yes>Add Friend +</a>

It just adds a blank person and comes back with No Such User and Your Friend Invitation Was Sent To

I think ive put some things in the wrong place to be honest but as im not a pro i easily miss things

Right i want to have friends displayed on peoples profiles but i can only ave there name and not the avater displayed here is the code ive got which doesnt work

        <? 
$picture = mysql_query("SELECT * FROM users WHERE username = '$dip->person'");
$pc = mysql_fetch_object($picture);
$query_friends=mysql_query("SELECT * FROM friends WHERE username='$viewuser' AND type='Friend'");

$rows=mysql_num_rows($query_friends);
if ($rows == "0"){ echo "<center>No friends</center>"; }
$friend = 0;
while($dip=mysql_fetch_object($query_friends)){

echo "&nbsp;&nbsp;<img src='$pc->image' width='50' height='50' border='1'><br><a href='profile.php?viewuser=$dip->person'>$dip->person</a>,"; 
$friend++; 
echo ($friend % 3 == 0)? "<br>" : ""; }
?>


The friends are from the friends database and the avater is from the users database how can i link them so the name and the avater show ive tried this but only the names are displayed and the avaters dont show

Need some help here!

I want to build a friendgroup - I have a full working friendsystem.

My ide is this. I got a list of friends, make a group named Test. Put selected friends in there, make another group and put another friends in there.

Some idees how to do that with prepared statements??

I search for tutorials, but couldn't find any. Any suggestions?

The functions I need is this:

1. Make group
2. Add friend to group
3. Show group with selected friends
4. Rename groups
5. Move friend from one group to another
6. Delete group with all friends inside
7. Delete a empty group
8. Option to search for friends inside a group

Tutorial, free source code - everything would help to solve this mystery !

So far is this the code I made, and didn't work at all

public function create_friendgroup($profileownerid, $friends = NULL, $name)
{

   $sql = "SELECT fg_friends_id FROM friend_groups WHERE fg_member_id = '$profileownerid' LIMIT 1";

      if($stmt = $this->conn->prepare($sql))
      {
         $stmt->execute();
         $stmt->bind_result($friend);
         $stmt->fetch();
         $stmt->close();

      }

   if($friend != null)
      {
         $ua = explode(",", $friend);
         $ua = array_unique($ua);

         foreach ($ua as $u)
         {
         if($u !=NULL && $u !=$profileownerid)
         {
         $oldusers .= "{$u},";
      }   }
   }

$newusers = $profileownerid;
      if ($oldusers != null)
         {
         $newusers .= "," . $oldusers;
         }

$sql = "INSERT INTO friend_groups(fg_member_id,fg_friends_id, fg_name, fg_created_date) VALUES (?,?,?,?)";

$date = date("d-m-Y H:i");
      
      if($stmt = $this->conn->prepare($sql))
      {
         $stmt->bind_param('iiss',$profileownerid,$friends = trim($newusers, ","), $name,$date);
         $stmt->execute();
         $stmt->close();
      }
}







K.F

Im working on a "Friend-request"-script, but something is wrong in my "answer"-script...

See the script below:

Code: [Select]
    if (isset($_POST['submit_ansReq_answer'])) {
   
        $answer = $_POST['ansReq_what'];
        $uid= $_SESSION['userid'];
        $fid= $_POST['fid'];
       
       
        $db=friend_db;
        $dbname=bannaky_basic;
        include('config.php');
       
       
        ///////////// IF ACCEPTED
       
        if ($answer == "acceptReq") {
       
        $reqStat = "YES";
        $reqEcho = "Answered YES";
       
        }
   
        ///////////// ELSE IF DENIED
   
        else if ($answer == "denyReq") {
       
        $reqStat = "NO";
        $reqEcho = "Answered NO";
       
        }
       
        $query = "UPDATE $db SET req_accept='$reqStat' WHERE friend_id='$uid' AND user_id='$fid'";
           
            mysql_query($query);
           
           
            echo "$reqEcho";

If the user hits the Accept-button, everything works fine and is registered in the SQL database. But when hitting the Deny-button nothing happens... I get to the page and $regEcho works, but $reqStat=NO; wont save in the SQL database...

Probably a simple solution to this that im not seeing.... Please help me out before i loose my mind.

define("DB_HOST", "localhost");

Hello there,
I'm using a Mac (10.5. and installed MAMP for PHP and MYSQL
I trying to build a blog. I just setup a database in phpmyadmin.

I created a php and start coding, everything works just fine, but when
I tried to connect to the mysql it gives me a blank page

I inserted this code
Code: [Select]
<?php
session_start();

    $connect = mysql_connect('localhost','root', 'root'); or die(mysql_error());
$db = mysql_select_db('blog',$connect);
$session_name = $_SESSION['uid'];


?>
but then the whole page turns to be blank page , but when I excluded this, it works just fine. I don't get it cause my database/phpmyadmin connected just fine.

Any help is much appreciated. Been trying to figure this out for hours.

Hi,

I have a script which uses a connect file but I am struggling to get files in other folders to read and for the "$loggedIn = checkLogin();" code to work.

If I connect to the database within the same script it works straight away.

If I change my password then I have to change every file but otherwise I cannot include the connect file as I have to link to it locally.

So if the connect file is in:

www.domain.co.uk/php/login/connect.php

then

www.domain.co.uk/php/login/index.php -- this works

www.domain.co.uk/php/logout.php -- this doesn't regardless of how I link to the connect file.

Ok this code doesn't look wrong but i cant figure out whats going on?
Code: (connect.php) [Select]
<?php
//connect.php
$server = 'localhost';
$username = 'admin';
$password = 'pass';
$database = 'gms';
 
if(!mysql_connect($server, $username,  $password))
{
  exit('Error: could not establish database connection');
}
if(!mysql_select_db($database)
{
  exit('Error: could not select the database');
}
?>


ERROR
Code: [Select]
Parse error: syntax error, unexpected '{' in /home/adee67/public_html/forum/connect.php on line 13

I'm trying to add Facebook connect to my new app, but I'm not sure where to really start.  I looked through a lot of the facebook documentation, but I haven't been able to find any really good implementation suggestions.  I just want basic functionality.

Hey,

I've had this problem for a couple days now, and haven't been able to work it out.

I'm trying to connect to the Gamesurge IRC using PHP - though the code I am using times out and can't connect.

I thought it was my code, however I have searched the web for working codes and they all *seem* to do the same basic thing as mine.

So if anyone has any ideas as to why I am getting a timeout, I would appreciate it.

The code I'm using.

<?php
 
error_reporting(E_ERROR);
 
$cfg = array(
        "server" => "irc.gamesurge.net",
        "channel" => "#wiremod",
        "port" => 6667,
        "name" => "thetree PHP"
);
 
echo "Connecting to " . $cfg["server"] . " on port " . $cfg["port"] . "<br/>";
$socket = fsockopen($cfg["server"], $cfg["port"], $errno, $errstr, 5);
 
if (!$socket) {
        echo("Error[$errno]: $errstr...<br/>");
}
else {
        echo "Socket connection successful..<br/>";
}
 
fclose($socket);
 
?>


Hosted file:

http://joethetree.lil.org.uk/socket.php



Thanks

thetree

I have a simple form and I run my script without any errors. I click my btn and I would like to see my echo errors but no errors show up when I have no value in textboxes. I have tried if(isset($_Post["submit"])) and if($_SERVER["REQUEST_METHOD"] == "post") What I think is nether of there ifs are becoming valid on my btn click.

<?php
$nameerror = $twoerror = $errormsg = "";
// PHP Procedural MYSQLi
// connect to mysql database with phpmyadmin
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "test";

$connection = new mysqli($servername, $username, $password, $dbname);
//if(isset($_Post["submit"]))
if($_SERVER["REQUEST_METHOD"] == "post")
{
    if(empty(trim($_Post["name"]))) {
        $nameerror = "Name is required";
    }
    else {
        $namesafe = mysqli_real_escape_string($connection, $_Post["name"]);
    }
    if(empty(trim($_Post["two"]))) {
        $twoerror = "Two is required";
    }
    else {
        $twosafe = mysqli_real_escape_string($connection, $_Post["two"]);
    }

    if($namesafe != "" && $twosafe != "") {
        $sqlInsert = "INSERT INTO tester(name, two) " .
          "VALUES('". $namesafe ."','". $twosafe ."')";

          if(mysqli_query($connection, $sqlInsert)) {
              echo "Successfully entered.";
          } else {
              echo "NOT successful error: " . $sqlInsert . "<br>" . mysqli_error($connection);
          }
    } 
}
mysqli_close($connection);
?>
<?php

      if(!$connection) {
        die("Connection Failed! " . mysqli_connect_error());
      }
      echo "Connected Successfully@!";



   ?>
    <section class="text-align" id="section-content">
        <div id="alertMessages" class="container rounded"></div>
        <div id="contentdiv" class="container rounded">
            <form id="formtest" class="rounded" method="post" >
              <!-- action="" -->
                <h3>PHP Create</h3>
                <?php
                    if(isset($errormsg)) {
                    //  echo "<div><span>";
                      echo $errormsg;
                    //  echo "</span></div>";
                    }
                 ?>
                <div>
                    <div class="form-group">
                        <input type="text" class="form-control" id="txtName" name="name" />
                        <label for="txtName">Name </label>
                        <?php if(isset($nameerror)) { echo '<span class="error">' . $nameerror . '</span>'; } ?>
                        <!-- ? php//if(isset($_Post["name"])) echo htmlspecialchars($_Post["name"]); ? >" /> --->
                        <!-- <span class="error"><?php //echo $nameerror; ?></span> -->
                    </div>
                    <div>
                        <input type="text" class="form-control" id="txttwo" name="two" />
                        <label for="txttwo">Text Two </label>
                        <?php if(isset($twoerror)) { echo '<span class="error">' . $twoerror . '</span>'; } ?>
                    </div>
                </div>
                <button type="submit" class="btn btn-lg btn-primary btn-block" name="submit">Click</button>
            </form>
        </div>
    </section>

 

hey
I need this to connect to my database on my sybase sql server, but no matter what i try, it won't populate the plunum field. Any help would be appreciated. 

 Here is my HTML code:

Code: [Select]
<html>
<head>
    <title>helloscan</title>
          <meta http-equiv="refresh" content="18">       
          <meta http-equiv="scanner" content="javascript:doScan('%s');"/>
          <meta http-equiv="scanner" content="start"/>
          <META HTTP-Equiv="scanner" Content="enabled" />
          <META HTTP-Equiv="scanner" Content="AutoEnter:Enabled"/>
          <meta http-equiv="keycapture" content="accelerate:all" />
          <meta http-equiv="keycapture" content="keyvalue:0x0D; dispatch=true; keyevent:url('javascript:mykeypressed();')" />         
          <meta http-equiv="quitbutton" content="visibility: visible;"/>       
    <script language="javascript" type="text/javascript">
      function doScan(data){
          var divEl = ("%s");       
      }
      function enablescanner(enable){
         Generic.InvokeMetaFunction('scanner', 'start');
         Generic.InvokeMetaFunction('scanner', 'enabled');
         Generic.InvokeMetaFunction('scanner', 'autoenter:enabled');
      }
      </script>
      <script>
      function get_plunum(){
         xmlhttp=ajaxfunction();
         if (xmlhttp==null) {
            alert ("no ajax support");
            return;
         }
         var ae_xrefnum = document.getelementbyid('ae_xrefnum').value;
         var ae_plunum = document.getelementbyid('ae_plunum').value;
         var querystring = "?ae_xrefnum=" + xrefnum + "&ae_plunum="+ plunum";
         xmlhttp.onreadystatechange = function (){
            if (xmlhttp.readystate == 4 || xmlhttp.readystate=="comlete"){
                   document.myform.ae_plunum.value = xmlHttp.responseText;
         }
      }
      xmlhttp.open("GET", "helloscan2.php"+querystring, true);
      xmlhttp.send(null);
      }
      function ajaxfunction(){
        var xmlhttp=null;
        try {// code for IE7+, Firefox, Chrome, Opera, Safari
           xmlhttp=new XMLHttpRequest();
        }
        catch (err) {// code for IE6, IE5
           xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
        }
        return xmlhttp;
      }           
     </script>
</head>
<body  onload="enablescanner(true)">
    <h3 align="center"><center><img src="ac moore" /></center>Please scan a barcode...</h3>
    <form  name="myform">
    ItemBarcode:
    <input type="text" id="ae_xrefnum" name="ae_xrefnum" itembarcode="divE1" oninput="get_plunum()" />
    plunum:
    <input type="text" id="ae_plunum" name"ae_plunum" oninput="get_price()"/>
    </form>
    <script language=javascript>
        {
          document.myform.ae_xrefnum.focus();
        }
    </script>
</body>
</html>
And Here is my PHP code:

Code: [Select]
<?php
//================================================================

  // Configure connection parameters
  $db_host        = "97.0.40.244, 1498";
  $db_server_name = "ACMSQL036A";
  $db_name        = "backoff.db";
  $db_file        = 'd:\trvbkup\DB';
  $db_conn_name   = "php_script";
  $db_user        = "dba";
  $db_pass        = "sql";

//================================================================
  $connect_string = "Driver={Adaptive Server Anywhere 8.0};".
                    "CommLinks=tcpip(Host=$db_host);".
                    "ServerName=$db_server_name;".
                    "DatabaseName=$db_name;".
                    "DatabaseFile=$db_file;".
                    "ConnectionName=$db_conn_name;".
                    "uid=$db_user;pwd=$db_pass";

  // Connect to DB
  $conn = odbc_connect($connect_string,'','');

  // Query
  $qry = "SELECT xrefnum, plunum FROM DBA.PLU_Cross_Ref where xrefnum = '$xrefnum'";

  // Get Result
  $result = odbc_exec($conn,$qry);

  // Get Data From Result
  while ($row[] = odbc_fetch_array($result));

  // Free Result
  odbc_free_result($result);

  // Close Connection
  odbc_close($conn);

  // Show data
  print_r($row[plunum]);

//================================================================
?>

hi all

First of all

My client have dot net server on windows OS. They want to display some pages which are created by php. Is there any possibility to display like this.

And

How can i connect sql server using php on remote to retrieve data.

Can any one tell me how can i do this.

Thanks in advance

Hello all,
This is my first post in here, so go easy.
I recently transferred my account from my local ISP to GoDaddy. And now my search criteria is not working. I am getting the follow error message on the page of my search box, instead of the graphics itself:
Could not connect to MySQL:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I thought maybe this would be a simple error when I found out that GoDaddy does not use the "localhost" connect string. So I switched it to the local IP for GoDaddy still to no avail. I am lost after that. My PHP skills are limited. I was taught by a very advanced user who uses shortcuts and different strings self made for his ease. So looking online for solutions for the script was very hard(to me at least), because the lines of code do not match common scripts online.

Is this a simple solution?
Does the:

global $dbc;
@dbConnect();

function work with GoDaddy? Because I have seen maybe different ways to connect to a DB with PHP.
Here's the script I am using to connect and extract results from the DB. Any and all help will be greatly appreciated. Thanks in advance.

Using MySQL Version 4:


<?
@require("searchheader.php");

?>
<table cellpadding=10 cellspacing=0 border=0>
    <tr>
        <td align=left valign=top>
<?

displayMenu();

?>
</td>
        <td align=right valign=bottom>
<?

if($_GET["f_catid"]){

    $num_cats = 5;
    for($i=1;$i<=$num_cats;$i++){
        $where .= " or c".$i." = ".$_GET["f_catid"];

    }
    $where = substr($where,4,strlen($where));

    $sql = "select * from product where ".$where." order by product_name ASC LIMIT 0,20";
    dbConnect();
    $result = mysql_query($sql,$dbc);

    ?>
    <div class="search_results_menu">
            <form action="[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]<?=$r["part_number"]?>&linecode=<?=$row["
            manufacturer"] ?>" method="GET"><input type="text" name="quantity" size="2" value="0" style="text-align: center;"><input type="button" name="submit_top" value="Check Out">
            </form>
            
    <table class="search_results_found" bgcolor="#efefef" cellpadding=3 cellspacing=0 border=1 bordercolor="#000000" style="border:1px solid #000000;">
        <tr bgcolor="#efefef">
                <td class="search_results_title"><b>Manufacturer</b></td>
                <td class="search_results_title"><b>Part Number</b></td>
                <td class="search_results_title"><b>Part Name</b></td>
                <td class="search_results_title"><b>Price</b></td>
                <td class="search_results_title"><b>Image</b></td>
                <td class="search_results_title"><b>Add to Cart</b></td>
        </tr>
    <?
    if(mysql_num_rows($result) > 0){
        while($row = mysql_fetch_assoc($result)){
            ?>
            <tr bgcolor="#efefef">
                <td><?=$row["manufacturer"]?></td>
                <td><a href="[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]<?=$row["part_number"]?>&linecode=<?=$row["manufacturer"]?>"><?=$row["part_number"]?></a></td>
                <td><?=$row["product_name"]?></td>
                <td>$<?=$row["price"]?></td>
                <td><a href="[url=http://www.wlpsr.com/images/]http://www.wlpsr.com/images/[/url]"<?=$row["part_number"]?>".jpg " onClick="window.open('/images/<?=$row["part_number"]?>.jpg', '<?=$row["part_number"]?>', 'toolbar=yes, directories=no, location=no, status=yes, menubar=no, resizable=yes, scrollbars=yes, height=300, width=400'); return false">View</a></td>
                <td><form action="[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]<?=$r["part_number"]?>&linecode=<?=$row["manufacturer"] ?>" method="GET"><input type="text" name="quantity" size="2" value="0" style="text-align:center;">
                    </form>
                </td>
            </tr>
            <?
            }
        }
    else{
        ?>
        <tr>
            <td colspan=100 align="center"><b>No products in this category.</b></td>
        </tr>
    </table>
            <form action="[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]<?=$r["part_number"]?>&linecode=<?=$row["
            manufacturer"] ?>" method="GET"><input type="text" name="quantity" size="2" value="0" style="text-align: center;"><input type="button" name="submit_top" value="Check Out">
            </form>
            </td>
        </tr>
        <?
        }
    ?>
</td>
</tr>
</table>
</div>
    <?

    }

?>

        <div class="form">
        <form name="search" action="<? echo $_SERVER['PHP_SELF']; ?>" method="GET">
        <input type="text" name="f_keywords" size="17" value="" maxlength="100">
        <input type="image" src="gobutton.gif">
        </form>
        </select>
        <br><br><br>
<?

$trimmed = trim(strip_tags($_GET["f_keywords"]));

 //Set the database access information as constants.
if(strlen($trimmed) > 0){
    define ('DB_USER', 'USERNAME');
    define ('DB_PASSWORD', 'THEPASSWORD');
    define ('DB_HOST', 'LOCALIP');
    define ('DB_NAME', 'DBNAME');
    define ('DB_TABLE', 'TABLE');

    //Make the connection to the DB

    global $dbc;
    @dbConnect();

$query = "SELECT * FROM product WHERE manufacturer LIKE '%$trimmed%' OR part_number LIKE '%$trimmed%' OR price LIKE '%$trimmed%' OR product_name LIKE '%$trimmed%' order by manufacturer";

$result = mysql_query($query);
$count = mysql_numrows($result);

if ($trimmed == "")
{
echo "Please enter a search criteria...";
exit;
}

// check for a search parameter
if (!isset($result))
{
    echo "<p>Please enter a search parameter!</p>";
    exit;
    }

$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);

if ($numrows == 0)
{
echo "<h4>Results</h4>";
echo "<p>We are sorry <b>$trimmed</b>  has returned zero results.</p></font>";
}

// next determine if s has been passed to script, if not use 0
if (empty($s))
{
$s=0;
}

// get results
$result =  mysql_query($query,$dbc);

if($numrows < 1){ $return= "results";}
else{ $return = "result"; }
if($numrows > 1){ $return = "results";}
else{ $return = "result"; }



// display what the person searched for
echo "Your search for ", " <b>$trimmed</b>  ", " found <br><b>$numrows $return.</b>";

// begin to show results set
$count = 1 + $s ;

}
if(strlen($trimmed) > 0){
?>
</div>
    <div class="search_results">
    <table cellpadding=0 cellspacing=0 border=0>
        <tr>
            <td align="right">
            <form action="[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]<?=$r["part_number"]?>&linecode=<?=$row["
            manufacturer"] ?>" method="GET"><input type="text" name="quantity" size="2" value="0" style="text-align:
            center;"><input type="button" name="submit_top" value="Check Out">
            </td>
        </tr>
        <tr>
        <td>
    <table class="search_results_found" bgcolor="#efefef" cellpadding=3 cellspacing=0 border=1 bordercolor="#000000" style="border:1px solid #000000;">
        <tr>
            <td width="100" class="search_results_title" align="center">&nbsp;Manufacturer&nbsp;</td><td width="70"
        class="search_results_title" align="center">&nbsp;Part&nbsp;Num.&nbsp;</td><td width="115" class="
        search_results_title" align="center">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Description&nbsp;</td><td width="60" class="search_results_title" align="center">Price</td><td width="45" class="
        search_results_title" align="center">&nbsp;Image&nbsp;</td><td width="105" align="center"><b>Add to Cart</b>
            </td>
        </tr>
        </td>
        </tr>

<?

 while ($r= mysql_fetch_array($result))

{
$manufacturer = $r["manufacturer"];
$part_number = $r["part_number"];
$product_name = $r["product_name"];
$price = $r["price"];

$count++;
echo "<tr><td>$manufacturer</td><td>";
echo "<a href=\"[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]".$r["part_number"]."&linecode=".$r["manufacturer"]."\">".$r["part_number"]."</a></td><td>";
echo "$product_name</td><td>";
echo "$ $price</td><td>";
echo "<a href=\"[url=http://www.wlpsr.com/images/]http://www.wlpsr.com/images/[/url]".$r["part_number"].".jpg \" onClick=\"window.open('/images/".$r["part_number"].".jpg', '".$r["part_number"]."', 'toolbar=yes, directories=no, location=no, status=yes, menubar=no,  resizable=yes, scrollbars=yes, height=300, width=400'); return false  \">View</a></td><td>";
echo "<form action=\"[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]".$r["part_number"]."&linecode=".$r["manufacturer"]."\" method=\"GET\"><input type=\"text\" name=\"quantity\" size=\"2\" value=\"0\" style=\"text-align:center;\"></td></tr>";

}

?>
        </table>
        <tr>
            <td align="right">
            <form action="[url=http://www.nexpart.com/extpart.php?part=]http://www.nexpart.com/extpart.php?part=[/url]<?=$r["part_number"]?>&linecode=<?=$row["
            manufacturer"] ?>" method="GET"><input type="text" name="quantity" size="2" value="0" style="text-align:
            center;"><input type="button" name="submit_bottom" value="Check Out">
            </td>
        </tr>
<?
}
?>
    </table>
    <br><br>
    </div>
<?
@require("footer3.php");
?>


Mod edit: [code] . . . [/code] tags added.

for some reason my database will not connect, here's the code:
Code: [Select]

<?php
require("mstr_ref2.php");

function parseToXML($htmlStr)
{
$xmlStr=str_replace('<','&lt;',$htmlStr);
$xmlStr=str_replace('>','&gt;',$xmlStr);
$xmlStr=str_replace('"','&quot;',$xmlStr);
$xmlStr=str_replace("'",'&#38;#39;',$xmlStr);
$xmlStr=str_replace("&",'&amp;',$xmlStr);
return $xmlStr;
}

// Opens a connection to a MySQL server
$connection=mysql_connect (localhost, $username, $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 markers WHERE 1";
$result = mysql_query($query);
if (!$result) {
  die('Invalid query: ' . mysql_error());
}

header("Content-type: text/xml");

// Start XML file, echo parent node
echo '<markers>';

// Iterate through the rows, printing XML nodes for each
while ($row = @mysql_fetch_assoc($result)){
  // ADD TO XML DOCUMENT NODE
  echo '<marker ';
  echo 'name="' . parseToXML($row['name']) . '" ';
  echo 'address="' . parseToXML($row['address']) . '" ';
  echo 'lat="' . $row['lat'] . '" ';
  echo 'lng="' . $row['lng'] . '" ';
  echo 'type="' . $row['type'] . '" ';
  echo '/>';
}

// End XML file
echo '</markers>';

?>

I think there is something wrong with this line of code. Where it says 'locat host' im not too sure about that because im not connecting to a local host, so what can i put in there instead?i think that is the problem.
Code: [Select]
$connection=mysql_connect (localhost, $username, $password);

This is the error I get:
Code: [Select]
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a2221438'@'localhost' (using password: NO) in /home/a2221438/public_html/map.php on line 44