My Insert Creates
I cannot figure how to fix it. That snippet should be used to grab an ID which it does fine Then insert that ID in a col named "member_web_address" As mentioned it does get the ID and insert it But not on the row where from the ID was taken . It does insert it on a new row created by the insert action Which due to the auto increment creates a new ID etc... How can I keep the original row and pass its ID # to the "member_web_address" col in the very same row
<?
$query = "select id from templates where username= '$username' and page= '$page' ";
$result= mysql_query ($query);
while($query_data=mysql_fetch_array($result))
{
$member_web_address=($query_data["id"]);
}
$query = "select id from templates where username= '$username' and page= '$page' ";
$result= mysql_query("insert INTO phplates (member_web_address) values ('$member_web_address')");
?>
View Complete Forum Thread with Replies
Related Forum Messages:
Creates The Session
i have a field in a database called Password. It is based on 'password' that a query on the rest of the database is run. The query uses sesions. I attempt to login to thru a login page with my 'email' and 'password'. This is the page which checks that the login details are correct and it creates the session Code:
View Replies !
Dynamically Creates Varibles
i have this script for that uses 7 pulldowns for the time of an event each day of the week that gets inserted in to a db. Instead of writing the script 7 times for taking the data from the pulldowns, creating a time based on the hour, minute and AM/PM -can i create something that dynamically creates varibles. Basically takes something like $hour1, $minute1 and automatically creates $hour2, $minute2 and so on. This is kinda difficult to explain, heres a snippit of code which i want to duplicate.
View Replies !
Fopen Creates Files?
According to the PHP documentation fopen will create a file that it is directed to open with write access if it doesn't exist... It may be my current host, or I may be doing it wrong, but it doesn't work. Code:
View Replies !
CURL Creates New Session
I currently have a curl session that can access hundreds of different pages on a site. One thing I noticed with it is that it is initiating a new session of the server that is accessing. I don't want it to create a million sessions, just use the one it currently has. I am going to guess that if curl_close($ch) is called, then it is is reinitiated curl_init, it restarts the session correct.
View Replies !
Cron Job Creates Php Files
I have a cron job that is running on my server. Its set to run every half hour. It works great, but it has an annoying little quirk. Everytime the cron job is run, it creates a php file in the root directory of my server. Since its running every 1/2 hour, I get a bucnh of files on my root directory and I have to manually delete them everyday. I've posted the code for my cron job below.
View Replies !
Looking For Script That Creates List Of Referrers
I've been looking for a script that will create a real-time list of 'top referrers', similar to the links to sites you see on the left of the page at http://www.linkswarm.com. They also have a page http://www.linkswarm.com/referrers/referrers.php which shows all referrers. I'm assuming you'd be able to set filters. There is no signup required, you just link to the site and your site appears in the referrers list, but as a webmaster, you wouldn't want to include search engines for example.
View Replies !
Creates A Database On Any Server Via A Web Page.
I have basically an install script that creates a database and all the tables and fields. This works great on the local IIS I have on this machine, but that's because I have 1 password for all databases. THe database cannot be created when I run this on the server that hosts my websites (which is a remote server that I rent space on, it's not in my control). I'm trying to figure out if what I want to do is possible. I want to have a script that creates a database on any server via a web page.
View Replies !
Netscape Creates 2 Files For My Sessions
I am having a problem with Netscape when I try to create session variables on two different pages. Netscape produces two separate session temp files ... one with the Redirect.php session variables... one with the Results.php session variables... both have an unique sessionID. IE works fine (in that it creates one session temp file for all variables). Here is the code I am using: PHP Code:
View Replies !
Mysqldump Creates 0 Bytes File!?
i found some simple code for dumping mysql database but whatever i do (change path to mysqldump, change arguments, change functions) it generates 0 bytes file every time! why is this happening? how could i debug my code? Code:
View Replies !
Script Creates Owner As Apache
I am using a fantastic script called Photofolio from www.billwadman.com/photofolio and everything is awesome with it except that when you call the file "buildthumbnails.php" and it builds your thumbnail folders it creates them with the owner name as "apache" and permissions at 644. The problem here that you may suspect is that I cannot go in and delete those files in any of my FTP programs of DW because I am not the "owner". My hosting company says I will have to manually lodge a ticket each time to have the folders deleted. THis seems like a pain in the arse. could anyone offer any help into this situation? or will this really be the case that they will have to delete the files. The only other option I see is Bill Wadman creating some sort of script that will go in and delete the fies or folder directories for you.
View Replies !
Mysqldump Creates Empty File
I have the following code running on a Windows PC (it actually needs to work in a Linux environment on live but still developing it). It seems to create the a.sql file but there is nothing in the a.sql file even though there is data in the database....
View Replies !
MySqldump Creates Empty File?
I am Trying to create a one click backup database script so non-geek office staff can do this, but so far I can only output empty files $db_user = "root"; $db_password = ""; $db_database = "or"; $db_server = "localhost"; $backup_path = "C:xampphtdocsopenrealadminackup"; $path_to_mysqldump = "C:xamppmysqlin"; $filename = "backup".date("YmdHis").".sql"; shell_exec ("mysqldump $db_database > $path_to_mysqldump.$filename --user=$db_user --password=$db_password"); I have tried various forms of this syntax with no content output?
View Replies !
Securing Code That Creates Images
I have a pretty nice php web site, that's also reasonably secure. However, I wrote some php code to create some dynamic images based on database data, but I can't figure out how to secure this script? when I reference the php code via img src="myimage.php", none of my session variables are available for use in the script. So, without my session variables, how am I suppose to ensure that the script is only run by a valid user, rather than just anyone who can blindly type in random parameters to my image creation script?
View Replies !
'exec' Creates Popup Windows
I'm running php under apache (I'm using the uniserv distribution) on Windows XP. Every time I execute an external command using backticks or exec or system, I get a cmd windows that pops up for the 1/4 second the command executes. This would all be fine, except that I'm deploying the server to run locally on the user's box, and needless to say, the popups are annoying. I've search everything I'm clever enough to understand and can't find a way to get the external commands to run in the 'background'. All of the input and output of the commands have been redirected, any shell command causes this behavious, and in all other respects it all seems to work great.
View Replies !
Verify Page Which Creates A Session
I am new to sessions and php and have been playing around with them - and would like to know why this is happening? Firstly I have a login page and it goes to a verify page which creates a session like so:
View Replies !
Creates A Cookie And Redirects It Automatically
i am migrating my ASP code to PHP and I have a problem with redirection i have a code here that creates a cookie and redirects it automatically but the problem is that... on the first event that a user visits the page... the cookie is created but it does not redirect automatically. on the second event that a user visited that page, it redirects the user to another page. Code:
View Replies !
Creates Some Session Variables After Validating The User
I'm new to PHP... I wrote a php script for login page, which creates some session variables after validating the user... But it's not working... When i compile it... The compiler is giving me the following Warnings... ---------------------------------------------------------------------------------- PHP Warning: session_start(): open(/var/lib/php/session/sess_f207f20079897ad6f830fc632fa5e0c0, O_RDWR) failed: Permission denied (13) PHP Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/gana/public_html/login.php:4) PHP Warning: session_start(): Cannot send session cache limiter - headers already sent PHP Warning: Unknown(): open(/var/lib/php/session/sess_f207f20079897ad6f830fc632fa5e0c0, O_RDWR) failed: Permission denied (13) PHP Warning: Unknown(): Failed to write session data (files). (/var/lib/php/session)
View Replies !
Script That Creates A Smaller Version Of Image.
I have a dynamic image. i.e it keeps on changing. What i want to do i make a script that creates a smaller version of this image. like 50% width and 50% height. i want to place it elsewhere. But the thing is this smaller image should change when the original image changes too.
View Replies !
A System Automatically Creates A Copy Of A Php Page.
What I want to do is for people to put information into a form and after they hit "submit" a system automatically creates a copy of a php page. Then, it inserts the inputted info from the form in the new php page. The pages would be numberically named and accessed easily like this. Everything is set up on the php page where only variables are needed to be changed. How do I take the submitted variables and write it into a newly created numbered page and insert the variables?
View Replies !
$_SESSION Problem - Page Reload Creates New Session ID
I am having trouble using the session vars in PHP 4.3.9 OS: Win XP Prof Web Server IIS (is local and there are no links to other servers from the web pages I work on) Browser: IE 6.0 The problem I am having is that each time I reload the same PHP page, I get a different Session ID (and thus all session vars are lost from one page to another). let's say in firstpage.php I set $_SESSION["firstvar"] = "someval"; $_SESSION["secvar"] = "otherval"; and in secpage.php I try to retrieve $_SESSION["firstvar"] , it gives me "Undefined Index error" I did not know what is happening and when printing out the session id (echo SID;) I found out that the ID is changing every time page is reloaded or when moving to another page. The problem is that I don't know what might reset the session since I use "session_auto_start" and have not played with session_start, session_destroy or anything else.
View Replies !
Creates A Dropdown List Of Information Belonging To That User.
I have a page that uses php to look up specific fields in a specific table of a specific database based on the username. Using this, it creates a dropdown list of information belonging to that user. The fields in question each have 13 pieces of data. Based on what they click in the dropdown box, I need that specific data to pass onto hidden fields on the page. Code:
View Replies !
Unable To Write A File In A Directory That My PHP Script Creates
I've a problem of being able to create and remove a directory but unable to write a file inside the created directory for some strange reason. I suspect that this problem could be vaguely linked to Safe mode being set to On since my site is using shared server hosting and probably insufficient/incorrect Unix file permission. Below is my test script that helps me narrow down the problem. -------------------------------------------------------------------------------------------- <html> <head> <title>File IO Test</title> </head> <body> <pre> <?php define("TEST_DIR", "./newsletter/2005_11"); define("TEST_FILE", "./newsletter/2005_11/file_io_test.txt"); echo "Make Directory"; if(mkdir(TEST_DIR, 0777)){ echo "<font color="green">OK</font> "; } else{ echo "<font color="red">Fail</font> "; } if(file_exists(TEST_DIR) && is_dir(TEST_DIR)){ echo TEST_DIR . " exists. "; } else{ echo TEST_DIR . " does not exists. "; } echo "<hr> "; // TEST FILE WRITE echo "Write Open File"; $file_handle = fopen(TEST_FILE, "w"); if($file_handle){ echo "OK"; } else{ echo "Fail"; } fwrite($file_handle, "This file is written at " . date("Y/m/d H:i:s") . " "); echo "Write Close File"; if(fclose($file_handle)){ echo "<font color="green">OK</font> "; } else{ echo "<font color="red">Fail</font> "; } echo "--- START FILE DUMP --- "; readfile(TEST_FILE); echo "--- END FILE DUMP --- "; echo "<hr>"; ?> </body> </html> -------------------------------------------------------------------------------------------- This script will report a success with the creation of the directory on my server, but fails to write a file inside the newly created directory. Originally, I only call mkdir without specifying any permission and it doesn't work. Thus I explicitly instruct mkdir to use 0777 to allow all write operation by everybody, in case PHP and Apache try to write files using "nobody" or "www" user account, instead of my shell login user account. Still it doesn't work. The owner of the created directory is called "www". When I login via SSH and check the permission, strangely, the permission is 775 instead, with Write permission for Others disabled, although I told mkdir to use 0777 instead. Is there any workaround, and what am I doing wrong here? Thanks for sharing with me any insight into this problem. I'm not quite sure what exactly is wrong here, whether because of PHP Safe mode, incorrect directory permission, incorrect file permission or the case of different UID or owner.
View Replies !
Creates A Simple Text Box For The User To Enter Details In.
I'm using a Mambo component (Remository) to output details about files for download. The code below shows what's there at the moment. PHP Code: $this->fileOutputBox(_CUSTOM_4,'custom_4',$file->custom_4,25); This creates a simple text box for the user to enter details in. However, in some fields I want to limit the options available by having a select drop down box. In other fields I may want to supply the values in the select drop down from other fields in the db.
View Replies !
Creates Generates A Download Link Which Is Active For One Hour Only
I'm making a system which creates generates a download link which is active for one hour only. I wanted to make it cookie based, but I'm having troubles setting the expiry time of the cookie correctly: $timestamp = time(); $expires = $timestamp + 3600; setcookie("DOWNLOAD_ID", $hash, $expires); In Firefox the cookie is set correctly to expire in one hour from the current local time. In IE and Opera it sets the expiry time to one hour in GMT. The server is in the same timezone as the client machine (for now). How to I make sure that the expiry time of the cookie is set to 1 hour in local time ?
View Replies !
Xml Parsing Issue - See Some Extra Information Which Creates Problem
I am using for web service client and been able to get correct results. Now i have problem in parsing it, I have methods available for this either get data form array which in user debug or i can parse the xml. When i put the who xml in file and try to parse it it works file, but when i try to parse it directly you can see some extra information which creates problem, please check this issue and help me out. Code:
View Replies !
Function That Reads The Content Of The Images Folder And Creates Hyperlinks Of The Subfolders
I have a folder "images" in which different other folders are stored. Like "party" or "car" or "holiday". In those folders are JPG's stored. I am looking for a function that reads the content of the images folder and creates hyperlinks of the subfolders (with the same name as the folder) when i click a hyperlink I want the pictures in that folder to be loaded and shown as tumbnails. So when i add an new folder with new pictures i want to have a new hyperlink which shows the new pictures.
View Replies !
Insert Values - Table Has Four Columns To Insert Into
I have a bunch of information that I want to insert into a table insert into TABLE values ('hello','I','am','lost'); pretend that the words that are being inserted are coming from a form for another page. In he case I above I have declared that the table has four columns to insert into. What if I do not know how many columns there are?
View Replies !
Insert Into Table - $query = "INSERT INTO Tbl
I have a small problem which I've been working on for a while. PHP Code: $query = "INSERT INTO tbl(username,ip,link) VALUES("Brin' . $result['id'] . '","$REMOTE_ADDR","http://www.domain.com/sub/start.php?username=Brin"' . $result['id'] . ' )"; mysql_query($query); Any ideas?
View Replies !
Creates A Temporary Folder And A File Within The Folder.
I have a PHP script which creates a temporary folder and a file within the folder. I have a problem when trying to remove the file and folder using my FTP program. The ownership and group are set to NOBODY. I cannot change the permissions on either the file or the folder. I have tried chmod and chgrp and chown but for some reason I cannot change permissions.
View Replies !
Insert Statement Doesn't Insert Anything
I have an int field in a database and for teh purposes of this case the insert statement doesn't insert anything into the field using the ' ' syntax however in the mysql database this appears as 0. I was wondering can I still use the empty syntax as follows or will it not work as it is 0 does is this not classed as empty? if (empty($row['intTest'])){ $sns= "empty"; }
View Replies !
Sql Insert
I have looked at numerous examples of SQL insert statements with PHP and this apparently should work: $sql = "insert into estateagents (companyName) values ('$companyName')"; but it does not - it tells me a record has been added....but nothing appears in the db...any ideas?
View Replies !
Insert (now(),now(),....)
I've a query with insert records in a table. I've 2 fields: DateTimeInsertion and DateTimeLastModification. When I create the record, I must have those 2 fields set the same value. Now I've this Insert into article values(now(), now(),....) but what appens if the time changes between the 2 now calls ? It's there any way to be sure to set the same value ?
View Replies !
No Insert ...
I have a php-script with a mysql_query ... $insert = mysql_query("INSERT INTO $table (textID,redaktion) VALUES ('$_POST[ID]','$row_startseiten[ID]')"); I get no mysql_error, if i copy the insert directly into phpmyadmin, the insert works. but with the php-script the insert doesn`t create a new row in the table .. but why?
View Replies !
INSERT INTO DB
All of the variables are registered with the session and I see them when I do a test. Knowing that I now wish to use the code below to insert them into the DB. But it doesn't work! When I run the script it appears to work but the DB does not get updated. Code:
View Replies !
PHP Insert
Im having a problem with a subscription script I made. Its a basic script, and the purpose of it is to allow a user to enter their email address, forename, surname, and select weather they are a business user or home user, then click "submit" and the information gets entered into the database/table I made for the script. Now the problem Im having is the script works, and it submits, the problem is if I go look in the database the script didn't actually insert any information into the database. Below I have included the html form, and the handle.php (the php script that handles the form information) I was hoping someone may be able to provide some insight/advice as to why its not inserting whats in the field values into the database Code:
View Replies !
Insert And Get Key
I have a problem. I am inserting a record in a database that when inserted will redirect to another page. I need that auto incriment key that was generated on that redirect page. How can I do this?
View Replies !
Insert Tag
I'd like to insert a <BR> tag after every X number of characters. Anyone know how I can do that?
View Replies !
10K + Row Insert
I have an approximately 10,000 Plus records (each record = 1 row) that I need to INSERT into a REMOTE (TCP) mysql database... using a While loop obviously takes way to long... Any other suggestions? Can I create a single Mysql command with 10,000 inserts in it?
View Replies !
The Insert
the script im working on is not putting the right info in the database it should put the username and userid of the person that i click on but it is inserting readom usernames and userid here the script i have <? include'db.php'; include'userinfo.php'; include'admin_c.php'; include'admin_info.php'; if($_GET['add'] == "admin2") { //Create User In Database $INSERT=mysql_query("INSERT INTO `admin`(userid,username) VALUES ('$userid', '$username')")or die(mysql_error()); }else{ if($_GET['add'] == "admin") { include'all_users.php'; }else{ if($level==5){ echo"5"; }else{
View Replies !
I Insert To 3
i have a date text field..for example user insert value བ/09/2005'. i want that data insert in 3 field in table. 26 insert in field day, 09 insert in field month and 2005 insert in field year. How to to this?
View Replies !
INSERT INTO
This Doesn't work. code: $result = mysql_query ("INSERT INTO Reservations VALUES ('$records','$resName', '$resEmail', '$resGuests', '$resGuest1', '$resGuest2', '$resGuest3', '$resGuest4', '$resDiet', '$resAttend');", $connection); But this does: $result = mysql_query ("INSERT INTO Reservations VALUES (20,'Joe', 'none', 1, 'none', 'none', 'none', 'none', 'none', 'Yes');", $connection);
View Replies !
Insert?
i want to delete some data by checked the checkbox and at the sametime i want to insert the data into another table(like want to backup the deleted data)..have any idea? Code:
View Replies !
Insert
INSERT INTO Frequency( Search, DateAdded ) VALUES SELECT Search, DateAdded FROM Searches I get this error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT Search, DateAdded FROM Searches' at line 4
View Replies !
Insert 2 At 2
i have an array like this array(a,b,c,d) and I want to insert in the mysql database like this: a a b b etc how can i do this.
View Replies !
How To Insert
I have written a PHP script named dynamic.php. It runs fine by itself, I have been trying to insert it into a index.htm, the site root page. For some reason the code does not get parsed, what am I doing wrong?
View Replies !
Db Insert Now()
All its adding is 0000-00-00 00:00:00 but when its updated it works correctly (ex. 2006-09-15 01:14:29). So my question is how can I modify my insert code to work correctly with now()). It took me long enough to make insert work to begin with since it was barking at T_String, T_integer and so on. So heres the code for update and insert. So to make it clear, im looking to make NOW()) work correctly in the insert code. PHP Code: $info["client"] ."','now()')") or die(mysql_error());; (mysql_affected_rows() != -1) or die ("ERROR: ". mysql_error()); ?>
View Replies !
Insert </tr><tr>
There is an uncertain number of pictures that need to be displayed reverse (new ones before old ones) 4 in a row. And after every 4 loops the script must insert </tr><tr> until the loop come to an end (0). I decided to move this way: Â $rows=mysql_num_rows($cmd_rows); // THAT NUMBER OF PICTURES Â echo '<table><tr>'; Â Â for ($view=$rows-1;$view>=0;$view--) { Â Â if ($view%4==0) { echo '</tr><tr>';} Â echo ' <td>//PIECE OF CODE //</td> '; Â Â Â } echo '</tr></table>';
View Replies !
Insert Into The Db
I want to upload a text file (or open/read one already uploaded on the server) and take it's contents and insert it into the database. The format of the text file is: Miami 31, Marshall 3 Northern Colorado 6, Hawaii 63 I usually have 100+ games a week in a text file. These four fields should be entered into the team1_name, team1_score, team2_name, and team2_score fields of the database table. I've dealt before with fopen and fputs, but really haven't dealt with opening/reading a text file and taking it's contents into the database.
View Replies !
Using Insert Into Where
From the sql manual it looks right. It seems to get caught up only when I include the last part with the userid and password (The WHERE statement). $sql = "INSERT INTO client SET compname = '$_POST[compname]', web = '$_POST[web]', email = '$_POST[email]', cat = '$_POST[cat]', recip = '$_POST[recip]', description = '$_POST[description]', state = '$_POST[state]', city = '$_POST[city]' WHERE userid = '$_SESSION[userid]' AND password = '$_SESSION[password]'";
View Replies !
|
TRACKER
