It means the webserver doesn't have permission to write to the "Uploads" folder that you created. The webserver runs as a different user, so you will need to change permissions on the folder or chown (change ownership) of the folder to the webserver.
Are you sure it is returning a result? I don't think an empty result will cause it to die. So what I mean is that for some reason there is no result for either query, therefore they are the same result...
Then I would like to see if my server allow .htaccess override... so to check this... I've written a simple command in .htaccess Redirect /google.html http://www.google.com
Where you used Redirect /google.html http://www.google.com. Redirect is an apache directive. If you go here you will see that it clearly states Module: mod_alias.
I don't see any spot in your origional post where you actually used mod_rewrite. At any rate I am glad you have had some success :)
There is a little bit of delay from when you make your 10th post to when you can actually add the signature (not sure why). So if you view your control panel now you should able to see where to add your sig. If not today then definitley by tomorrow
Just for kicks try searching yahoo or msn. Their results are not so geared towards backlinks and since the 2.0 modrewrite version (if it exists) is newer it won't have as many backlinks.
Do you have the GUI MySQL Administrator? If not download it.
Log in to the Administrator. On the left side choose startup variables. Then on the right side at the top choose the security tab. Click on 'Use old qasswords'. Then restart your MySQL Instance. You may also need to create another database...
I'm assuming you want this in insertbooking.html, but you will need to make it a php file as well so you will have to change the name. I'm also assuming that you have only 2 columns in your passenger table, so if you have more you will have to change $row[0] or $row[1] to the appropriate $row, also make sure passengertable is changed to the name of the table holding your passenger data. Don't expect this to work straight out as I don't have an oracle db to test on and I can never write code the first time without errors :p , but you should be able to see how to do it with some slight modification.
GL
<?php
// connect to database
putenv("ORACLE_SID=area");
if ($Connection = ocilogon("u2o30", "u2o30"))
{
// assemble query
$Sql = "SELECT * FROM passengertable"; // passengertable should be changed to
//the table that holds your passenger data
// parse it
$Statement = ociparse($Connection, $Sql);
if ($Statement)
{
if (ociexecute($Statement))
{
$stuff=ocifetchstatement ($Statement, &$arr, 0, 20, OCI_FETCHSTATEMENT_BY_ROW);
foreach($arr as $key => $row)
{
$optionlist.= "<option value=\"$row[0]\">$row[0]/$row[1]";
}
}
}
?>
<body>
<u>Book A Flight</u><br>
<form action="insertbooking.php" method="post">
<table width="80%" border="0" cellspacing="2">
<tr>
<td>Booking ID (B000):</td>
<td><input name="BookingID" type="text" size="30" maxlength="30" /></td>
</tr>
<tr>
<td>Passenger ID (0000):</td>
<td>
<select name="RouteID">
<?php echo($optionlist); ?>
</select>
</td>
</tr>
<tr>
<td>Flight ID (F000):</td>
<td><input name="FlightID" type="text" size="30" maxlength="30" /></td>
</tr>
<tr>
<td>Route ID:</td>
<td><select name="RouteID">
<option value="01">East Midlands to London Heathrow</option>
<option value="02">East Midlands to London Gatwick</option>
<option …
Have you been able to make a connection to the oracle database with php. That is the first hurdle you must pass. If not, try adapting the script on this page to work on your server.
<?php
// script from http://us3.php.net/manual/en/function.ocilogon.php
echo "<pre>";
$db = "";
$c1 = ocilogon("scott", "tiger", $db);
$c2 = ocilogon("scott", "tiger", $db);
function create_table($conn)
{
$stmt = ociparse($conn, "create table scott.hallo (test varchar2(64))");
ociexecute($stmt);
echo $conn . " created table\n\n";
}
function drop_table($conn)
{
$stmt = ociparse($conn, "drop table scott.hallo");
ociexecute($stmt);
echo $conn . " dropped table\n\n";
}
function insert_data($conn)
{
$stmt = ociparse($conn, "insert into scott.hallo
values('$conn' || ' ' || to_char(sysdate,'DD-MON-YY HH24:MI:SS'))");
ociexecute($stmt, OCI_DEFAULT);
echo $conn . " inserted hallo\n\n";
}
function delete_data($conn)
{
$stmt = ociparse($conn, "delete from scott.hallo");
ociexecute($stmt, OCI_DEFAULT);
echo $conn . " deleted hallo\n\n";
}
function commit($conn)
{
ocicommit($conn);
echo $conn . " committed\n\n";
}
function rollback($conn)
{
ocirollback($conn);
echo $conn . " rollback\n\n";
}
function select_data($conn)
{
$stmt = ociparse($conn, "select * from scott.hallo");
ociexecute($stmt, OCI_DEFAULT);
echo $conn."----selecting\n\n";
while (ocifetch($stmt)) {
echo $conn . " [" . ociresult($stmt, "TEST") . "]\n\n";
}
echo $conn . "----done\n\n";
}
create_table($c1);
insert_data($c1); // Insert a row using c1
insert_data($c2); // Insert a row using c2
select_data($c1); // Results of both inserts are returned
select_data($c2);
rollback($c1); // Rollback using c1
select_data($c1); // Both inserts have been rolled back
select_data($c2);
insert_data($c2); // Insert a row using c2
commit($c2); // Commit using c2
select_data($c1); // Result of c2 insert is returned …
You will be happy to know that this works in Firefox, but not in Internet Explorer. I'm not sure what the exact problem is, but it has something to do with the DOM and browser compatibility. If I figure it out I will let you know.
If you really want help you should post your code, or at least the portion you feel is causing the problem. Offhand it sounds like the zip file on the server has gotten corrupted somehow.
There is a pretty good tutorial here. There is also a tutorial here on Daniweb at this link that deals with rewriting for vbulletin. I haven't read the tutorial here on Daniweb, but I'm sure there are lots of questions and answers that may be helpful as it is a huge thread. I also assume you have had a look at the Apache URL Rewriting Guide, I found it very hard to follow :o Understand that you really aren't doing anything in PHP, you will be creating commands that the apache server interprets and executes itself.
Javascript: +you don't have to reload the page +probably faster -must upload all pics at once (i think..) -possible browser support issues(not likely tho)
PHP: +better browser support (browser sees nothing but html) +easier to code (IMO-no DOM issues) -must reload page to modify design -slower...
If you decide to use PHP I will be glad to sketch out what you need to do, but I don't know much Javascript. My opinion tho is the user would have a better experience if Javascript is used.
Ok. The problem comes when you use ' inside your statement with ' on the outside. So something like this is not good:
echo 'some text 'more text' and more text';
PHP expects 'more text' to be some kind of variable or operator. I think you will need to use " on the outside and \" any " inside of the statement. Something like this:
