PHP - Simple Select Issues

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 2 queries that I want to join together to make one row  

Hi everyone,

I'm trying to select either a class or an id using PHP Simple HTML DOM Parser with absolutely no luck.  My example is very simple and seems to comply to the examples given in the manual(http://simplehtmldom.sourceforge.net/manual.htm) but it just wont work, it's driving me up the wall.

Here is my example: http://schulnetz.nibis.de/db/schulen/schule.php?schulnr=94468&lschb=

I think the HTML is invalid: i cannot parse it.

Well i need more examples - probly i have overseen something!

If anybody has a working example of Simple-html-dom-parser...i would be happy.
The examples on the developersite are not very helpful.

your dilbertone

Hello, im very green to php and I am having trouble creating a simple log in script. Not sure why this is not working, maybe a mysql_query mistake? I am not receiving any errors but nothing gets updated in the members table and my error message to the user displays.  any help is appreciated! here is my php:


<?php
session_start();

$errorMsg = '';
$email = '';
$pass = '';

if (isset($_POST['email'])) {
   $email = ($_POST['email']);
   $pass = ($_POST['password']);
   
   $email = stripslashes($email);
    $pass = stripslashes($pass);
   $email = strip_tags($email);
   $pass = strip_tags($pass);
   
if ((!$email) || (!$pass)) {
   $errorMsg = '<font color="#FF0000">Please fill in both fields</font>';
}else {
   include 'scripts/connect_db.php';
   $email = mysql_real_escape_string ($email);
   $pass = md5($pass);
   
   $sql = mysql_query("SELECT * FROM members WHERE email='$email' AND password='$pass'");
   
   $log_check = mysql_num_rows($sql);
   
if ($log_check > 0) {
    while($row = mysql_fetch_array($sql)) {
      
      $id = $row["id"];
      $_SESSION['id'];
      $email = $row["email"];
      $_SESSION['email'];
      $username = $row["username"];
      $_session['username'];
      
      mysql_query("UPDATE members SET last_logged=now() WHERE id='$id' LIMIT 1");
      
   }//Close while loop
   echo "You are logged in";
             exit();
}
else {
   $errorMsg = '<font color="#FF0000">Incorrect login data, please try again</font>';
}


     }
}
?>



and the form:

<?php echo $errorMsg; ?>
<form action="log_in.php" method="post">
Email:<br />
<input name="email" type="text" /><br /><br />
Password:<br />
<input name="password" type="password" /><br /><br />
<input name="myBtn" type="submit" value="Log In" />
</form>

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>

Hi can someone pls help, im tryin a tutorial but keep getting errors, this is the first one i get after registering.

You Are Registered And Can Now Login
Warning: Cannot modify header information - headers already sent by (output started at /home/aretheyh/public_html/nealeweb.com/regcheck.php:43) in /home/aretheyh/public_html/nealeweb.com/regcheck.php on line 46

Hello, I'm having troubles parsing text properly.  Whenever I submit data into a mysql db, and then call that specific data, in the text, I get this symbol,  �.  Does anybody know what it is or how to remove it?  I believe it's with utf-8 and me using a function that corrupts the string but I'm not sure.  Anybody have any clues?  Thanks in advance.

i am trying to sort out a session now,

i normally use the folllowing code to check if someone is logged in and if they are not to forward them to the login page,
but i am getting this message:

Notice: Undefined index: username in

code:
Code: [Select]
if ($_SESSION['username']) {
}else{
 include 'login.php';
 die("");
}

can someone help please.

Hey all,

I can not get utf-8 working properly.

I'm having issues with special characters, such as bullets, e with an accent over it, etc.

The data is being stored in my mssql database properly, and I can see everything there fine. It's when I grab it from the database and display it on my php page. The page it set up to utf-8, if I go to Tools>Page Info, it says encoding is utf-8. I have it in my headers, I just can not figure out why it will not display on the page.

Any thoughts?

Issue # 1
How can i send the values come from $_POST['name'],$_POST['number'] to an email address xyz@radiations3.com???

Issue # 2
I am trying to display data from four different tables with the following sql query:
(The problem is that the data is getting displayed fine but i don't know why some of the (same )data gets repeated two or three times where as i checked in all four tables and all the data exists one time not twice)
If anything wrong with my query kindly help

SELECT distinct *
FROM applicant,applicant_info_nic,room,student
WHERE applicant_info_nic.status='Available' and  applicant.appNIC=applicant_info_nic.appNIC and applicant.roomID=room.roomID and applicant.appNIC=student.appNIC
ORDER BY applicant.roomID

Code: [Select]
OFXAdapter: Failed to parse request: Unable to parse an atomic field "OFXRequest.OFXRequest.SignOnMsgsRqUn.SignOnMsgsRqV1.SonRq.DtClient": field value "20101005091544.000[-4:EDT]" is not a valid (YYYYMMDDHHMMSS.XXX[gmt offset:tz name]) date.
I am trying to put together some PHP code to use the OFX standard to communicate with my bank in order to download my recent transactions. The standard details that in the sign-on request, the date and time must be included in the format listed above.

As you can see, I have the value in the exact same format as specified. So my question is this: is there something about GMT offset or TZ names that I am missing here?

It DOES NOT any of this information for the wrestlers that DO NOT have a manager and if they do then it shows all as undefined variables. I know it has to do with the while statement I'm sure it's how its echoing the info and I don't know how to modify it so that I can echo the variable and if there's no value for the row then it shows N/A as its value.


function getWrestling($style, $id) {
$id=mysql_real_escape_string($id);
if ($style=='singles') { 
$query = "SELECT bio.charactername AS manager, ebw.finisher AS finisher, ebw.setup AS setup, ebw.music AS music FROM efed_bio_wrestling AS ebw JOIN efed_bio AS bio ON ( ebw.manager_id = bio.id) WHERE ebw.bio_id = '$id'";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)){
?>
<h2>Wrestling</h2>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowb">
<td class="biotableheadingb">Manager/Valet:</td>
<td class="biotabledatab"><?php if (strlen ($manager) < 1) {  print "N/A"; } else { print "$manager";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Finisher:</td>
<td class="biotabledatab"><?php if (strlen ($finisher) < 1) {  print "N/A"; } else { print "$finisher";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Setup:</td>
<td class="biotabledatab"><?php if (strlen ($setup) < 1) {  print "N/A"; } else { print "$setup";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Entrance Music:</td>
<td class="biotabledatab"><?php if (strlen ($music) < 1) {  print "N/A"; } else { print "$music";}?></td>
</tr>
</table>
<?php } }?>

As far as it goes for me I have the switch() working, but not to what im trying to do. This is for a "media" page where I have 3 different categories "Music", "Videos" and "Photos". I'm trying to get it so when you goto the "Media" page it will show just the 3 categories, that section works but it is also showing the sub categories for all them categories. So for what im trying to do is when viewing the "media" page, it will display the 3 categories, then when selecting the category it will display the "sub categories". and then when you select the "sub category" it will display the contents of that "sub category"

should i be trying to do this a different way? or do i have something wrong here? lol

here is my switch() code
Code: [Select]
<?php
 $cat = (isset($_GET["m_cat"])) ? (intval($_GET["m_cat"])) : 0;
 switch($_GET["b"]=="true")
{
default :
if("/ffy/media.php"==$_SERVER['PHP_SELF'])
{
echo "Select a Category";
}

case "false":
if($_GET["m_cat"]==$cat)
{

echo "<font size='3'>";
$dcat = mysql_query("SELECT * FROM media_sub_cat WHERE m_cat=$cat")
or die("mySQL Query Failed: " .mysql_error());

while($catrow = mysql_fetch_array($dcat)) {
list($id, $m_sub_cat, $m_cat) = $catrow;

echo ": <font class='myFont'><a href='media.php?b=true&cat=".$m_cat."&subcat=".$m_sub_cat."'>".$m_sub_cat."</a></font> ";
}
echo ":</font>";
echo "Work Damb You";
}
break;

case "true":
if($_GET["cat"]==$cat && $_GET["subcat"]==$m_sub_cat)
{

echo "Weird...";

}
break;
}
?>

Hello,

I have the following code


Code: [Select]
class Uploads extends Controller
{
 public function __construct()
 {
  parent::__construct();

  if (empty($_FILES))
  {
   log_message('error', 'Uploads - files empty');
   exit('No files uploaded');
  }

  ini_set('memory_limit', '128M');

  $this->load->helper('file');
  $this->load->helper('helpers');
  $this->load->model('uploads_model');

 }

 public function font_handler()
 {
  $this->uploads_model->font_handler();
 }

}

class Uploads_model extends Model
{
    public function font_handler()
    {
  $config = array(
   'max_size'     => '8388',
   'allowed_types' => 'ttf',
   'upload_path'   => 'assets/fonts/'
  );

  $this->load->library('upload', $config);

  if ($this->upload->do_upload('Filedata'))
  {
   $file = $this->upload->data();
   $jsFile = $file['raw_name'].'.js';
   $query = $this->db->where('location', 'menuFont')->get('fonts')->row();

   if ($query->customFile != '' && file_exists('assets/fonts/'.$query->customFile))
         {
    unlink('assets/fonts/'.$query->customFile);
   }

   $path    = getcwd() . '/assets/fonts/cufon/convert.php';
   $command = 'php ' . $path . ' -u "U+??" ' . $file['full_path'] . ' 1> ' . getcwd() . '/assets/fonts/' . $jsFile;

   system($command);
  }
 }

}


Ok so, the ttf file is uploaded correctly and I can run $command from the command promt in putty and it works perfect, but when I try to run the same command from system() the js file just contains (from the controller) "No files uploaded" I have no idea why this is happening? Anyone have any ideas?  Also one thing i'm not sure about is if it should be 1> or > when creating the js file?!?


Thanks guys!