PHP - Two Infinite While Loops, Not Sure How To Connect Them?

My code:

Code: [Select]
$rank =  implode(',', $ibforums->input['rank']);
echo $rank;
For that form, it will show:

'2,0,0'


Problem is, I need to update each row with each individual value, and is this possible with using  1 query?

Hi everyone !
I am stuck on a task which I'm sure has been achieved by several others in the past.
I need to create a category table with unlimited / infinite levels (depths) of categories, sub-categories, sub-sub-categories, sub-sub-sub-categories and so on.
I need to know how to show the category tree through PHP.
An example would be great or even a link to another page where someone has laid out a step-by-step tutorial.

Please help!

Thank you very much!

Kind Regards,
Xeirus.

define("DB_HOST", "localhost");

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

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'm running the next script from my local host and the production server, and Im getting different outputs. Anyone knows why am I getting that error from my localhost?

    <?php
    $host = 'ssl://mail.companyname.org';
    $port = 993;
    $error = 0;
    $errorString = "";
    
    var_dump(fsockopen($host, $port, $error, $errorString, 30));
    var_dump($errorString);
    var_dump($error);

Local host output:

> PHP Warning:  fsockopen(): SSL operation failed with code 1. OpenSSL
> Error messages: error:1416F086:SSL
> routines:tls_process_server_certificate:certificate verify failed in
> /tmp/test.php on line 7 PHP Warning:  fsockopen(): Failed to enable
> crypto in /tmp/test.php on line 7 PHP Warning:  fsockopen(): unable to
> connect to ssl://mail.twmdata.org:993 (Unknown error) in /tmp/test.php
> on line 7 bool(false) string(0) "" int(0)

Production server output:

resource(4) of type (stream)

 

 

 

Edited November 26, 2020 by tirengarfio

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>" . 

} 


?>

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.

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

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

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.

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 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.. :-(

I'm trying to connect to two databases and I'm having problems with the following code.  I googled to come up with this but can't figure out the errors I'm getting.
Code: [Select]
$connection="localhost";
$username="user";
$password="password";
$database1="dbone";
$database2="dbtwo";

$db1 = mysql_connect($connection,$username,$password) or die(mysql_error());
$sel1 = mysql_select_db($database1, $db1);

$query1 = "SELECT * FROM TBLUSERS";
$result1 = mysql_query($query1, $db1);
while($nt1 = mysql_fetch_array($result1, $db1))
{

}

$db2 = mysql_connect($connection,$username,$password) or die(mysql_error());
$sel2 = mysql_select_db($database2, $db2);
$query2 = "SELECT * FROM TBLPD20101101";
$result2 = mysql_query($query2, $db2) or die(mysql_error());
while($nt2 = mysql_fetch_array($result2, $db2))
{

}
The error I get is
Quote

Warning: mysql_fetch_array() expects parameter 2 to be long, resource given in C:\xampp\htdocs\HighVisibility\DashBoard2.php on line 13

Warning: mysql_fetch_array() expects parameter 2 to be long, resource given in C:\xampp\htdocs\HighVisibility\DashBoard2.php on line 22