PHP - Is It My Sql Select Line?

hirealimo.com.au/code1.php

this works as i want it:
Quote

SELECT * FROM price INNER JOIN vehicle USING (vehicleID) WHERE vehicle.passengers >= 1 AND price.townID = 1 AND price.eventID = 1



but apparelty selecting * is not a good thing????

but if I do this:
Quote

SELECT priceID, price FROM price INNER JOIN vehicle....etc


it works but i lose the info from the vehicle table.

but how do i make this work:
Quote

SELECT priceID, price, type, description, passengers FROM price INNER JOIN vehicle....etc


so that i am specifiying which colums from which tables to query??

thanks

I have a script that reads a .gz file into an array and prints the name of each record but will not work on larger files. Is there a way to read 1 line at a time?
Here is the code I have so far.
Code: [Select]
<?php

if ($handle = opendir('.')) {

print "<ol>";
    
    while (false !== ($file = readdir($handle))) {
if($file != '..' && $file!="." && $file!="start_update.php" && $file!="sharons_dbinfo.inc.php" && $file!="root.php" && $file!="read_directory.php" && $file!="read_dir.php" && $file!="new_category.php" && $file!="index.php" && $file!="file_count.php" && $file!="dir_loop2.php" && $file!="dir_loop1.php" && $file!=".htaccess" && $file!="Answer.txt" && $file!="Crucial_Technology-Crucial_US_Product_Catalog_Data_Feed.txt"){
$filename = $file;
$go = filesize($filename);
if($go >= 1){
$filename2 = explode("-", $filename);
$filename2 = $filename2[0];
echo str_replace("_"," ",$filename2) . ' | Filesize is: ' . filesize($filename) . ' bytes<br>';
$gz = gzopen($filename, 'r');
$lines = gzfile($filename,10000);
foreach ($lines as $line) {
$line2 = explode(",", $line);
$line2 = str_replace("," , "-" , $line2);
    echo "<li>".str_replace("," , "-" , $line2[4])."</li><br>";
}

}
}
    }

    closedir($handle);
}
?>
</ol>

How to get this echo line to display as one line?
No matter what I have done it displays as two lines.  I even tried <nobr></nobr>

Teachers Name:
John Jones

$userid = mysql_real_escape_string($_GET['user_id']);
$sql = "select * from users where `id`='$userid' ";

$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{ 
echo  "<h3>Teachers Name: </h3>" . $row["first_name"] . " " . $row["last_name"]  ;  }


Thanks for your help.

I have 2 queries that I want to join together to make one row  

I'm so sorry to ask such a "newbee question," but believe me I have been on Google for the better part of the week trying to find an answer.   I'll start with the brief question. Then I'll give an example to show what I mean. Then, I'll give the BESTEST "pseudo-code" I could come up with (to PROVE that I've really given it my best).   Question: How do I make PHP loop through a big file, make the changes line by line, and to save the resultant file.   Example: I have a 100mb text file ("animals.txt") with 500,000 lines. If any lines have the word "cat" in it, I want to add "Be careful with cats!" to the end of the line:   From this: A fish and his tank. A cat and his toy. A bird and her cage. A frog and his lilly. A cat and her friend.   To this: A fish and his tank. A cat and his toy. Be careful with cats! A bird and her cage. A frog and his lilly. A cat and her friend. Be careful with cats!   The best "pseudo-code" I can come up with is:   <?php $data = file_get_contents("animals.txt"); $lines = explode(PHP_EOL,$data);

I want my application will send a email after 10 minutes of sending another email.

In my application

A user completes registration with payment Application sends the user a payment confirmation email

Now I want to

send another email 10 minutes After payment confirmation email with welcome tips

Below is the function where for user setup .

 

public function finishUserSetup($Sub){

    if($Sub == 0){
        $subscription = SubscriptionPlans::where('identifier', '=', "Monthly")->first();
        $expiry = date('Y-m-d', strtotime('+' . $subscription->months . ' months'));
        $sub_period = "monthly";
    
    } else{
        $subscription = SubscriptionPlans::where('identifier', '=', "Annually")->first();
        $expiry = date('Y-m-d', strtotime('+' . $subscription->months . ' months'));
        $sub_period = "annually";
    }

    $this->expiry_date = $expiry;
    $this->user_type = "SUB";
    $this->subscription_period = $sub_period;
    $this->update();

    $replaceArray = array(
        'fullname' => $this->forename . " " . $this->surname,
        'subscriptionName' => $subscription->name,
        );
    EmailTemplate::findAndSendTemplate("paymentconfirm", $this->email, $this->forename . " " . $this->surname, $replaceArray);

  }

In the above function the last line of code is the one which sends a payment confirmation email to the user which is

EmailTemplate::findAndSendTemplate("paymentconfirm", $this->email, $this->forename . " " . $this->surname, $replaceArray);

I want to execute the following line of code 10 minutes after the above one

 

EmailTemplate::findAndSendTemplate("WelcomeTips", $this->email, $this->forename . " " . $this->surname, $replaceArray);

 

 

How to do that. that is running the last line of code 10 minutes after  

Dear All,

I wish to have 2 drop down boxes, Country Select Box and Locality Select Box. The locality select box will be affected by the value chosen in the country select box.

All is working fine except that the locality select box is not being populated.
I know that the problem is in the sql statement

WHERE country_id='$co'

because i am having an error that $co is an undefined variable.

All the rest works fine because i have replaced the $co variable directly with a number (say 98) for a particular country id and it worked fine. In what way can i define this variable $co so that it is accepted by my sql statement?

Thank you for your help in advance.

MySQL Tables indicated below:

CREATE TABLE countries(
country_id INT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
country_name VARCHAR(30) NOT NULL,
PRIMARY KEY(country_id),
UNIQUE KEY(country_name),
INDEX(country_id),
INDEX(country_name))
ENGINE=MyISAM;

CREATE TABLE localities(
locality_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
country_id INT(3) UNSIGNED NOT NULL,
locality_name VARCHAR(50),
PRIMARY KEY (locality_id),
INDEX (country_id),
INDEX (locality_name))
ENGINE=MyISAM;

Extract PHP script included below:

// connect to database
require_once(MYSQL);

if(isset($_POST['submitted']))

{

// trim the incoming data

/* this line runs every element in $_POST through the trim() function, and assigns the returned result to the new $trimmed array */
$trimmed=array_map('trim',$_POST);

// clean the data

$co=mysqli_real_escape_string($dbc,$trimmed['country']);

$lc=mysqli_real_escape_string($dbc,$trimmed['locality']);

}

?>

<form action="form.php" method="post">

<p>Country
<select name="country">
<option>Select Country</option>

<?php

$q="SELECT country_id, country_name
FROM countries";

$r=mysqli_query($dbc,$q) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($r))

{

$country_id=$row[0];
$country_name=$row[1];
echo '<option value="' . $country_id . '"';
if(isset($trimmed['country']) && ($trimmed['country']==$country_id))
echo 'selected="selected"';
echo '>' . $country_name . '</option>\n';

}

?>

</select>
</p>

<p>Locality
<select name="locality">
<option>Select Locality</option>

<?php

$ql="SELECT locality_id, country_id, locality_name
FROM localities
WHERE country_id='$co'
ORDER BY locality_name";

$rl=mysqli_query($dbc,$ql) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($rl))

{

$locality_id=$row[0];
$country_id=$row[1];
$locality_name=$row[2];
echo '<option value="' . $locality_id . '"';
if(isset($trimmed['locality']) && ($trimmed['locality']==$locality_id))
echo 'selected="selected"';
echo '>' . $locality_name . '</option>\n';

}

// close database connection
mysqli_close($dbc);

?>

</select>
</p>

<p><input type="submit" name="submit" value="Submit" /></p>

<input type="hidden" name="submitted" value="TRUE" />

</form>

gday all!

just starting to learn php but having a liitle problem with \n forcing a line break. in my situation it simply doesnt.
looking at this what have i done wrong?
Code: [Select]
echo "<div class=\"imgcontainer\"><a href='$row[filename]'  rel='shadowbox[thingo]'><img class= 'thumbnail' img src='$row[filename]'/></a><div class=\"thetext\">Artwork: $row[name]\nArtist:$row[artist]</div></div> ";
Thanks

echo '<div class="gamename">'.$values[0].'</div>';
echo  '<div class="gameimage"><a href="'.$values[3].'"><img src="'.$values[1].'"></a></div>';

NOW i want 2nd echo under 1st echo. I tried every single <br> combination but no luck   

Also my 2nd question is: my image and link is a variable, it displays the image but there is something wrong with link.
Variable is just like this  www.mydomain.com\image\blabla.php
but it shows link as==> www.mydomain.com\     instead of what i wrote above.

Hi ! my name is Enrique, I'm new in the forum, and I'm writing because I can't uderstand what is wrong with this line:

protected $something = array('some' => self::$thing);

These doesn't work too:

protected $something = array('some' => $this->thing);
protected $something = array('some' => $thing);

But this yes:

protected $something = array('some' => 'thing');

Also, if I use something like this:
protected $something = array();
public function somefunction()
{
    $this->something = array('user' => self::$thing);
}

it works fine.

Is not possible to use vars when initiating an array in the members declarations?????
I can't understand where is the problem...

Thanks !!

Hi, here the bit of code:

Code: [Select]
echo 'You\'ll be redirected in'; include('script.html'); echo 'secs. If not, click <a href="visit.php">here</a></div>.';
this is being displayed on 3 lines I want to have it all on 1 line, how is this done?
(script.html is a javascript countdown clock)

thanks

 <a href=pictures1.php?user_id= ' . $row['user_id'] . '>' . $row['name'] . '</a>';

The program ignores  ' . $row['user_id'] . ' so does not go to the correct page. Why would this be? ' . $row['name'] . ' works.

Any answers greatly appreciated

hello,

anybody able to take a quick look and see why i have an error on both line 16 and 52?

Code: [Select]
<?php
include 'config.php';
include 'style.php';
include 'auth5.php';

$randeid=rand(121047, 997893);

if(isset($_GET["delete"]))
{
$did=$_GET["delete"]; 
$query11= mysql_query("delete FROM tools where id =$did")or die(mysql_error()); 
}

$groups = mysql_query("SELECT * FROM tools ORDER BY group");
$groups1="";
while($row1 = mysql_fetch_array($groups))
  {
$groupnames=$row1['group'];

$groups1.="<OPTION VALUE=\"$groupnames\">".$groupnames.'</option>';
  }

?>
<form method="POST">
<p align="center">Search For:   
<select size="1" name="tool"><?php echo "$groups1"; ?></select>   
<input type="submit" value="Search" name="search"></p>
</form>
<?php



if(isset($_POST['search']))
{

$tool=$_POST['tool'];

echo "<table border='1' style='border-collapse: collapse' bordercolorlight='#000000' bordercolordark='#000000' width='98%' align='center'>";
echo "<tr><td width='100%' colspan='4' align='center'><b>Tool List</b></td></tr>";

echo "<tr>

<th align='center'>Tool</th>
<th align='center'>Barcode</th>
<th></th>
<th></th>


</tr>";

$result = mysql_query("SELECT * FROM tools WHERE group LIKE '%$tool%' ORDER BY tool");
while($row = mysql_fetch_array($result))
{

$id=$row['id'];
$tool=$row['tool'];
$barcode=$row['barcode'];
$location=$row['location'];


  echo "<tr>";
  echo "<td align='center'>" . $tool . "</td>";
  echo "<td align='center'><img src='barcode.php?format=jpeg&quality=100&width=150&height=75&barcode=" . $barcode . "'></td>";
  echo "<td align='center'>Print</td>";
  echo "<td align='center'><a href='searchtool.php?delete=" . $id . "'>Delete</a></td>";
  

  echo "</tr>";
  }
echo "</table>";

}

include 'close.php';
?>

Code: [Select]
$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field'].",";
$i++;
}
}
$csv_output .= "\n";

$values = mysql_query("SELECT * FROM ".$table."");
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= $rowr[$j].", ";
}
$csv_output .= "\n";
}

print $csv_output;
I'm using the above to get a csv output in my browser, but it appears as a string of text
eg
a1,a2,a3,a4,b1,b2,b3,b4,...

I'd like it to appear as
a1,a2,a3,a4
b1,b2,b3,b4
c1,c2,c3,c4

Any ideas how?