PHP - Well This Is Strange And New. Issue With & Symbol And Mysql

Hi,

I am new to php but not to programming.

I created a script on a windows platform which connects to the mysql database and returns the results of a table.  A very basic script which I wrote to simply test my connection worked.  The script works fine on my windows machine but not on my new mac.  On the mac it simply does not display any records at all.

I know that the database connection has been established because there is no error but I can not see why the result set is not being displayed on screen, as I said it worked fine on my windows machine.

The Mac has mysql (with data) and apache running for php.

Please could someone help as I have no idea what to do now?

Script below:

Code: [Select]
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'root';

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

$dbname = 'test';

mysql_select_db($dbname);

mysql_select_db("test", $conn);

$result = mysql_query("SELECT * FROM new_table");

while($row = mysql_fetch_array($result))
  {
  echo $row['test1'] . " " . $row['test2'] . " " . $row['test3'];
  echo "<br />";
  }

mysql_close($con);

Ok so I have a simple database table set up, and I am trying to get the results into an HTML table, however I have a question. One loop I write in a for loop will dump the data I want to the table, the other returns no results. For example I have the code...
Code: [Select]

       
//SQL Lookup
//SQL Lookup
$sqlAppt = mysql_query("SELECT * FROM Appointment WHERE TTUNumber = \"$TTUNumber\" && ShippingNumber = \"$ShippingNumber\" LIMIT 1") or die('Could not execute SQL statement ' . mysql_error());


$numbRows = mysql_num_rows($sqlAppt);
echo "<p>Number of rows found: $numbRows </p>\n";


So When I create the first whlile loop, i do not get any results from my database.

Code: [Select]
while($r=mysql_fetch_array($sqlAppt)){
           
   $ApptDate=$r['Date'];
   $ApptTime=$r['Time'];
   $ApptNumber=$r['ApptNumber'];
   $ApptDock=$r['Dock'];
               
   echo '<h1>I got here</h1>'."\n";
   echo "<table>\n";
   echo "<tr><td>Date</td><td>$ApptDate</td></tr>\n";
   echo "<tr><td>Time</td><td>$ApptTime</td></tr>\n";
   echo "<tr><td>Appt Number</td><td>$ApptNumber</td></tr>\n";
   echo "<tr><td>Dock</td><td>$ApptDock</td></tr>\n";
   echo "</table>\n";
               
}


The Results is this:
Quote

Number of rows found: 1
I got here
Date   
Time   
Appt Number   
Dock   



However, when I create a different loop structure...
Code: [Select]

for($i = 0; $i < $numbRows; $i++) {
               
   $r=mysql_fetch_array($sqlAppt);

   $ApptDate=$r['Date'];
   $ApptTime=$r['Time'];
   $ApptNumber=$r['ApptNumber'];
   $ApptDock=$r['Dock'];
               
   echo '<h1>I got here</h1>'."\n";
   echo "<table>\n";
   echo "<tr><td>i:</td><td>$i</td></tr>\n";
   echo "<tr><td>Date</td><td>$ApptDate</td></tr>\n";
   echo "<tr><td>Time</td><td>$ApptTime</td></tr>\n";
   echo "<tr><td>Appt Number</td><td>$ApptNumber</td></tr>\n";
   echo "<tr><td>Dock</td><td>$ApptDock</td></tr>\n";
   echo "</table>\n";
               
}


Naturally I get a different result! 
Quote


Number of rows found: 1
I got here
i:   0
Date   1982-12-26
Time   08:00:00
Appt Number   123
Dock   34



I can't figure out why for the life of me that my while loop would not return anything on here>?  Does anyone have any idea's?

Thanks

Hi, I have this code below which groups all the SubHeading together and then queries the same table to find RiskConsequence which are grouped that match SubHeading then to query this table one more last time with all the Risk Mitigation that matches the grouped RiskConsequence.

Problem I get is it does the SubHeading, the RiskConsequences it only does one of them not all of them before it moves onto the RiskMitigation.

I know I have a php coding issue just cant see the wood from the tree's as the queries work.

Code: [Select]
<?php
include ("include.php");
$query = "SELECT * FROM tblriskassessmentdatabank GROUP BY SubHeading";
$results = mysql_query($query) or die("Error: " . mysql_error());
while($row1 = mysql_fetch_array($results)){
    

    echo'<a href="#" onClick="return(changeDisplay(';echo"'";echo($row1[SubHeading]);echo"'))";echo'">';echo($row1[SubHeading]);echo'</a><br /><br />';
echo'<div id="';echo($row1[SubHeading]); echo'" class="HideText">';

$risksub = $row1[SubHeading];

$query1 = "SELECT * FROM tblriskassessmentdatabank GROUP By RiskConsequence";
$results1 = mysql_query($query1) or die("Error: " . mysql_error());
while($row2 = mysql_fetch_array($results1)){


echo'<a href="#" onClick="return(changeDisplay(';echo"'";echo($row2[RiskConsequence]);echo"'))";echo'">';echo($row2[RiskConsequence]);echo'</a><br />';
echo'<div id="';echo($row2[RiskConsequence]); echo'" class="HideText">';
$risksub1 = $row2[RiskConsequence];
$query1 = "SELECT * FROM tblriskassessmentdatabank WHERE RiskConsequence = '$risksub1'";
$results1 = mysql_query($query1) or die("Error: " . mysql_error());
while($row3 = mysql_fetch_array($results1)){

echo'<input name="checkbox[]" type="checkbox" id="checkbox[]" value="';echo($row3[IssueNumber]);echo'" />
    <label for="checkbox[]"></label>';echo($row3[RiskMitigation]);echo'<br /><br />';
}
echo'</div>';

}

echo'</div>';
  }
?>

What is the & symbol used for I have seen it in
function setname(&$name){
 $this->name =& $name;
}


Thanks I have looked on google and can't find it as i don't know what it is called.

thanks

Hello,

Im getting a name from the url, for instance,

index.php?name=C.-and-G

The "and" is then converted to a & symbol and dashes converted to spaces.

This then uses the new name "C. & G" to select a record from mysql. However, it does not recognise the & symbol, the name in mysql is "C. & G" but returns 0 records.

Any ideas? Thanks!

Code: [Select]
$query = "LOWER(name)="$tabB";
on my forums, speakwhatsreal.com

new message page, let's say somone on my site has the name "$tabB" how do i make the above query work so it selects a username with the $ symbol in it?



because with that query it's linked to




Code: [Select]
$DB->query("SELECT name, id, mgroup, language, email FROM ibf_members WHERE ".$query);
         $to_member = $DB->fetch_row();

         if (empty($to_member['id']))
         {
             $this->send_form(0, $ibforums->lang['err_no_such_member']);
             return;
         }
pretty much says no results.. lol

any help?

I'm a little confused exactly on how using this } works
going to be hard to explain what im having problems with.

I'm using JEdit for my editor
and I notice if I click on one of these { it will put a box around where it ends
there is 4 } at the bottom of the code by them selfs "on their own lines"
and 2 in the middle by them selfs "on their own lines

how does the code know which ones belong to which {
appreicate any help in helping me understand this thanks


this code is from a tutor online

Code: [Select]
<? include_once("connect.php"); ?>

<html>
<body>

<?php
if(isset($_POST['Login'])) {

if(!preg_match('/^[A-Za-z0-9]{5,20}$/',$_POST['Username'])){ // before we fetch anything from the database we want to see if the user name is in the correct format.
         echo "Invalid  Username.";
 }else{
 
 $query = "SELECT password,id,login_ip FROM users WHERE name='".mysql_real_escape_string($_POST['Username'])."'"; 
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result); // Search the database and get the password, id, and login ip that belongs to the name in the username field.
 
if(empty($row['id'])){
// check if the id exist and it isn't blank.
    echo "Account doesn't exist.";
}else{

if(md5($_POST['password']) != $row['password']){
// if the account does exist this is matching the password with the password typed in the password field. notice to read the md5 hash we need to use the md5 function.
            echo "Your password is incorrect."; 
}else{

if(empty($row['login_ip'])){ // checks to see if the login ip has an ip already 
$row['login_ip'] = $_SERVER['REMOTE_ADDR'];
}else{

$ip_information = explode("-", $row['login_ip']); // if the ip is different from the ip that is on the database it will store it

if (in_array($_SERVER['REMOTE_ADDR'], $ip_information)) {
$row['login_ip'] = $row['login_ip'];
}else{
$row['login_ip'] = $row['login_ip']."-".$_SERVER['REMOTE_ADDR'];
                     }
     }

$_SESSION['user_id'] = $row['id'];// this line of code is very important. This saves the user id in the php session so we can use it in the game to display information to the user.
 
$result = mysql_query("UPDATE users SET userip='".mysql_real_escape_string($_SERVER['REMOTE_ADDR'])."',login_ip='".mysql_real_escape_string($row['login_ip'])."' WHERE id='".mysql_real_escape_string($_SESSION['user_id'])."'")
or die(mysql_error());

// to test that the session saves well we are using the sessions id update the database with the ip information we have received.

header("Location: Sample.php"); // this header redirects me to the Sample.php i made earlier


      }
}

     }
}  
?>

<form id="form1" name="form1" method="post" action=""><center>
  GAME LOGIN
  <br />
  <br />
  Username:
  <input type="text" name="Username" id="Username" />
  <br />
  <br />
Password:
<input type="password" name="password" id="password" />
  <br />
  <br />
  <input type="submit" name="Login" id="Login" value="Login" />
  </center>
</form>

</body>
</html>

I am running php 5.3.2 on my local dev and on the server I am running  php 5.2.5. In my log files I keep getting deprecated messages like:
PHP Deprecated:  Assigning the return value of new by reference is deprecated in /Users/xxx/dev/git/xxx/cake/dispatcher.php on line 677

Can I just delete & to get rid of this message or will that hose the script locally and on the server? I believe that php 5+ passes all objects as reference.

Thanks

This topic has been moved to MySQL Help.

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

Hi,

I'm looking through some code I have for setting up a rating system. It was a free open source code, which I need to change to work for my own site. I have it working, but I am now just looking through the code to try and understand it, and for the most part, I do.

There is one part I am not familiar with, if somebody could help me please?

Values involved;
$current_rating = total rate value of votes
$count = total number of votes cast

Problem I have is the @ symbol here
$rating=@number_format($current_rating/$count, 1);

Does it format it to decimal places or something like that? It's probably something simple I know, but I am a relative newb.

Thanks.

Easy One - What is the symbol for or?

Example: && = and, right?
What is 'or'?

What does it mean

Like..

!@file_get_contents('url');

or.. !file_get_contents or @file_get_contents

Code: [Select]
$mystring = "|Signature";
$findme   = '|';
$pos = strpos($mystring, $findme);
echo $pos;
echo's 0

supposed to echo out 1....?

why not work
 thanks


How can I enable it to check for Code: [Select]
| using strpos?

Trying to echo a string that contains a hash symbol.  Instead of getting a hash symbol, I get %29.  The code I am using is pretty basic -->$idx="#" . $idxA;<--, but as stated, when I echo $idx, it comes out as %29.  (All of this is part of a form, get, attempting to pass a bookmark to the receiving program.

Thoughts?