Learn VBA & Macros in 1 Week!

PHP - Getting File Information

Full Excel VBA Course - Beginner to Expert

Getting File Information	View Content

Working on a music/video project. Uploaded tracks are stored in user files and product info is stored to DB. What I've been trying to figure out is getting the product information directly from the upload, much like you see in the shot attached. As I haven't had success with that, I've been trying to get the duration of a track using this code.
Code: [Select]
$fp = fopen($file, 'r');
$size_in_bytes = filesize($file);
fseek($fp, 20);
$rawheader = fread($fp, 16);
$header = unpack('vtype/vchannels/Vsamplerate/Vbytespersec/valignment/vbits',
$rawheader);
$tsec = number_format($size_in_bytes/$header['bytespersec'],2);
$minutes = intval(($tsec / 60) % 60);
$seconds = intval($tsec % 60);
$sec="$minutes".":".($seconds<10 ? "0$seconds" : "$seconds");This is working fine when file names are plain text, however it fails when when there are commas or brackets. I don't know if the code can be adjusted to work with these file names or I need to take a different approach.

Code: [Select]
examples $file ="A cool track, once again"; $file ="A cool track (once again)";
As artists can be picky about their music, I don't want to rename their tracks, but really we shouldn't even have spaces in the names. I could save original name to DB and rename the file, but not sure about restoring original when it come time to download the file. In any case, I hope you understand my problem and can offer some advice. Thanks.

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Pulling Information From File

Displaying Information From Flat File Db

Alphabetizing Text File Information

Upload File's Path Information?

How Do I Use And Gather Information From A Txt File That Has Been Uploaded?

Form Information Doesn't Transfer Over To Php File

Writing Db Contents To A File, Then Retrieving Information Via Php.

Store Submitted Information Into Text/php File.+o.q.

Reading File In A Textbox And Replacing The Information Within It After Saving

I Want To Add A Note Field And A Check Box To My Page And I Think I Want To Record This Information In A Json File.

How To Transfer Information A-web To B-web

Visitor Information

Getting Information From Db Array

Get Information From Array

Sending Information

Fetchin Information

Retrieving Information From Url..

Securing Information

Learn VBA & Macros for Excel in 1 Week!

Pulling Information From File

Similar Tutorials

Hi Everyone,

Let me start by saying i need any help put to me in dumb person terms, i know nothing but the bare bare basics of most web coding let alone php, enough to make very simple pages and forms.

On to my problem... What i am aiming for us a single web page which takes a list of names from a file, generates a 2 column table, makes the second column into boxes where data can be entered in to, then i want it to be submitted to email in the form of a html email, the email doesn't need any fancy formatting or colour scheme, just want the the table of names and entered information sent

Now this is how far i have got (with help obviously):
Code: [Select]
<body>
<h1 align="center"><u>7B Praise Points</u></h1>
<div id="contact-wrapper">
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" id="contactform">
<?php

$file = file("7B.txt");
$count = 0;
print "<table cellspacing='2'>\n
<tr><td>Student Name</td><td>Number of Praise Points</td></tr>\n";

foreach($file as $line){
$line = trim($line);
$split = split("\t",$line);
print "<tr>\n<td>$split[0]<input name='name$count' type='hidden' value='$split[0]'></td>\n<td>$split[1]<input name='points$count' type='hidden' value='$split[1]'></td>\n</tr>";
$count++;
}

print "</table>";

?>
<p>
<input name="submit" type="submit" value="Submit">
</p>
</form>
</div>
</body>

So i've got it generating the table from the list of names in the file called "7B.txt" all i need to be able to do is making the second column in to a data entry box and generating the email
Starting with the first problem of making the second column in to data entry boxes how do i go about doing this?

Thanks

Displaying Information From Flat File Db

Similar Tutorials

I want to make the news feed on my website easier to maintain. I just created a form that I will use to add the information. The form saves the files that it creates as "entry-date-time.txt" and places it in a folder for the year and a sub folder for the month. Such as "2011\09".

I have displayed data from a single flat file before, but I am unsure how to go about displaying the data from multiple files. Can anyone show me an example?

I want to be able to paginate the data, displaying a number of updates per page from newest to oldest.

I don't have MySQL access on the server or I'd just use that, instead.

Alphabetizing Text File Information

Similar Tutorials

I am new to PHP so I'm sorry if anything I ask isn't clear. I'm actually a writer, but my boss randomly decided I need to learn PHP so here I am

My first project is to take information from a simple HTML form that asks for users to fill out three text boxes, select if they are user 1 or user 2, and upload a file. I then have to store the information in a text file and display that information in the browser directly below the HTML form. The information must be ordered alphabetically by the first letter of whatever is entered in the first text box. Each entry must be on its own line.

For example:

Person 1 enters: Sally Mae Johnson User 1 Flowers.jpg
Person 2 comes along later and enters: George Michael Johnson User 2 books.jpg

Right now it displays in the order entered like this:
Sally Mae Johnson User 1 Flowers.jpg
George Michael Johnson User 2 books.jpg

I need it to display in alphabetical order by the first letter of the first name like this:
George Michael Johnson user 2 books.jpg
Sally Mae Johnson User 1 Flowers.jpg

I'm so close, but I just can't figure out how to finish it up. If anyone can help they'd be a life saver!
Here's what I wrote so far:

<body>
<?php
$fone = @$_POST["one"];
$ftwo = @$_POST["two"];
$fthree = @$_POST["three"];
$fselect = @$_POST["select"];

if ($_FILES)
{
   $name = $_FILES['upload']['name'];
   (move_uploaded_file($_FILES['upload']['tmp_name'], "uploads/$name"));
}

//write to the file

$values = "$fone\t";
$values .= "$ftwo\t";
$values .= "$fthree\t";
$values .= "$fselect\t";
$values .= "<img src='uploads/$name'><br />\n";

//open and write to the file

$fp = @fopen("store.txt", "a") or die("Couldn't open the file!");
$numBytes = @fwrite($fp, $values) or die ("Couldn't write values to file!");

@fclose($fp);
?>

<form action="test_it2.php" enctype="multipart/form-data" method="post">
Box 1: <input type="text" name="one" size="15" />
Box 2: <input type="text" name="two" size="15" />
Box 3: <input type="text" name="three" size="15" />
Select One: <select name="select"><option value="empty">Please Select</option><option value="user1">User 1</option>
<option value="user2">User 2</option>
<p>Upload a File:</p>
<p><input type="file" name="upload" />
<input type="hidden" name="MAX_FILE_SIZE" value="30000" />
<input type="submit" name="submit" value="submit" />
<input type="hidden" name="submitted" value="submitted" />
</p>
</form>
<?php

print "<P>Here are the users:<br />";
$file = "store.txt";

if (file_exists($file))
{
   $file1 = fopen("store.txt" , "r");
      while (!feof($file1))
      {
         $display = fgets($file1, filesize("store.txt"));
         echo $display . "
         ";
         }
         fclose($file1);
         }
         else
         {
            echo "<P>Error occured! Please try again!</p>";
         }

?>
</body>
</html>

Upload File's Path Information?

Similar Tutorials

Is there a way to get the source path for an uploaded file?

It seems that's a function of the browser and the two I've tried FF and Safari don't return it in $_FILES['file']['name'].

How Do I Use And Gather Information From A Txt File That Has Been Uploaded?

Similar Tutorials

Ok Basically I need to know how to do this:

I upload a txt file that contains this:

Code: [Select]
"MLE ",20,"2057NALL ","ND ","Amber for 2057 1 ","!Amber for 2057 ",00003.65,00001.02
"MLE ",20,"211-2 ","D ","Dome-Courtesy 10 ","!Dome-Courtesy 1 ",00001.60,00000.61

How would I get Information from each different line like the below:

Code: [Select]
2057NALL | Amber for 2057 1 | 00003.65 | 00001.02
211-2 | Dome-Courtesy 10 | 00001.60 | 00000.61

Any help on this subject would be greatly appreciated.

PhotonicCoder

Form Information Doesn't Transfer Over To Php File

Similar Tutorials

Hey everyone,

I don't know what i'm doing wrong or missing some code snippet (duh! thats why i'm here. lol). The html form with meeting time doesn't transfer the information over to my calendar php file.
calendar.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Lab 5</title>

<link rel="stylesheet" type="text/css" href="settings.css" />
<meta http-equiv="content-type"
content="text/html; charset=iso-8859-1"/>
</head>

<body>
<center>
<form method="get" action="calendar.php">
Student Name: <input type="text" name="name"/>
<input type="submit" value="Submit" />
<input type="reset" value="Clear" />
</center>
<p align="center">Today is
<?php
print(date("l, F\ jS\ Y"));
?>
</p>

<?php
$date = time();

$day = date('d', $date);
$month = date('m', $date);
$year = date('Y', $date);

$first_day = mktime(0,0,0,$month, 1, $year);

$title = date('F', $first_day);
$day_of_week = date('D', $first_day);

switch($day_of_week){

case "Sun": $blank = 0; break;
case "Mon": $blank = 1; break;
case "Tue": $blank = 2; break;
case "Wed": $blank = 3; break;
case "Thu": $blank = 4; break;
case "Fri": $blank = 5; break;
case "Sat": $blank = 6; break;
}

$days_in_month = cal_days_in_month(0, $month, $year);

//Table starts here
echo "<table border=1 cellpadding=10 align=center height=500 width=494>";

echo "<tr><th colspan=7> $title $year </th></tr>";
echo "<tr><td width=42>Su</td>
<td width=42>Mo</td>
<td width=42>Tu</td>
<td width=42>We</td>
<td width=42>Th</td>
<td width=42>Fr</td>
<td width=42>Sa</td></tr>";

//Days in week
$day_count = 1;

echo "<tr>";

// blank days
while ( $blank > 0 )
{
echo "<td></td>";
$blank = $blank-1;
$day_count++;
}

//Set the first day of the month
$day_num = 1;

//This while loops works while there are still days in that month

while ( $day_num <= $days_in_month )
{
echo "<td> $day_num </td>";
$day_num++;
$day_count++;

//Starts new row for every week
if ($day_count > 7)
{
echo "</tr><tr>";
$day_count = 1;
}
}
//Finaly we finish out the table with some blank details if needed
while ( $day_count >1 && $day_count <=7 )
{
echo "<td> </td>";
$day_count++;
}
echo "</tr></table>";
?>
<a href="http://helios.ite.gmu.edu/~easad/IT207/Lab5/DecCal.php" target="info">Next Month</a>
<p>
    <a href="http://validator.w3.org/check?uri=referer"><img
        src="http://www.w3.org/Icons/valid-xhtml10"
        alt="Valid XHTML 1.0 Strict" height="31" width="88" /></a>
  </p>

</body>
</html>

MeetingTime.html
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>

<link rel="stylesheet" type="text/css" href="settings.css" />
<meta http-equiv="content-type"
content="text/html; charset=iso-8859-1"/>
<title>Meeting Time Sign Up</title>
</head>
<body>
<h1> Meeting Time Setup Form</h1>
<form method="get" action="calendar.php">
<table border="1" cellpadding="15" width="75%">

<tr><td width=42>Day: </td>
<td width=42><input type="checkbox" name="available" value="Mon" />Monday</td>
<td width=42 ><input type="checkbox" name="available" value="Tue" />Tuesday</td>
<td width=42 ><input type="checkbox" name="available" value="Wed" />Wednesday</td>
<td width=42 ><input type="checkbox" name="available" value="Thr" />Thrusday</td>
<td width=42 ><input type="checkbox" name="available" value="Fri" />Friday</td></tr>
<tr><td width=42 >Time: </td>
<td width=42 >
<p><select multiple="multiple" size="3" style="width: 180%;">
<option>7:00am</option>
<option>7:00am</option>
<option>7:30am</option>
<option>8:00am</option>
<option>8:30am</option>
<option>9:00am</option>
<option>9:30am</option>
<option>10:00am</option>
<option>10:30am</option>
<option>11:00am</option>
<option>11:30am</option>
<option>12:00pm</option>
<option>12:30pm</option>
<option>1:00pm</option>
<option>1:30pm</option>
<option>2:00pm</option>
<option>2:30pm</option>
<option>3:00pm</option>
<option>3:30pm</option>
<option>4:00pm</option>
<option>4:30pm</option>
<option>5:00pm</option>
<option>5:30pm</option>
<option>6:00pm</option>
<option>6:30pm</option>
<option>7:00pm</option>
<option>7:30pm</option>
<option>8:00pm</option>
<option>8:30pm</option>
<option>9:00pm</option>
<option>9:30pm</option>
<option>10:00pm</option>

</select></p>
</td>
<td width=42 >
<p><select multiple="multiple" size="3" style="width: 180%;">
<option>7:00am</option>
<option>7:30am</option>
<option>8:00am</option>
<option>8:30am</option>
<option>9:00am</option>
<option>9:30am</option>
<option>10:00am</option>
<option>10:30am</option>
<option>11:00am</option>
<option>11:30am</option>
<option>12:00pm</option>
<option>12:30pm</option>
<option>1:00pm</option>
<option>1:30pm</option>
<option>2:00pm</option>
<option>2:30pm</option>
<option>3:00pm</option>
<option>3:30pm</option>
<option>4:00pm</option>
<option>4:30pm</option>
<option>5:00pm</option>
<option>5:30pm</option>
<option>6:00pm</option>
<option>6:30pm</option>
<option>7:00pm</option>
<option>7:30pm</option>
<option>8:00pm</option>
<option>8:30pm</option>
<option>9:00pm</option>
<option>9:30pm</option>
<option>10:00pm</option>
</select></p></td>
<td width=42 >
<p><select multiple="multiple" size="3" style="width: 180%;">
<option>7:00am</option>
<option>7:30am</option>
<option>8:00am</option>
<option>8:30am</option>
<option>9:00am</option>
<option>9:30am</option>
<option>10:00am</option>
<option>10:30am</option>
<option>11:00am</option>
<option>11:30am</option>
<option>12:00pm</option>
<option>12:30pm</option>
<option>1:00pm</option>
<option>1:30pm</option>
<option>2:00pm</option>
<option>2:30pm</option>
<option>3:00pm</option>
<option>3:30pm</option>
<option>4:00pm</option>
<option>4:30pm</option>
<option>5:00pm</option>
<option>5:30pm</option>
<option>6:00pm</option>
<option>6:30pm</option>
<option>7:00pm</option>
<option>7:30pm</option>
<option>8:00pm</option>
<option>8:30pm</option>
<option>9:00pm</option>
<option>9:30pm</option>
<option>10:00pm</option>
</select></p></td>
<td width=42>
<p><select multiple="multiple" size="3" style="width: 180%;">
<option>7:00am</option>
<option>7:30am</option>
<option>8:00am</option>
<option>8:30am</option>
<option>9:00am</option>
<option>9:30am</option>
<option>10:00am</option>
<option>10:30am</option>
<option>11:00am</option>
<option>11:30am</option>
<option>12:00pm</option>
<option>12:30pm</option>
<option>1:00pm</option>
<option>1:30pm</option>
<option>2:00pm</option>
<option>2:30pm</option>
<option>3:00pm</option>
<option>3:30pm</option>
<option>4:00pm</option>
<option>4:30pm</option>
<option>5:00pm</option>
<option>5:30pm</option>
<option>6:00pm</option>
<option>6:30pm</option>
<option>7:00pm</option>
<option>7:30pm</option>
<option>8:00pm</option>
<option>8:30pm</option>
<option>9:00pm</option>
<option>9:30pm</option>
<option>10:00pm</option>
</select></p></td>
<td width=42 >
<p><select multiple="multiple" size="3" style="width: 180%;">
<option>7:00am</option>
<option>7:30am</option>
<option>8:00am</option>
<option>8:30am</option>
<option>9:00am</option>
<option>9:30am</option>
<option>10:00am</option>
<option>10:30am</option>
<option>11:00am</option>
<option>11:30am</option>
<option>12:00pm</option>
<option>12:30pm</option>
<option>1:00pm</option>
<option>1:30pm</option>
<option>2:00pm</option>
<option>2:30pm</option>
<option>3:00pm</option>
<option>3:30pm</option>
<option>4:00pm</option>
<option>4:30pm</option>
<option>5:00pm</option>
<option>5:30pm</option>
<option>6:00pm</option>
<option>6:30pm</option>
<option>7:00pm</option>
<option>7:30pm</option>
<option>8:00pm</option>
<option>8:30pm</option>
<option>9:00pm</option>
<option>9:30pm</option>
<option>10:00pm</option>
</select></p></td>;
</tr>
</table>

</br>

<input type="reset" value="Clear" />
<input type="submit" value="Submit" />
<input type="hidden" value="newuser" />
</form>

</body>
</html>

Writing Db Contents To A File, Then Retrieving Information Via Php.

Similar Tutorials

I'm going to be blunt, I've been working on a website for quite some time now and I never really stopped to think about the effects that an over abundant amount of queries could actually slow things down. I'm quite new to the whole PHP / MySQL thing so I am still learning.

While reading through some things about optimization of queries I've learned some valuable information, such as working with Indexes, and not running unnecessary queries which the data doesn't seem to change that often.

So for a few aspects of my site which don't really change in particular periods of time, I've decided to write the contents of them into a text file then retrieve and display them as normal through my site. Things that last an hour, or a day, will no longer be queries on each page load; tremendously reducing the amount of queries which my database would take.

Currently I have the following code:
if($database->numrows($query) > 0) {
        $myFile = 'testFile.txt';

    if($fh = fopen($myFile, 'w')) {
        $i = 0;
        while($row = $database->fetchassoc($query)) {
            ++$i;
            $stringData = '' . $row['id'] . '--' . $row['name'] . '--' . $row['color'] . '--' . $row['bdaytest'] . '--' . $row['gmtoffset'] . "\n";
            fwrite($fh, $stringData);

        }
    fclose($fh);
    }
}

Which Prints Out

Quote

32--User3--0--1939-10-03--+0.0
27--User7--0--1979-10-04--+17.0
28--User65--150--1969-10-05--+17.0
30--User1--0--1959-10-06--+6.0
31--User9--0--1949-10-07--+3.0
29--User5--0--1989-10-08--+17.0

The problem stems from pulling the information from the file and exploding it. That file would be for yesterday's up to 7 days from now's birthdays.

The amount of lines could change, possibly messing up the possibility of an array.

I was thinking about pulling the information into an array, than exploding it from within that array, posting it to variables.. and then have it display all in a while.

Am I on the right track, or is there some other alternative I can use? Only data that will always be visible on the website, will be held in these text files.

Any suggestions on how I pull the information from the text file and explode it to display exactly how I need it to be displayed?

Store Submitted Information Into Text/php File.+o.q.

Similar Tutorials

Hello!

I have a 2 questions:

Q1: How do you store answers from a php file(see code below) into another file?(php preferably)
I know it would probably be easier using a database, but I would like to know how to do it with a text/php file.
Below you can see a piece of code for a page students would go on to fill in online exercices. They would first have to input their names. These names would have to be sent to a php file called "StudentAnswers.php". As well as their answers I also have another file that is called "QandA.php" which is called on with include in the piece of code below so the students can't see the answers before they submitted their answers.
Q2: But how do I complete the if code(see question marks) so the answer only shows IF(as soon as) they clicked on the submit button?

Code: [Select]
<html>
<body>
<h2>Exercices</h2>
<p>
<form name="input" action="StudentAnswers.php" method="get">
Student name: <input type="text" name="user" />
</form>
</p>
<p>
What is the gradient of T(x,y)=2x+3?
<form name="input" action="StudentAnswers.php" method="get">
<input type="text" name="1b" />
<input type="submit" value="Input answer"/>
</form>

if ( ????????? ) {
???????";
}
<?php include("QandA.php");
echo $Question["1b"];?>
<p>
</body>
</html>
B

Reading File In A Textbox And Replacing The Information Within It After Saving

Similar Tutorials

From what I have so far is that I am reading a text file into a textbox. Now I want to update/append new information to my file(the information may contain HTML/PHP code, text etc.) after I click the save button so the contents can be read on a separate page called "edit.php". Any suggestions? (My first time using PHP on a higher level)

The following is written in my editcontent1.php(I'm seperating each content block on my edit.php page into several editcontent(n).php files where n is = 1 to infinity)

Here is before the html tags:
<?php
if ( isset ($_POST ['content']) )
{
file_put_contents ('content1.txt', $_POST ['content'] );
}
?>

Here is before the html tags:
Code: [Select]
<form action = "edit.php" method="post">
<textarea name="content" cols="" rows="" wrap="virtual" class="textarea1">
<?php include 'content1.txt'; ?>
</textarea>
<br />
<input type="submit" value="Save">
</form>

I Want To Add A Note Field And A Check Box To My Page And I Think I Want To Record This Information In A Json File.

Similar Tutorials

I want to add a note field and a checkbox to my list/grid page and save this information to a json file using uomptrucknumber as the key. The note information will be information for the whole truck not by order. The check box will let them know that the truck is ready to have paper work printed.

I have not add the note field or checkbox because I did not want to start off wrong.

echo "<table>";
echo "<tr style='background:#82fbfd'>";

echo "<th>ShipDate</th>";
echo "<th>ShipMeth</th>";
echo "<th>Name</th>";
echo "<th>LoadID</th>";
echo "<th>Drop</th>";
echo "<th>OrderID</th>";
echo "<th>Status</th>";
echo "<th>FGI</th>";
echo "<th>FGM</th>";
echo "<th>TotalBox</th>";
echo "<th>Cubes</th>";
echo "<th>Total</th>";
echo "<th>Notes \n</th>";
//echo "<table>"; 
echo "<tr style='background:#82fbfd'>";

$result =odbc_exec($connect,$sql);
if(!$result){
exit("Error in SQL");
}


	
function ShowDetail($row){
       
    if($row['ompclosed']==-1){

        $theColor="#AAF0D2";
            }else{
                $theColor="#FFFFFF";

            }
     if($row['ompclosed']==0 && $row['date'] < date("m/d/Y")) {
        $theColor="#FF0000";
     }    
     
        
		echo "<tr style='background-color :$theColor'><td>" .$row['date'] ."</td>";
        echo "<td>" .$row['ompshippingmethodid'] ."</td>";
        echo "<td style='text-align:left'>" .$row['cmoname'] ."</td>";
        echo "<td>" .$row['uomptrucknumber'] ."</td>";
		echo "<td>" .$row['uompdropsequence'] ."</td>";
        echo "<td>" .$row['ompsalesorderid'] ."</td>";
        echo "<td>" .$row['ompclosed'] ."</td>";
        echo "<td>" .round($row['FGIqty'],0) ."</td>";
        echo "<td>" .round($row['FGMqty'],0) ."</td>";
        echo "<td>" .round($row['uomptotalboxcount'],0) ."</td>";
        echo "<td>" . number_format($row['uompvolumetotal'],2) ."</td>";
        echo "<td>" .  number_format($row['ompordertotalbase'],2) ."</td>";
        echo "<td style='text-align:left'>" .$row['ompordercommentstext'] ."</td></tr>" ;
			  }
			  

	
//****************************************************************

while ($row = odbc_fetch_array($result))
{
    if($row['ompclosed']==-1){

        $theColor="#AAF0D2";
            }else{
                $theColor="#FFFFFF";

            }
     if($row['ompclosed']==0 && $row['date'] < $today) {
        $theColor="#FF0000";
     }    

    if($row['uomptrucknumber'] != $loadid) {
        
        if ($loadid !== 0) {
            echo "<tr style='background:#eee'>
                     <td colspan='7'>TOTAL</td>
                     <td>$TotalFGI</td>
                     <td>$TotalFGM</td>
                     <td>&nbsp;</td>
                     <td>&nbsp;</td>
                  
                     <td>$loadTotal</td>
                   
                  </tr>";
        } 
        
       
      
        $TotalFGI=0;
        $TotalFGM=0;
        $loadTotal=0;
    }

    ShowDetail($row);
    $loadid = $row['uomptrucknumber'];
    $TotalFGI+=round($row['FGIqty'],0);
    $TotalFGM+=round($row['FGMqty'],0);
	$loadTotal +=$row['ompordertotalbase'];
   
    
   
}    
echo "<tr style='background:#eee'>
         <td colspan='7'>TOTAL</td>
         <td>$TotalFGI</td>
         <td>$TotalFGM</td>
         <td>&nbsp;</td>
         <td>&nbsp;</td>
         <td>$loadTotal</td>
      </tr>
      </table>";
	
		

odbc_close($connect);

?>

Tv-information

Similar Tutorials

This is my school project "tv-info" that uses simple_html_dom. My tv.php

// scrape a tag
$html = file_get_html("http://www.ampparit.com/tv-opas?g=peruskanavat-1");
foreach($html->find($tag) as $e)
$main = $e->plaintext . '<br />';
	
//plain
	
$html = file_get_html("http://www.ampparit.com/tv-opas?g=peruskanavat-1");
echo $html->find('[table class="fullwidth"]', 1)->innertext.'</table>';

So my problem is how I can remove some tags in this page? It shows too much things and what I want it is show only tv-table.. There is inside this this tv table like this:

<table class="content-layout">
                <tr>
                    <td id="content" class="content"><div class="submenu-top-container">
    <form action="haku" class="right" style="margin-top: 5px;">
        <div class="input-wrapper">
            <input type="text" name="q" placeholder="Kirjoita hakusana..." style="width: 165px;"><input type="hidden" name="t" value="tv"><button>Hae</button>
        </div>
    </form>

    
    <div class="submenu-top-item selected">
        <a href="/tv-opas" class="submenu-top-item-link">Ohjelmaopas</a>
    </div>

    
    <div class="submenu-top-item ">
        <a href="/tv-opas?g=suosikkikanavat" class="submenu-top-item-link">Suosikkikanavat</a>
    </div>

    <div class="submenu-top-item ">
        <a href="/tv-opas?g=peruskanavat-1&amp;ss=movies" class="submenu-top-item-link">Elokuvat</a>
    </div>

    <div class="submenu-top-item ">
        <a href="/tv-opas?g=peruskanavat-1&amp;ss=sports" class="submenu-top-item-link">Urheilu</a>
    </div>

    <div class="submenu-top-item ">
        <a href="/tv-opas?g=peruskanavat-1&amp;ss=favorites" class="submenu-top-item-link">Suosikit</a>
    </div>
</div>

Thank you if someone can help me! And if someone ask me to use tvrage, I don't because I'm from Finland and there is no support for Finnish tv-series etc..

Ip Information

Similar Tutorials

Not so much of a programming problem as such but if I add the ability to recover accounts via IP address, is it possible to spoof an IP address? Is it a bad idea to automatically allow a user to reset a password if their IP (according to PHP) matches the IP that created the account?

How To Transfer Information A-web To B-web

Similar Tutorials

Hi there,

How to work out??

We have our web page where we enter our client information.. Part A

Than same information we have to enter third party web page. Part B

How can we transfer same information fr our web page to third party web page like .. Input in text field instead of type each box…

Please if someone can guide us or any link to follow…

Visitor Information

Similar Tutorials

Is there a good how to out there on how to create a code that will tell me where a page visitor is from? Similiar to google analytics, I'd like to find out where a visitor is from but I need this information before the page loads. I've tried googling but all I come up with are sites that offer the service if I sign up with them.

Also, I have a list of zip codes / cities in an excel spreadsheet .. I'd like to get this into a db table but don't want to type each one out for the next month. How could I do this? My host is godaddy on a linux box with mysql 5.X if that helps.

Thank you

Getting Information From Db Array

Similar Tutorials

Hi all,

I have an array $n[] and have made a DB query with fetch_array ($result[]). Now I'm trying to get the information out of the $result[] with $n[] so I made the following and it doesn't work. I checked if they're filled and they are and when I enter in the $result[] array with hardcoded info I do get what I need but I need it trough the array...
Can anyone help me out??

Thnx Ryflex
$sql = "SELECT * FROM units WHERE member_id = '$member_ID'";
$result = mysql_fetch_array(mysql_query($sql)) or die("Could not find amount of troops");
$troop_one = $result['$n[0]'];
$troop_two = $result['$n[1]'];
$troop_three = $result['$n[2]'];
$troop_four = $result['$n[3]'];

Get Information From Array

Similar Tutorials

Dear All,

How can I get information that return from this array

Array ( [0] => Array ( [id] => 5 [t_test_date] => 2021-02-11 [t_test_number] => 1 [t_uid] => 202102110001 [t_test_type] => 1 [t_status_id] => 4 [t_test_result_pcr] => 1 [t_test_result_rdt] => 0 [t_test_time] => 2021-02-11 11:39:00 [t_report_date] => [p_first_name] => tesdt [p_last_name] => tesdt [p_gender] => 0 [p_nationality] => [p_date_birth] => [p_passport_no] => [p_personal_id] => [p_issue_country] => [p_date_expiry] => [phone] => [email] => [t_price] => 0 [p_valid] => 1 [created_date] => 2021-02-11 [modified_date] => 2021-02-11 11:40:18 [t_status_type] => ຂັ້ນຕອນທີ່ 4. ອອກການຢັ້ງຢືນ [t_status_typeEng] => Stage 4. Certificate Issued [t_status] => 4. ຢັ້ງຢືນແລ້ວ [t_statusEng] => 4. Issued [test_time] => 11/02/2021 11:39 ) [1] => Array ( [id] => 7 [t_test_date] => 2021-02-11 [t_test_number] => 3 [t_uid] => 202102110003 [t_test_type] => 2 [t_status_id] => 4 [t_test_result_pcr] => 1 [t_test_result_rdt] => 1 [t_test_time] => 2021-02-11 18:38:00 [t_report_date] => [p_first_name] => Hhh [p_last_name] => Tttt [p_gender] => 0 [p_nationality] => [p_date_birth] => [p_passport_no] => [p_personal_id] => [p_issue_country] => [p_date_expiry] => [phone] => [email] => [t_price] => 0 [p_valid] => 1 [created_date] => 2021-02-11 [modified_date] => 2021-02-11 18:38:51 [t_status_type] => ຂັ້ນຕອນທີ່ 4. ອອກການຢັ້ງຢືນ [t_status_typeEng] => Stage 4. Certificate Issued [t_status] => 4. ຢັ້ງຢືນແລ້ວ [t_statusEng] => 4. Issued [test_time] => 11/02/2021 18:38 ) );

Sending Information

Similar Tutorials

Can someone help me send a value in a form to another page...(value=$emailhim)

This is the sending page
Code: [Select]
<?php
  $emailit = $_GET['emailusr'];
echo"
            <table width='602' height='283' border='0'>
               <form action='emailuser.php' method='POST'>
              <tr>
                <td width='210' height='13'>You Are Contacting:</td>
                <td width='382' align='left'><input type='text' name='emailnow' value='$emailit' disabled='disabled'/></td>
                </tr>
              <tr>
                <td width='210' height='14'>Book Title:</td>
                <td width='382' align='left'><input type='text' name='book' maxlength='25'/></td>
                </tr>
              <tr>
                <td width='210' height='14'>ISBN Number: </td>
                <td align='left'><input type='text' name='isbn' maxlength='25'/></td>
              </tr>
              <tr>
                <td width='210' height='15'>My Email:</td>
                <td align='left'><input type='text' name='myemail' maxlength='25'/></td>
              </tr>
              <tr>
                <td height='123' align='left'>Question/Comment:</td>
                <td><textarea name='question' cols='60' rows='5'></textarea></td>
                </tr>
              <tr>
                <td colspan='2' align='center'><input type='submit' name='submit' value='Send' /></td>
                </tr>
                 </form>
            </table>"
?>

This is the receiving page
Code: [Select]

$book = $_POST['book'];
$isbn = $_POST['isbn'];
$myemail = $_POST['myemail'];

if ($_POST['submit'])
{

//existance check
if ($book)
{
if ($isbn)
{
if ($myemail)
{
$question = $_POST['question'];
$username = $_SESSION['username'];
$emailhim = $_POST['emailnow'];

//connect to database
$connect = mysql_connect("db","user","pass") or die("Not connected");
mysql_select_db("user") or die("could not log in");

//grab email from database
$query = "SELECT * FROM desiredusers WHERE username='$emailhim'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))

//set email to variable name
$person = $row['email'];

//set SMTP
//$server = "smtp.gmail.com";
//ini_set("SMTP",$server);

//setup variables
$to = "butters4life24@gmail.com";
$subject = "$username has a question";
$body = "This is an email from $username\n\n
Their question regarding $book, ISBN#: $isbn\n
is $question\n\n\n
This is the email address $username would like you to contact him on: $myemail\n\n\n";
$headers = "From: $myemail";
mail($to, $subject, $body, $headers);
echo "$person";
echo "$emailhim";

}
else
die('Please fill in My Email. This will be the email address that the user that you are contacting will email you back on. (*note if you do not put in your correct email the person that you emailed will have no way of emailing you back)');
}
else
die('Please fill in ISBN Number.');
}
else
die('Please fill in Book Title.');
}

?>

Fetchin Information

Similar Tutorials

i need someone tohelp me build a script that will fetch infomration on a website, and automatically input it into a database. I know its possible i have reaserached it, and it can be done by using the $curl php technique.
it is not a coplicated job i just dont have time for it.

i need the script to access diffrent website, at a specific time of day.

i want the sript to automaticlly fetch the data from each site at a spesific time during the day.

i really dont know where to start... any help will be apprecited.
I managed to come up with this, but it does not do what i want

Code: [Select]
<?php

class tagSpider
{

var $crl; // this will hold our curl instance
var $html; // this is where we dump the html we get
var $binary; // set for binary type transfer
var $url; // this is the url we are going to do a pass on

function tagSpider()
{
$this->html = "";
$this->binary = 0;
$this->url = "";
}

function fetchPage($url)
{

$this->url = $url;
if (isset($this->url)) {

$this->ch = curl_init (); // start cURL instance
curl_setopt ($this->ch, CURLOPT_RETURNTRANSFER, 1); // this tells cUrl to return the data
curl_setopt ($this->ch, CURLOPT_URL, $this->url); // set the url to download
curl_setopt($this->ch, CURLOPT_FOLLOWLOCATION, true); // follow redirects if any
curl_setopt($this->ch, CURLOPT_BINARYTRANSFER, $this->binary); // tell cURL if the data is binary data or not
$this->html = curl_exec($this->ch); // grabs the webpage from the internet
curl_close ($this->ch); // closes the connection
}
}

function parse_array($beg_tag, $close_tag) // this function takes the grabbed html and picked out the pieces we want
{
preg_match_all("($beg_tag.*$close_tag)siU", $this->html, $matching_data); // match data between specificed tags
return $matching_data[0];
}

}
?>

Retrieving Information From Url..

Similar Tutorials

i have had a difficult time trying to work this out.I need to do some pattern matching for certain urls and retrieve information from it.
For example,
$url=http://www.test.com/showpic.php?do=showpic&u=89165&a=34933

if $url contains the value showpic.php,then i need to retrieve the following
{
$u=value of u(i.e. 89165 in this case)
$a=value of a(i.e. 34933 in this case)
}
else do nothin..

the format of the url will always be the same as above if it contains showpic.php

Securing Information

Similar Tutorials

Hello,

I'm writing an application that will have to interact with my webserver and it will be using php to input data into the database and retrieve from as well. However, I'm not sure what is the best approach on securing my database from people sniffing while using my application. The only thing that I can do that is coming to mind is try to use a unique key as a password and have one of my GET vars be that password, but that is easily sniff-able.

What can I do to secure my database and prevent people from filling up my databases if they sniff out my password key? Is there any kind of encryption I can use that will defeat this?