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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 !
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 Replies !
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 !
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 !
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 !
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 !
Same Database On Different Server
Character encoding Have uploaded the same database to two different hosts. Created a simple function to retrieve and output the content in html On server A the content looks fine, but on server B the content has odd character symbols instead of apostrophes. Both machines are using linux, MYSQL, and php Tied few things and still non the wiser, have included any info i think might help. On server A, using phpMyAdmin i can see ‘content’ field has the collation of latin1_swedish_ci On server B, i can’t see what the collation is but know the default for the server is latin1 Server A PHP 4.4.0 PHP CFG same excpet '--with-mysqli' '--with-imap' '--with-imap-ssl' '--with-kerberos' MYSQL 4.1.13 Server B PHP 4.3.11 PHP CFG same except '--with-gettext' MYSQL 4.0.23
View Replies !
Database On Another Server.
At present, the webserver I am using has the webserver (IIS i believe) and mySQL database on the same machine. It has become necessary for me to move the database to a new server, however keeping the website on the existing server is also quite important. Can someone please give advise on what to do? I *think* I need to set up mySQL on the new server, then change the host name to the IP address of the new server. Is this correct? What other complications will I need to take into consideration?
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 !
Read Database From Another Server
let's say i have joined 2 difference isp and stored 2 databases in each server. does anyone know how to get the database from one and insert into the other one?? both support php and mysql usually i connect the database using: mysql_connect(localhost,$username, $password); do you think i can connect using: mysql_connect(remotesite,$usernameRemote,$passwordRemote); or something like that i can just use form to integerate since i have 3 tables need to import and update very often.
View Replies !
Server/Database Info
I've been ever-so-slowly working my way through a book on PHP and I've started using databases. When I began, I installed Apache and MySQL on my Win XP computer to access my files without having to upload them. Unfortunately, I've forgotten my login, password, and database names - I can't connect to my DB or see if my code runs without them! Anyone know where/how to look for this information on my computer? I've had no luck so far digging through the files.
View Replies !
Best Way To Monitor Database/server?
I have a virtual private server (fedora) with a system I built in php/mysql. I have always wondered how far can I push my system (how many simultaneous users it would handle). Does anybody know how can i monitor the mysql database and the server to know the use of processor, ram, etc? I saw a very nice monitoring service in the mysql webpage but it is only included with the enterprise edition. I need something similar that I could use for free, or at least very cheap and that I could use in my VPS.
View Replies !
Connect To Database From Another Server
the correct procedure to connect to a mysql database on another host? I have 2 websites on different hosts (servers) and would like to use the records stored on one database on another website. I used $db_host= "www.mywebsite.com" instead of "localhost" and it worked fine for a day now it gives me a 'Lost connection to server' error constantly.
View Replies !
Duplicate Page On Server
I have a main page and wish to have a user click on a button with the intent to create a subpage of the main Lets say I have my main page on my server in a directory called main, once the user clicks on a button, the contente of the directory called main is copied and pasted into a new directory which would be named by the user.
View Replies !
A Webserver (PHP 5) With A Few Database Server (MySQL)
I have a problem in connecting my new FC5 webserver (apache 2.2 + php 5.1.4) to a few database servers through the PHP scripts (RH9, FC2, FC3). I have set host privileges correctly for the database servers. It seems that after I migrated the php files (originally in each database server) to the centralised FC5 webserver, it failed to work. Is it because of the PHP5 is compiled with MySQL version 4 +? Since those RH9 / FC2 and FC3 are equipped with only MySQL 3.2x. What I have done: 1. Rebuild the Apache 2.2.0, PHP 5.1.4 with mysql support (both mysqli && mysql) on FC5 webserver 2. Host privileges in each of the database servers. 3. Firewall rules for port 3306 on each server. What is successful: 1. The FC5 webserver is able to connect to its own MySQL server (version 4.x) What is failed: 1. There wasn't any error message from PHP 5 (display through the browser), until I pop into console and type at the prompt let say "php index.php", then all the error message was displayed through the console.
View Replies !
Database Server Auto-close
I just wondered if someone could clarify... I have a a script connecting with mysql_connect and in an include at end of page mysql_close If they script terminates before end of page ie. with an exit() or maybe trigger_error(), does php always disconnect the open'ed connection? I ask because PHP manual says yes, but I've seen some comments relating to PHP 4 saying it doesn't.
View Replies !
Unable To Connect To Database Server
I am trying to install a PHP script on my server and get the following error message. I replaced username, directory, and folder name for security reasons. --------------------------------------------------------------------------- Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'nobody'@'localhost' (using password: NO) in /bhome/username/directory/directory name/includes/functions/database.php on line 12 Unable to connect to database server! ------------------------------------------------------------------------- Here is the DB Privileges. I subbed the personal data. Code:
View Replies !
Accessing A Database On Another Hosting Server!
I have two web hosting accounts. The first one has no databases and unlimited webspace, the second one has limited webspace but unlimited databases. Is there a way I can access the databases on the server that doesn`t have them from the one that does? I read a previous post about ODBC, but I`m not sure what that is exactly.
View Replies !
Compare With Dates In A SQL Server Database
I have a date from a html form and I want to compare it with dates in a SQL Server Database. The html form date has this format: YYYY-MM-DD And I formatted the Database date to this: YYYY-MM-DD So is the below the correct way of checking if the dates clash?PHP Code: if(($class_start >= $date_start_db) && ($class_start <= $date_end_db) || ($class_end > $date_start_db) && ($class_end <= $date_end_db) || ($class_start <= $date_start_db) && ($class_end > $date_start_db))
View Replies !
Directing Server Php Return Page
How do I have the server-side php script open up a new client window, rather than having it return to the client page that invoked the php script in the first place? I want to preserve the original client page. Or if I could do it, better yet, is there a way to have the php script return to the same window, but a new page, thereby preserving the original client page?
View Replies !
Random Products On A Page - Like Ads In An Ad Server
We have a table of products that we'd like to show on our content pages. Like ads in an ad server, we want the products to show randomly throughout specific pages. The logic might be something like: For each page select all the products that match that topic from this list of products, randomly choose 4 products for each content page My product table has the following columns: - productSKU (primary key - unique value - text) - mytopic (the topic where the product should appear) - probability_to_appear ( a product with a probability of 2 should show 2x as much as a product with a probability of 1) My question is - how can I randomly choose 4 products to appear on each individual page? I know that an ad server can serve weighted random ads. Does anyone know how I could use PHP code to serve weighted random products?
View Replies !
Pb Refreshing A PHP Page On An Apache Server
My problem is that I want to test with a PHP script on a Web server ( Apache ) whether the current displayed page inside the browser should be redisplayed or not ! To do so, I take the signature of a given image on the server and store it inside a cookie at the first visit. When another GET for the same PHP file arrives, I read the cookie and if the two sigantures are the same, what I want to do is : - nothing that is the browser should not redisplay the same page To do this, I put inside the PHP file - a header call : header("Refresh: 5 ; $SELF"); - then an HTTP header 204 to tell the bowser to do nothing : header("Status: 204 No content"); Everything works fine at the beginning ! I see with Live HTTP headers that I receive the two headers and I wait for the refresh after 5 seconds but it never happens!
View Replies !
|
TRACKER
