PHP - Error Using Pdo To Connect To Access Db

According to I have a project need to use PHP 5.6.40 connect to mysql version  5.7.34
This URL for phpinfo()
http://newlink.bdb.com.la/app/webroot/test.php

when I try to connect it by below coding
 

$servername = "localhost";
$username = "user";
$password = "pass";
$db_database    = 'db_unelr'; 
$db_port        = '3306';

// Create connection
$conn = mysqli_connect($servername, $username, $password,$db_database,$db_port);

// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";

 

it's show 500 internal error.
what should I check and fix this problem? it's private host, so I can run linux command to check

 

Have actually tried this mailer on localhost and it worked perfectly. Now am trying to use it on online but it's giving this error SMTP-> ERROR: Failed to connect to server: Connection timed out (110) SMTP -> ERROR: Could not connect to SMTP host. Mailer Error: SMTP Error: Could not connect to SMTP Host.   please how do i fix this?     include "classes/class.phpmailer.php"; // include the class name
$mail = new PHPMailer(); // create a new object
$mail->IsSMTP(); // enable SMTP
$mail->SMTPDebug = 1; // debugging: 1 = errors and messages, 2 = messages only
$mail->SMTPAuth = true; // authentication enabled
$mail->SMTPSecure = 'ssl'; // secure transfer enabled REQUIRED for GMail
$mail->Host = "smtp.gmail.com";
$mail->Port = 465; // or 587
$mail->IsHTML(true);
$mail->Username = "hypropsict@gmail.com";
$mail->Password = "hyprops123";
$mail->SetFrom("hypropsict@gmail.com");
$mail->Subject = "Requisition Processed";
$mail->Body = "<b>Hello $firstname, your requisition has been processed and Approved.. <br/><br/>Come to the Account department to recieve your $text . <br/> Thank You </b>";

$mail->AddAddress($email);
 if(!$mail->Send()){
    echo "Mailer Error: " . $mail->ErrorInfo;
}

Firstly I'd like to say a hello to everyone.

OK, I'm having a problem with my PHPMailer setup. My aim is to have a registration email sent to a user upon sign up from (admin@mydomain.com). I have set up my mail servers set up correctly. so I can send/recieve mail from (admin@mydomain.com).

I am using PHPMailer_v5.1, and am using the following code

Code: [Select]
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

require_once('../class.phpmailer.php');

$mail = new PHPMailer();

$body = file_get_contents('contents.html');
$body = eregi_replace("[\]",'',$body);

$mail->IsSMTP();
$mail->Host = "admin@mydomain.com";
$mail->SMTPDebug = 1;

$mail->SMTPAuth = true;
$mail->SMTPSecure = "ssl";
$mail->Host = "admin@mydomain.com";
$mail->Port = 25;
$mail->Username = "admin@mydomain.com";
$mail->Password = "*****"; 

$mail->SetFrom('admin@mydomain.com","My Domain');
$mail->AddReplyTo("admin@mydomain.com","My Domain");
$mail->Subject = "PHPMailer Test Subject via smtp, basic with authentication";
$mail->AltBody = "To view the message, please use an HTML compatible email viewer!";
$mail->MsgHTML($body);

$address = "test@test.com";
$mail->AddAddress($address, "Test");

if(!$mail->Send())
{
  echo "Mailer Error: " . $mail->ErrorInfo;
} 
else 
{
  echo "Message sent!";
}
?>
I set up a PHP document to test this mail feature, but every time I load it, it displays this

SMTP -> ERROR: Failed to connect to server: (0)
SMTP Error: Could not connect to SMTP host. Mailer Error: SMTP Error: Could not connect to SMTP host.

The PHPMailer is running on Elastiks (CentOS Linux 5.6).

I cross checked the php.ini file and  the OpenSSL is enabled.

openssl
OpenSSL support  enabled 
OpenSSL Version  OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008 

Please help me out from these issue.

Thanks for your time guys, hope someone can get back to me soon!

My dad loves these frozen cheeseburgers from meijer so I was gonna write a little script I can run in cron that will check Meijer's website and txt or email or something if they go on sale.

Whenever I run the below script I get an Access Denied response from the server instead of the html for the cheesburger page.

I'm sure I just need a CURL option or something. 

Thank You in Advance

 

function curl_download($Url){ if (!function_exists('curl_init')){ die('cURL is not installed. Install and try again.'); } $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $Url); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_VERBOSE, true); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:47.0) Gecko/20100101 Firefox/47.0"); $output = curl_exec($ch); curl_close($ch); return $output; } print curl_download("https://www.meijer.com/shop/en/frozen/frozen-meals/sandwiches/meijer-bacon-cheeseburger-4-9-oz/p/71373326278");
 

Hi All,

I am using PHP 5.3 and storing php session data to the database using session.set_save_handler callbacks. I see that the write method, strangely treats the Class constant as undefined. All the other methods seem to work fine with the class constant. Any reason why this would happen? Please see code below. I get an error "Use of undefined constant db_table in Sessions.php in line". This seems to be happening only with the write api. Can someone please help?

Thanks


class Sessions {
 //var $life_time;
 var $id;
 var $data;
 const db_table = 'php_mysql_session';
   function PHPSessions() {
      // Read the maxlifetime setting from PHP
      //$this->life_time = get_cfg_var("session.gc_maxlifetime");

      $this->id = session_id();
      $this->data = '';

      // Register this object as the session handler
      session_set_save_handler(
      array( &$this, "_open" ),
      array( &$this, "_close" ),
      array( &$this, "_read" ),
      array( &$this, "_write" ),
      array( &$this, "_destroy") ,
      array( &$this, "_gc" )
      );

   }
function _open ()
// open the session.
{
   Zend_Log::log("opening connection");
   global $_sess_db;
   Zend_Log::log("session db ".$_sess_db);
   if ($_sess_db = mysql_connect(DB_HOST_READ, DB_USER, DB_PASS)) {
      return mysql_select_db('TEST_SESSION', $_sess_db);
   }
   // If there is a failure return false
   return FALSE;

} // open


function _close ()
// close the db connection here
{
   global $_sess_db;
   return mysql_close($_sess_db);

} // close

function _read ($id)
// read any data for this session.
{

   
    global $_sess_db;
    Zend_Log::log("Session db ".$_sess_db);
   //$id = mysql_real_escape_string(session_id());
    Zend_Log::log("Session Id :" .$id);

   $sql = "SELECT * FROM ". self::db_table ."
   WHERE session_id = '$id'";
   Zend_Log::log("SQL IS : ".$sql);
 
     $data = '';
   $result = mysql_query($sql);
   $a = mysql_num_rows($result);
   Zend_Log::log("Record count ".$a);

   if($a > 0) {
      Zend_Log::log("Record Exists!");
      $row = mysql_fetch_assoc($result);
      $data = $row['session_data'];
      Zend_Log::log("Fetching session Data ".$data);
      return $data;
   }
   else
   {
      Zend_Log::log("No Data ".$data);
      return '';
   }


 
}

function _write ($id, $data)
// write session data to the database.
{
   global $_sess_db;
   
 
   $newid = mysql_real_escape_string($id);

   $newdata = mysql_real_escape_string($data);

   $sql = "REPLACE ". self::db_table ." (session_id,user_id,session_data,date_created) VALUES('$newid', '$userid', '$newdata', 'NOW()')";

   $rs = mysql_query($sql);

   return TRUE;
 

} // write

 
function _destroy ($id)
// destroy the specified session.
{
     Zend_Log::log("Destroy method ");
   return TRUE;

} // destroy

function _gc ($max_lifetime)
// perform garbage collection.
{
     Zend_Log::log("GC Method");
   return TRUE;

} // gc

function _destruct ()
// ensure session data is written out before classes are destroyed
// (see http://bugs.php.net/bug.php?id=33772 for details)
{
   @session_write_close();

} // __destruct

// ****************************************************************************
} // end class

Hi,

WHAT:

So I cannot for the life of me figure out why I'm getting this error. I'm trying to create a function that will display the user information from the database in a table but I have like a ton of these errors on the page and I don't know whats wrong.

STEPS TO RESOLVE:

So I've gone over my code a bunch of types to make sure that all the variables and what not were spelled correctly and as far as I can tell they are.

I've also googled this issue to see if I can find a solution but none of them are very helpful.

I honestly don't know whats wrong so kinda hard to find ways to resolve an issue, I don't even really know what this error means.

THE CODE:

This is where I put the function into action

 <?php
   display_table(
     array(
      "id" => "Id",
      "emailaddress" => "Email",
      "firstname" => "First Name",
      "lastname" => "Last Name",
      "salesperson" => "Salesperson",
      "phonenumber" => "Phone Number",
      "extension" => "Extension",
      "type" => "Type"
    )
  );
   ?>

//This is the function
<?php
function display_table($fields, $data, $rows, $page){
  if(isset($_GET['page'])){
    $page = $_GET['page'];
  } else {
    $page = 1;
  }
  $firstRecord = ($page - 1) * ROWS_PER_PAGE;
  $pageNumbers = ceil($rows / ROWS_PER_PAGE);

  echo '<div class="table-responsive w-75 mx-auto py-3">
  <table class="table table-dark table-bordered table-sm">
  <thead>
  <tr>';

  foreach($fields as $key){
    echo '<th class="py-2">' . $key . '</th>';
  }

  echo '</tr>
  </thead>
  </tbody>';

  $keys = array_keys($fields);

  for($record = $firstRecord; $record < $firstRecord + ROWS_PER_PAGE; $record++){
    $row = $data[$record];
    echo '<tr>';

    for($recordCount = 0; $recordCount < count($keys); $recordCount++){
      $column = $keys[$recordCount];
      echo '<td class="py-2">' . $row[$column] . '</td>';
    }

    echo '</tr>';
  }

  echo '</tbody>
  </table';

  for($pages = 1; $pages <= $pageNumbers; $pages++){
    echo '<a class="btn btn-dark mx-1" href=?page=' . $pages . '</a>';
  }
}
?>

Any help/advice would be really appreciated

Hi I am trying to send email through following php code to may gmail account but it givrs me SMTP Error: Could not connect to SMTP host. *******************************************************************************************************************************************************

<?phpif(isset($_POST['submit'])){
$message='Full Name: '.$_POST['fullname'].'<br 
/>Subject: '.$_POST['subject'].'<br 
/>Phone: '.$_POST['phone'].'<br 
/>Email: '.$_POST['emailid'].'<br 
/>Comments: '.$_POST['comments'].'';    
require "phpmailer/class.phpmailer.php"; //include phpmailer 
class         // Instantiate 
Class     $mail = new 
PHPMailer();          // 
Set up SMTP     
$mail->IsSMTP();                
// Sets up a SMTP connection     $mail->SMTPAuth = 
true;         // Connection with the 
SMTP does require authorization       
$mail->SMTPSecure = "ssl";      // Connect using a 
TLS connection     $mail->Host = 
"smtp.gmail.com";  //Gmail SMTP server address    
$mail->Port = 465;  //Gmail SMTP port    
$mail->Encoding = '7bit';       // 
Authentication     $mail->Username   = 
"myemail@gmail.com"; 
// Your full Gmail address    $mail->Password   
= "mypassword"; // Your Gmail 
password         // 
Compose    $mail->SetFrom($_POST['emailid'], 
$_POST['fullname']);    
$mail->AddReplyTo($_POST['emailid'], 
$_POST['fullname']);    $mail->Subject = "New Contact Form 
Enquiry";      // Subject (which isn't 
required)     
$mail->MsgHTML($message);     // Send 
To     $mail->AddAddress("myemail@gmail.com", 
"Recipient Name"); // Where to send it - Recipient    $result 
= $mail->Send();  // Send!  $message = $result ? 
'Successfully Sent!' : 'Sending 
Failed!';      unset($mail);
}?><html><head>  <title>Contact 
Form</title></head><body>       <div 
style="margin: 100px auto 0;width: 
300px;">   <h3>Contact 
Form</h3>   <form name="form1" id="form1" action="" 
method="post">     <fieldset>       
<input type="text" name="fullname" placeholder="Full Name" 
/>       <br 
/>       <input type="text" 
name="subject" placeholder="Subject" 
/>       <br 
/>       <input type="text" name="phone" 
placeholder="Phone" />       <br 
/>       <input type="text" 
name="emailid" placeholder="Email" />       
<br />       <textarea rows="4" 
cols="20" name="comments" 
placeholder="Comments"></textarea>       
<br />       <input type="submit" 
name="submit" value="Send" 
/>     </fieldset>   </form>   <p><?php 
if(!empty($message)) echo $message; 
?></p>  </div>     </body></html>

I have mysqli object in Database class base:

[color=]database class:[/color]

class Database {
  private $dbLink = null;
  
  public function __construct() {
    if (is_null($this->dbLink)) {
      // load db information  to connect
      $init_array = parse_ini_file("../init.ini.inc", true);
      $this->dbLink = new mysqli($init_array['database']['host'],
                           $init_array['database']['usr'],
                           $init_array['database']['pwd'],
                           $init_array['database']['db']);
  
      if (mysqli_connect_errno()) {
        $this->dbLink = null;
      }
    }
  }

  public function __destruct() {
    $this->dbLink->close();
  }
}


Class derived is Articles where I use object dBLink in base (or parent) class and I can't access to mysqli methods (dbLink member of base class):

Articles class:

require_once ('./includes/db.inc');

class Articles extends Database{
  private $id,
              ....
              ....
             $visible = null;
  
  public function __construct() {
    // Set date as 2009-07-08 07:35:00
    $this->lastUpdDate = date('Y-m-d H:i:s');
    $this->creationDate = date('Y-m-d H:i:s');
  }
  
  // Setter
  ....
  ....

  // Getter
  ....
  ....

  public function getArticlesByPosition($numArticles) {
    if ($result = $this->dbLink->query('SELECT * FROM articles ORDER BY position LIMIT '.$numArticles)) {
      $i = 0;
      while ($ret = $result->fetch_array(MYSQLI_ASSOC)) {
        $arts[$i] = $ret;
      }
      $result->close();
      return $arts;
    }
  }
}


In my front page php I use article class:


include_once('./includes/articles.inc');
$articlesObj = new articles();
$articles = $articlesObj->getArticlesByPosition(1);
var_dump($articles);


[color=]Error that go out is follow[/color]

Notice: Undefined property: Articles::$dbLink in articles.inc  on line 89

Fatal error: Call to a member function query() on a non-object in articles.inc on line 89

If I remove constructor on derived class Articles result don't change 
Please help me

Trying to run a simple program that, when submitted, stores the username and password as cookies.  When clicking Submit, I get the error  "HTTP Error 405 - The HTTP verb used to access this page is not allowed". If the username and password fields are left blank when submitting it's suppose to give a message to enter a username and password, but, I still get that error message.

HTML form:

Code: [Select]

<!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" xml:lang="en" lang="en">
<head>
<title>Week 1 Project--Cookies</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />


</head>

<body>
<form action="cookie1.php" method="post">
<h2 align="center">Cookies</h2>

<br />
<div>
<p>Enter your username and password and click "Submit":</p><br />
<p>Username:<input type="text" name="username" size="20"></p>
<p>Password:<input type="text" name="password" size="20"></p>
</div>
<br />
<div><input type="submit" name="submit" value="Submit" /></div>
<br />
<div>
<input type="reset" name="Reset" value="Start Over" />
</div>

</form>



</body>
</html>


PHP file:

Code: [Select]

<!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" xml:lang="en" lang="en">
<head>
<title>Cookie File</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>

<body>
<div>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
 setcookie('username', $_POST['username'], time() + 2592000);
 setcookie('password', $_POST['password'], time() + 2592000);
}
if(($_POST['username'] == "") || ($_POST['password'] == "")) {
print "You must enter both a username and password. Press the Back button on your browser and try again.";
}
else if (isset($_COOKIE['username'])) {
print "Welcome, " .$_COOKIE['username'];
}
?>
</div>
</body>
</html>

define("DB_HOST", "localhost");

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.

Hi People.

Thanks to everyone that helped me yesterday with my file that finally connected to the database.

However, I have added a new field to my DB and now get further problems. 

Here is the error message I am getting after I added the "ppr" stuff to both files.

Please could someone look at my code and tell me where I'm going wrong.
Code: [Select]
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>

<body>
<?php include "config01.php"?>

<form name = 'form1' method = 'post' action='config01.php'>
<table width="700" border="1" cellspacing="5" cellpadding="5">
  <caption>
    Submit Your Airfield Details
  </caption>
  <tr>
    <td width="100">&nbsp;</td>
    <td width="200">Your Name</td>
    <td width="200"><input type='text' name='username' maxlength='30'></td>
    <td width="100">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Height Above MSL</td>
    <td><input type='text' name='height_above'maxlength= '30'></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Mb Difference</td>
    <td><input type='text' name='mb_diff'maxlength='40'></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>Alternative Airfield</td>
    <td><input type='text' name='alternative' maxlength='30'></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>PPR</td>
    <td><input type='radio' name='ppr' value="Y"/>
    Yes
      <input type='radio' name='ppr' value="N" />
      No</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><input type='submit' name='submit' value='post' /></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
</form>


</body>
</html>
Then the code from config01.php
Code: [Select]
<?php
$host = 'localhost';
$usr = "VinnyG";
$password = 'thepassword';
$db_name = 'sitename';

$username = $_POST["username"];
$height_above = $_POST["height_above"];
$mb_diff = $_POST["mb_diff"];
$alternative = $_POST["alternative"];
$ppr = $_POST["ppr"];

//connect to database
mysql_connect ("$host","$usr","$password") or die ('Error During Connect:<br>'.mysql_error());
mysql_select_db ("$db_name") or die ('Error Selecting DB:<br>'.mysql_error());

/*
$sql01 = "INSERT INTO users SET username = '$username',height_above = '$height_above', mb_diff = $mb_diff, alternative = $alternative";
$result=mysql_query($sql01);
*/
//mysql_query("INSERT INTO users VALUES ('$username','$height_above','$mb_diff','$alternative')");
//mysql_query("INSERT INTO users (username, height_above, mb_diff, alternative) VALUES ('$username', '$height_above', '$mb_diff', '$alternative'"); 
//$insert_query = "INSERT INTO users (username, height_above, mb_diff, alternative) VALUES ('$username', '$height_above', '$mb_diff', '$alternative')";
//$insert_action = mysql_query($insert_query) or die ('Error Dring Insert :<br>'.mysql_error().'<br><br>Error occured running the following code :<br>'.$insert_query);

//mysql_query("INSERT INTO users VALUES ('$username','$height_above','$mb_diff','$alternative')"); CHANGES FOLLOW THIS LINE . . 
$query = "INSERT INTO users (username, height_above, mb_diff, alternative, ppr) VALUES ('$username', '$height_above', '$mb_diff', '$alternative', '$ppr'";
if( !$result = mysql_query($query) ) {
     echo "<br>Query: $query<br>Produced error: " . mysql_error() .'<br>';
} else {
     echo "Query ran and inserted " . mysql_affected_rows() . "row(s).";
}
?>
I only added the one thing and I've gone and broken it already.  It was working last night too.. :-(

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.

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

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