PHP - How To Let Php Know Another Page Is Open?

hello dear phpfreaks

running linux opensuse 11.4 and mozilla

well - how can i donwload a site that i see with the mozilla-browser and afterwards open it with GIMP
whats the easiest way to do such thigns!?

love to hear from you
greetings
db1

This topic has been moved to Third Party PHP Scripts.

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

Hello there,

I'm trying to make when you click on a record, it opens another page with full details about this record

the code for it is

Code: [Select]
  <td><a href=\"user.php?id=".$row['id']."\">".$row['id']."</a></td>

and it's working right, but when it opens the other page, no records is shown about the user with that ID

So I figure the problem that I need to pass $row['id'] to my second page and make it search for it in the database

how can I do that?

here is the code from the second page (details of the record)

Code: [Select]

$dbObj = new DB();
$result = mysql_query("select * from users where id = '$userID'");
return $result;



$row = @mysql_fetch_array($result);
echo "<table width=98%>";       
        echo "<tr>";
echo "<td valign=\"top\" width=\"120px\">";
$rowid = $row['id'];
echo "<td valign=\"top\">";
echo "<table>
<tr>
<td valign=\"top\" class=\"searchtitle\">
".$row['fname']. '  ' .$row['mname']. '  ' .$row['lname']."
</td>
</tr>
<tr>
<td class=\"text\" valign=\"top\">
".$row['mobile']."
</td>
</tr>
<tr>
<td>
<a href=\"user.php?id=".$row['recruiterid']."\" class=\"link\">".$row['recruiterid']."</a>
</td>
</tr>
</table>";
echo "</td>";
echo "</tr>";
echo "</table>";

I'm trying to open a URL using fopen() and I keep getting this error:
Code: [Select]
Failed to open stream: Permission deniedI can not work out what is wrong, it's not a firewall as far as I can tell.

Not to say that this occurs in every php software out there, but I far too occasionally notice that the application is written with scattered php open and close tags, for instance

<?php if(true) ?>
<?php { ?>
Blah blah blah, because it's true
<?php } else { ?>
because it's not true
<?php } ?>

To me, it is extremely irritating.   Regardless, I see a lot of open source software written this way and I can't help but think that there must be some underlying reason for it.  Magento, for example, is written exactly in this manner.  The templates are infested with these opened and closed php snippets.  Obscurity is not security so I'm ruling security reasons out.  Maybe it is more efficient? -- But I couldn't understand why, if so.  It seems like that would put more of a drag on the system itself causing php to start and stop parsing continually and excessively, then again, I'm no expert in the field of memory consumption and other operating system complexities.   Honestly, in my opinion, it is stupid.  i would never write a program that way..   HEREDOCs are much more useful and eye pleasing than that awful <?php { ?>   I had the misfortune a few months ago when I purchased an invoicing/customer maintenance system that I didn't know was written for PHP 5.2 or something lower, one that allowed short tags; and thus short tags were used in the same manner as I've described.   Is this just plain disorganization or is there some deep-seated inner lining advantage that I'm not aware of?

Quesion: Show each movie in the database on its own page, and give the user links in a "page 1, Page 2, Page 3" - type navigation system. Hint: Use LIMIT to control which movie is on which page. I have provided 3 files: 1st: configure DB, 2nd: insert data, 3rd: my code for the question. I would appreciate the help. I am a noob by the way.

First set up everything for DB:

<?php
//connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//create the main database if it doesn't already exist
$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query, $db) or die(mysql_error($db));

//make sure our recently created database is the active one
mysql_select_db('moviesite', $db) or die(mysql_error($db));

//create the movie table
$query = 'CREATE TABLE movie (
        movie_id        INTEGER UNSIGNED  NOT NULL AUTO_INCREMENT,
        movie_name      VARCHAR(255)      NOT NULL,
        movie_type      TINYINT           NOT NULL DEFAULT 0,
        movie_year      SMALLINT UNSIGNED NOT NULL DEFAULT 0,
        movie_leadactor INTEGER UNSIGNED  NOT NULL DEFAULT 0,
        movie_director  INTEGER UNSIGNED  NOT NULL DEFAULT 0,

        PRIMARY KEY (movie_id),
        KEY movie_type (movie_type, movie_year)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die (mysql_error($db));

//create the movietype table
$query = 'CREATE TABLE movietype (
        movietype_id    TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
        movietype_label VARCHAR(100)     NOT NULL,
        PRIMARY KEY (movietype_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

//create the people table
$query = 'CREATE TABLE people (
        people_id         INTEGER UNSIGNED    NOT NULL AUTO_INCREMENT,
        people_fullname   VARCHAR(255)        NOT NULL,
        people_isactor    TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
        people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

        PRIMARY KEY (people_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Movie database successfully created!';
?>



********************************************************************
***********************************************************************

second file to load info into DB:



<?php
// connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//make sure you're using the correct database
mysql_select_db('moviesite', $db) or die(mysql_error($db));

// insert data into the movie table
$query = 'INSERT INTO movie
        (movie_id, movie_name, movie_type, movie_year, movie_leadactor,
        movie_director)
    VALUES
        (1, "Bruce Almighty", 5, 2003, 1, 2),
        (2, "Office Space", 5, 1999, 5, 6),
        (3, "Grand Canyon", 2, 1991, 4, 3)';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the movietype table
$query = 'INSERT INTO movietype
        (movietype_id, movietype_label)
    VALUES
        (1,"Sci Fi"),
        (2, "Drama"),
        (3, "Adventure"),
        (4, "War"),
        (5, "Comedy"),
        (6, "Horror"),
        (7, "Action"),
        (8, "Kids")';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the people table
$query  = 'INSERT INTO people
        (people_id, people_fullname, people_isactor, people_isdirector)
    VALUES
        (1, "Jim Carrey", 1, 0),
        (2, "Tom Shadyac", 0, 1),
        (3, "Lawrence Kasdan", 0, 1),
        (4, "Kevin Kline", 1, 0),
        (5, "Ron Livingston", 1, 0),
        (6, "Mike Judge", 0, 1)';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Data inserted successfully!';
?>



**************************************************************
****************************************************************

MY CODE FOR THE QUESTION:


<?php
$db = mysql_connect('localhost', 'root', '000') or
die ('Unable to connect. Check your connection parameters.');

mysql_select_db('moviesite', $db) or die(mysql_error($db));

//get our starting point for the query from the URL
if (isset($_GET['offset'])) {
   $offset = $_GET['offset'];
} else {
   $offset = 0;
}

//get the movie
$query  = 'SELECT
   movie_name, movie_year
FROM
   movie
ORDER BY
   movie_name
LIMIT ' . $offset . ' , 1';
$result = mysql_query($query, $db) or die(mysql_error($db));
$row = mysql_fetch_assoc($result);
?>
<html>
<head>
<title><?php echo $row['movie_name']; ?></title>
</head>
<body>
<table border = "1">
<tr>
<th>Movie Name</th>
<th>Year</th>
</tr><tr>
<td><?php echo $row['movie_name']; ?></td>
<td><?php echo $row['movie_year']; ?></td>
</tr>
</table>
<p>
<a href="page.php?offset=0">Page 1</a>,
<a href="page.php?offset=1">Page 2</a>,
<a href="page.php?offset=2">Page 3</a>
</p>
</body>
</html>

Some code from my pages ,   Page1 ( Redirecting page )

<html>
<title>login_redirect.</title>
body>

<form name="redirect" action="http://mysite/page2.php" method="post">
<input type="hidden" name="mac" value="$(mac)">
</form>

<script language="JavaScript">
<!--
document.redirect.submit();
//-->
</script>
</body>
</html>

Page 2 ( select product )

<?php


session_start();

ini_set('display_errors',1);
error_reporting(E_ALL); 

include '../lib/config.php';
include '../lib/opendb.php';

// get user mac adres from redirect post page1
$_SESSION['macid'] = $_POST['mac'];
// set $macid for other use ( maybe not needed, am learning )
$macid = $_SESSION['macid'];

// echo $macid does show mac adress, so variable is not empty here


if (!empty($_POST["submit"]))

{
$product_choice = $_POST['accounttype'];
$query= "SELECT AccountIndex, AccountCost, AccountName FROM AccountTypes WHERE AccountIndex='$product_choice'";
$result = mysql_query($query) or die('Query failed. ' . mysql_error()); 
while($row = mysql_fetch_array($result))
{
$_SESSION['AccountIndex'] = $row['AccountIndex'];
$_SESSION['AccountCost'] = $row['AccountCost'];
$_SESSION['AccountName'] = $row['AccountName'];
}


header('Location: page3.php');

}

// did leave out the other/html/form stuff here

Page 3 ( show Session variables )

<?php


ini_set('display_errors',1);
error_reporting(E_ALL); 

session_start();

print_r($_SESSION);

?>

Now, on page 3 i do see the right session varables, only the "macid" is empty.   why ?    

It might be a funny question, but I hope the pro can help me.

I want to use ?id= to display the other page/url instead of showing the full address due to certain reasons.

What do I mean is like there are 2 different static page e.g. main.php and subpage.php

I would like to use id to display as the url for subpage.php  i.e. main.php?id=1 actually is displaying subpage.php

Any idea?? Help!! Thanks!

I am new to website development. I can't figure out how to open a new tab for the following javasript. I went through related questions but nothing worked for me. I want the browser to open a new tab when someone clicks on the link (example.com) below. The code target="_blank doesn't work here... What code should I add and where should I place that code?  

Hi i have been working on a cow management program PHP based.
it works beautifull but now i'm stuck , and i hope i post it in the right forum.
On demand php has to generate an export.txt file with basic cow information (tag#, transponder#, Bdate)
this will be read by the parlour computer an Eprom based computer serial connected.

I finished the script and it creates a beautifull TXt file exxept it's php
http://localhost/tmp/test.php

if i open that URL in notepad, it prints the txt file:
Quote

DH9900010090000624000900002080
VH990001 Dairy Comp 305         20100203
DN99000200312008080003000020800030000303000300035 08000300357080003001940800030003308000300036020
VN99000200001034000014010052009112620100922201102 042001111706
VN99000200001061000009420032010032820100906????????2007120101
VN99000200001083000067850032010061720100927????????2002030706
VN99000200001104000055440052009062720100817201101 032002080605
VN99000200001116000078540042010083120110207????????2002082205
VN990002000011470000816800220101226????????????????2003010806
VN99000200001153000070120032010030420100906????????2003020305



but when i enter that URL in the sync.BAT nothing happends..

my question is, doe anyone know if there is a way to fool DOS for accepting a PHP url?.
OR is there a way for Apache to treat one TXT file as an PHP file?


my script:

Code: [Select]
<?php

//request sql cow info

$db_host = 'localhost';
$db_user = '';
$db_pwd = '';
$database = 'cowdbase';
$table = 'cows';


if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// sending query
$result = mysql_query("SELECT * FROM {$table}");
if (!$result) {
    die("Query to show fields from table failed");
}

//quiery alle info
$query="SELECT * FROM {$table}";
$result=mysql_query($query);

// hoeveel rijen zijn er?
$num=mysql_numrows($result);


//Type the header from the text file


echo "DH9900010090000624000900002080" . PHP_EOL ;
echo "VH990001 Dairy Comp 305         20100203" . PHP_EOL ;
echo "DN9900020031200808000300002080003000030300030003508000300357080003001940800030003308000300036020" . PHP_EOL ;



mysql_close();
$i=0;
while ($i < $num) {

$cowtag=mysql_result($result,$i,"cowTag");
$bdate=mysql_result($result,$i,"Bdate");
$group=mysql_result($result,$i,"group");
$alpro=mysql_result($result,$i,"Alpro_trans");


// LIST ALLE KOEIEN KOE VOOR KOE
///   unknown     cowtag     unknown-0000      #### Alpro tag     00   Group     20    Fresh dateyymmdd  20  Heatdate yymmdd, Drydate YYYYMMDD, Birthdate YYYYMMDD  Lactation number ##
echo "VN9900020000" . str_pad($cowtag, 4, "0", STR_PAD_LEFT) . "0000" . str_pad($alpro, 4, "0", STR_PAD_LEFT) . "00" . "$group" . "20" . "0000" . "????????????????" . "00000000" . "01" . PHP_EOL ;
$i++;
}
echo "EN" . PHP_EOL ;
echo "ZN" . PHP_EOL ;
?>

Hi,

I need to open an RTF File on client side. When user submit form, the system will write some data in database and at the end, it has to open an rtf file in order to user be able to print it. Any ideas?

Thanks

Hugo

I have an excel file with many rows and columns but depending on the user I need it to show only one row.
I am a php newbie.

I have a url like http://www.northplanet.co.uk/blog.php?empty_cache= and i want to use curl to run the url, when the url is accessed in the browser it clears the cache how can i make php access and run the url in the background?

I have this code:
$shell = new COM('WScript.Shell');
$shell->Run("C:\WINDOWS\system32\cmd.exe /K ".$ini['indexer']['command'], 0, false);

When it runs, it opens the command line, but then when it is done, it leaves the process open. How can I close it when the process is complete?

Hi Guys,   I have a Url which allows me to send sms to a number. The url usually asks for id , number and few other things. When I paste the url in browser and press enter it opens and a sms is sent.   Now I want to code in php a way to send sms without redirecting to that page. For e.g. I ask user his mobile number and then I should be able to call/run that url and a sms should be sent to his number. If I use php header then it redirects to that page. I have tried using file_get_contents and php cURL but it has not worked so far.   Can you guys help me out ?   Thank you,   Cheers, GR