PHP - Moved: Facebook Connect

This topic has been moved to Other Libraries and Frameworks.

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

This topic has been moved to PHP Applications.

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

This topic has been moved to Other Libraries and Frameworks.

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

This topic has been moved to Third Party PHP Scripts.

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

This topic has been moved to Other Libraries and Frameworks.

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

This topic has been moved to Other Libraries and Frameworks.

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

This topic has been moved to PHP Freelancing.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

define("DB_HOST", "localhost");

hello, if i have an entry in a table called company on database cc, would the following be the propper code?  im getting a blank page.

Code: [Select]
<?php

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'mike';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to 

mysql');

$dbname = 'cc';
mysql_select_db($dbname);



$query  = "SELECT * FROM company";
$result = mysql_query($query);


while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    echo "Name :{$row['compant']} <br>" .
         "Subject : {$row['address']} <br>" . 

} 


?>

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

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.

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]);

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