PHP - Reading Table Cells

Okay I don't mind telling you I am very perplexed on how to read a text file delimited with TAB into a HTML Table using PHP. I don't know where to begin, I have read about 12 examples and get more confused each time. I hope someone can help me. I am looking to read this delimited (TAB) file skipping the first line and reading array's 2,5,6,7,8,9, and 10, then displaying in a HTML Table. Corresponding Headers would be nice. The php file does not work at the present because I am trying to read the array sections by row.    Thank You in advance Attached Files  ParseText.php   852bytes   3 downloads  JimTest.txt   16.88KB   1 downloads

Hi   I come from a desktop (vb.net) background and have used oridinary text files for my databases. I use file locking to prevent other processes from writing to the same file simultaneously.   Now I am moving over the PHP/MySQL - what precautions should I take to stop a simultaneous processes from writing to a table at the same time.?   Do I need to lock the table before writing to it?   Does MySQL deal with this automatically and just block my process until the table becomes free?   (I am talking about a single table here, not multiple dependant tables - I know that is another issue)   Thanks     Nigel

I am creating a form from a main table.  Some of the fields in that table will be populated from information in another table (table2).

On the form, I created a radio button with the value set to the ID of table2, and the text following that as the label.
My problem is that I'd like the data to span several columns, say 5 items in the first column, 5 in the second, and the rest in the 3rd.

Here is the code I used to populate the form:

  Quote

<tr><td>Select one:</td><td><?php do { ?><input name="mom_ed" type="radio" value="<?php echo $row_degree['degreeID']; ?>" /><?php echo $row_degree['degree']; ?><?php } while ($row_degree = mysql_fetch_assoc($degree)); ?></td></tr>


Can someone help me figure out how to do this?

Thanks!   

What I want is basicly a newspaper function.

I have a table like this:

name hone website email name1 hone1 website1 email1
So what i want is creating a mail link that takes the 2 mailadresses from my table. 1 email with 2 reciepts. Just like you seperate them with the ; in you mailclient

mailto:email; email1


Hoping someone can help, I think it is not that hard, I am just a nOOb

Hi Guys,
I am looking for a way to format excel cells using PHP, I am exporting mysql data to excel file using below method:


$fields = array("Date", "Time In", "Time Out", "Hours", "Project", "Component", "Sub-Component", "Work Done", "Supervisor Changes", PHP_EOL);
file_put_contents($filename, implode("\t", $fields), FILE_APPEND);


Now I want to make BOLD all this header fields, so please help me to this construct..

Thank you

Hello

Im trying to achieve the following output (see the below table. Then on a new row have the next 4 pieces of data that is pulled from the database.

So i want the table to automatically have a new row after every 4 cells e.g.

1st piece of data               2nd piece              3rd piece               4th piece
5th piece of data               6th piece              7th piece                8th piece

etc etc, until there is no more results within the database to pull back, i guess its a bit like pagination but rather rowination

Any one point me in the right direction on what i need to do

I have tried the following variations but non works

if($row['relation'] = "" ){

if($row['relation'] = '' ){

if($row['relation'] = NULL ){

if($row['relation'] IS NULL ){

if(strlen($row['relation']) = 0 ){

So how would one refer to a cell that is empty?

Hi wondered if someone could help me i have this code:

if (isset($data['product_image'])) {
         foreach ($data['product_image'] as $image) {

         $image = $image.".jpg";
         $image = str_replace (" ", "", $image);
         
         $filename = '/home/purchase/public_html/fancydresscostumesonline.co.uk/image/'. $image;

         if (file_exists($filename)) {
         $this->db->query("INSERT INTO " . DB_PREFIX . "product_image SET product_id = '" . (int)$product_id . "', image = '" . $this->db->escape($image) . "'");   
         } else {
            $this->db->query("INSERT INTO " . DB_PREFIX . "product_image SET product_id = '" . (int)$product_id . "', image = 'no_image.jpg'");
         }
         
         }
      }

This part of the code adds a jpg at the end of the product_image additional images so in my csv the 10 columns which have additional numbers for example in my csv it has: say 00532 so this code adds 00532.jpg once imported the the next part which is the else statement no_image.jpg adds a no_image.jpg but instead of it inserting a no_image.jpg for all the blank cells i would like it to SKIP the blank cells for the additional images which is product_image so if no number in the cell it SKIPS it. but have no clue how to do it.

Hope someone can help

Regards,
Aaron

This topic has been moved to MySQL Help.

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

PHP 5.3.8
XAMPP on Windows XP

I have an XML file that manages the input to an mp3 player on this page http://www.jimslounge.com/segovia/
The structure looks like this
Code: [Select]
<content>

  <auto_play>yes</auto_play>
  <loop>yes</loop>
  <volume>60</volume>

  <artist>
    <song_title><![CDATA[Bach - Suite No. 3 - Allemande]]></song_title>
    <artist_name><![CDATA[Andre Segovia]]></artist_name>
  <image_path>load/images/segovia.jpg</image_path>
  <mp3_path>load/songs/Bach - Suite No. 3 (for solo cello, arr. Duarte)- Allemande.mp3</mp3_path>
<url target="_blank"  open="yes">http://en.wikipedia.org/wiki/Andr%C3%A9s_Segovia</url>
  </artist>
  <artist>
      ...
with <artist> being the repeating element I want to be able to read and eventually write to
If I run this
Code: [Select]
$xml = simplexml_load_file("load.xml");
 var_dump($xml);
I get this
object(SimpleXMLElement)#1 (4) { ["auto_play"]=> string(3) "yes" ["loop"]=> string(3) "yes" ["volume"]=> string(2) "60" ["artist"]=> array(22) { => object(SimpleXMLElement)#2 (5) { ["song_title"]=> object(SimpleXMLElement)#24 (0) { } ["artist_name"]=> object(SimpleXMLElement)#25 (0) { } ["image_path"]=> string(23) "load/images/segovia.jpg" ["mp3_path"]=> string(74) "load/songs/Bach - Suite No. 3 (for solo cello, arr. Duarte)- Allemande.mp3"  ... [/color]
which is overwhelming

This cleans it up but doesn't give me the artist name and song name I'm looking for.

Code: [Select]
$xml = simplexml_load_file("load.xml");
echo $xml->getName() . "<br />";
foreach($xml->children() as $child)
  {
  echo $child->getName() . ": " . $child . "<br />";
  }

The Output:
content
auto_play: yes
loop: yes
volume: 60
artist:
artist:
artist:

 My experience with simplexml only goes back a couple of hours so I'm pretty inept at this point.  Any help will be greatly appreciated.

The following script just validates some form inputs, and then puts any errors inside an array.

I get this error: Fatal error: Cannot use [] for reading in C:\xampp\htdocs\Game\includes\validation.php on line 104

I've looked around, and this still does not make any sense to me.

public function ValidateEmail($email, $reemail){
/*
Sanatize.
User filter_var to validate.
Make sure both emails match.
Check if email already exists or not.
*/
  trim($email);
  strip_tags($email);
  mysql_real_escape_string($email);
  
  trim($reemail);
  strip_tags($reemail);
  mysql_real_escape_string($reemail);
  
if(!filter_var($email, FILTER_VALIDATE_EMAIL)){
  $this->valid = false;
  //Line 104 $this->error[] - "The E-Mail that you provided is not valid.";
} else {
  $this->valid = true;
}

if($email !== $reemail){
  $this->valid = false;
  $this->error[] = "The E-Mail's that you provided do not match.";
} else {
  $this->valid = true;
}
if(filter_var($email, FILTER_VALIDATE_EMAIL) && $email == $reemail){
  $checkmail = mysql_query("SELECT users.email, temp_users.email FROM users, temp_users WHERE email = '$email'");
  if(mysql_mum_rows($checkmail) == 1){
  // email is found, throw out error
  $this->valid = false;
  $this->error[] = "That E-Mail is already in use.";
  } else {
  $this->valid = true;
 }
}
  return $this->error;
}

Line 104 is commented out.

Thanks!

I just can't wrap my head around it, but I am trying to integrate weather into my website using NOAA.

1. Here is the NOAA page: http://forecast.weather.gov/MapClick.php?CityName=Mio&state=MI&site=APX&lat=44.663&lon=-84.1446
2. Here is the XML to that page: http://forecast.weather.gov/MapClick.php?lat=44.66300&lon=-84.14460&FcstType=dwml

Now what I want to do is to have PHP on my website that reads the XML from the NOAA site and create the "Forecast At A Glance". Possible or too challenging?

Hello, I'm trying to read some XML by name this is the XML:

Code: [Select]
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<imgdir name="01040000.img">
    <imgdir name="info">
        <canvas name="icon" width="29" height="30" basedata="iVBORw0KGgoAAAANSUhEUgAAAB0AAAAeCAYAAADQBxWhAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAMuSURBVEhLlZcBlatADEWxUAu1gAUs1AIWsIAFLGChFmphLXwL83ND3jQwlO5yTg6FmcnNSzLDbtf97io27Zv9ztOHWY3zZezKOHSl7/ud8Y6x1/IxoK+BOGwd+zIN99LfN4dnQGAVuG5zmD8Nt7I87u6D55SdU3jh2hZuwPK6lfJvKq9wmkH/nhtId+bPBvtZRgeOva219WQgZaEB++DjfqtQHArs9wjCnVkgCoZ1QIGhEuBgfvyyoJlPgKG6gn1AwKo0FjjcfisIqXOwAW83MysLqZ0MyD0r9Wy9a/6GKloBH7YYZx4plwUlqGBE70CZgVGaU4xifJ+pdZWkRw0AlGhx+JwDHmnNsN7GZahVioFLsac66ptTvKXFjNr0/bB1LvWxptqpCVUERaAC4hgo5kAbVxdL7THFNSUZiuPF1KvW+TdjlAKHgAVFicCoJtVqLvf93kZbWngxPMaqVGpwzsLcaAIKChgYUHxUxWquyCTzleK6TaZp9kUMKEJg7jwiBahtIZVZrXwo3Vp3VEobOyxDmQSw7rc4KDwjEUhOsdTiY56X6ktwZSKfED4Rk1Lvutir+XTxIy8aqnZudLHv14BmMM15PBxc6bI+a4SLPb/Mfsxstt95xhjDprCH3TGeee/1XNed2jOoR5ehcpDBGX4FPkJzyZrUCkp6z5RK7TelW9bWRm1z9qqeiupuCzF92vR505fm7MDQO5zj75jiBiqYmsj3KJ+naCR9VThVCEDj3POW4FlQ+fQT7qqRmMgiTpLnNOzA+qThmDHN4aSabe9iOnGkUh181rnevdlwxB4kZXIodfrQa85RtdQefF7+2eIKstJcP4BSmefxTor9UIk0f/0DKSb4YlSycPCvzvuPMaLXYc88zdV81fjP0FwrAcdxLJhvB4NltfzOSinHX6A7lR61qcxAg9reP1d7Udvv9VTU27e1gfaf1CrdufGimVhj294Dbq5ayw9AOx072a621FSW925AR7vb8dwBb8CeXprnuIXseTazE3BnzX7NezZ8EOQl1OsVRmRMxrLC4++r/2/wMYTCj+kl34CZICMlR5Oj4/u8ThD8NSn9D9wL1z9uxdBdAAAAAElFTkSuQmCC">
            <vector name="origin" x="-2" y="30"/>
        </canvas>
        <canvas name="iconRaw" width="29" height="29" basedata="iVBORw0KGgoAAAANSUhEUgAAAB0AAAAdCAYAAABWk2cPAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAL4SURBVEhLlZYBtYMwDEVnAQuzgAUsYAELWMACFrAwC7MwC99Cf27o6wJ0sO2cHAZNc/PStHC7ffdL5nZl30X64HUIPg+3NHS31LbtxnjG2HP+mNBlIg5bhjaN3T219zVgDQisAJfVB/+xa9Lc3z0G96E6VXjit05cgenZpPQ3pmcOGkF/jxWkK/6TwV7z4MChtbk2nwqEKhzAPtjfmwIloMB+zUl4MEtEyTAPKDBUAuwsjv8safxJMKsuYB8QsCjNExxu/5WE1DnYgE1jZstCaUcDco1KvVrvNX9Dla2AvU0mmGfKz5ISVDCyd6DMwCiNJUYxsWtqXSXlUQMAJVsCPqYMz2WNsNbGZahViYFLsZc6r28s8VoWM9ambbu1c1kfa6qNmqyKpEhUQAIDxRxo4+piqd2XuJQkQgk8m3qtdfzPGEtBQMCCokRgVFNqNZfHfm+jtSw86PqhKJUagjMxNpqAggIGBpQYRbGaK1cSf5W4bJNxnHwSA8oQmAfPmQLUtpDKqFYxVG7N2yuljR0WoTgBLPstHxRekZxILLHUEmOa5hJLcFUinhDuiEmpd13eq/F08SMvN1Tp3NzFvl8zNIJpzv3h4Ern5VEynO3+afYyM2+/co8xho3Zerti3PPc13NZNmprUM8uQhUggiP8DLyHxiU7lFZQyltTKrVXSteqLQe1h7NX66ms7jYR06tNrze9aWoHhp4RnHj7Eh+ggqmJfI/yesqNpLcKpwoJaJxr3BLcC6qYfsKdNRKOTOIkeYzdBqxXGoEZkw8n1WR7F9OJI5Xq4FrnevdGIxB7kJIpoNTpRS+fvWqp3cU8/WxxBVFpXD+AUhn9eCbFfqjkMl9+IGUHn4xKJnb+1nl/jJG9Dnv85Ct/rfHP0LhWAg7DkDDfDgaLavkflbIcv0A3Kj1rUxmBqkZN7cnaXq+nsl7frXVoTa3KHRvvU9duTiatzQlQ/pu1ZZ4s7t2voGRL8+y30If6HPZr3LPfAIuCX5wryV1+1QP6B07yxunYFCcQAAAAAElFTkSuQmCC">
            <vector name="origin" x="-2" y="30"/>
        </canvas>
        <string name="islot" value="Ma"/>
        <string name="vslot" value="Ma"/>
        <int name="reqJob" value="1"/>
        <int name="reqLevel" value="40"/>
        <int name="reqSTR" value="130"/>
        <int name="reqDEX" value="0"/>
        <int name="reqINT" value="0"/>
        <int name="reqLUK" value="0"/>
        <int name="incDEX" value="3"/>
        <int name="incMMP" value="10"/>
        <int name="incPDD" value="45"/>
        <int name="tuc" value="7"/>
        <int name="price" value="6700"/>
        <int name="cash" value="0"/>
    </imgdir>
Say I want to get reqJob and print it onto the page.

Also I would need to get the BaseData of the iconRaw canvas.

how can I read a url coming from another site by header('Location:')  command

[xml]<category id="SOCMENEURASTVICLEA" order="26800">Aus. Victoria League</category>[/xml]

I have the above xml, I can read the category id, order but I dont no how to read the value "Aus. Victoria League"


foreach($description->children() as $category) {
foreach($category->attributes() as $a => $b) {
echo "<br/> -------- ";
echo $a,'="',$b,"\"\n";
} 
echo "category name" . $category->asXML();
}


the asXML() i have no idea what that is but am guessing I need thats where the php function which returns the value needs to go
Thank you