Add Records, Auto Generate..
we're doing a system for an accountant..we have records already for customers and each customer's should have many records and should auto generate every month..i have no idea about it, anyone here knows how to do it? i have an attachment here if you look into it, you will see a table at the bottom, what we have to do is to add another record on that table.
as you can see i already have a record, and next month another record should be added there, the payment cycle should automatically be aug1-31 2006, and so on..so every month, another record should automatically be added on that table. one more thing, how can i add a record to each customer if they only have one record. we have a database. it has fields
id, Lastname, firstname, bill, payment received, payment received date..etc
and of course each id/customer can only have one record. how can i add records to those firlds?
View Complete Forum Thread with Replies
Related Forum Messages:
Auto Generate A Number
I use an online ordering system. Is there a way to automatically generate a random 6+ digit unique number and also print the number on the confirmation page? I dont use mysql or any database. Here is the link for the actual page. You can go ahead and submit something (just use "Test" on the name field) Code:
View Replies !
Auto-generate Thumbnails For Video/flash Files?
I'm wondering if there is a (good) way to auto-generate a thumbnails for video (.avi, .wmv, etc.) and flash (.swf) files and display them in a page. Basically, i want to be able to list the files in a directory containing these file types, and have a thumbnail displayed for the file, w/o having to create thumbnails for the files manually (thus, making the site easily updated). Is it possible? i do not have SQL installed on this server, and (as of now) the owner of said server has no plans on installing it. I'd complain, but he's hosting for free... soo... herein lies said problem.
View Replies !
Auto Generate POP3 Accounts Using PHP & Plesk/Horde
I'm building a site where advertisers can buy leads for widgets. I was running into problems when trying to have my site use php to send the email to advertiser@aol.com. The best way I have found to make sure that all the leads reach the advertiser is to give them a POP3 account that redirects to their real email address. e.g. the advertiser would have an account 103-joeblow@MyDomain.com that redirects to advertiser@aol.com. That seemed to get me past junk mail filters, and all the other issues I was having, but created a new problem. Now everytime I sign up an advertiser I have to manually create them a POP3 account, which granted takes very little time, but it isn't exactly immediate access for the advertiser. So finally my question: Is there a way that I can auto generate POP3 accounts using php for my VPS that is plesk using horde for email?
View Replies !
Auto Delete The Old Records But What If Server Clock Was Set Up Wrong In Maintenance?
I want auto delete any events that the event date is at least 1 day older than current date. No problem for the php programming. get the current data (server clock), check the events date and delete the old records. My problem is that for some very rare cases. Say if for extrem cases I have 1000 new events saved in database. But somehow, I or the the hosting company do the server maintenance, and reset the time clock of the server, in case in the maintenace, the server time clock was set up wrong say 2005, was set up as 2006. Code:
View Replies !
Displaying Priorty Records And Normal Records In The One Dataset.
I have a page which displays the records from the database and uses paging to display the records in groupes of 10 per page. I now want to be able to show results depending on the database field (display) in the database (can be set to either "full" or "limited"). If the record and the field display is equal to "full" i want to then display this record at the top of the record set and display all the fields. If the record is equal to "limited" i want to display different results and they must show after all the records which are equal to "full". I can't output two different recordsets as i use paging and only want to show 10 records per page. Code:
View Replies !
DELETE RECORDS - Database Adding New Records
iv got the database adding new records, and now I want it to display all of the records that are there buy name and id number, then i want u to be able to type in the id number of the customer u wish to delete and it shoudl delete it, sounds good buts its not actually deleting the record. it says it does, but its not doing it. Code:
View Replies !
Problems With The Listing Of Records, Editing Of Records
I'm having problems with the listing of records, editing of records, and deleting of records. I'm not sure what I'm doing wrong. The listing script is calling the add entry script. So I add the record, the database is updated, and nothing else happens. I don't get a list of records from that table. When I did SQL programming off the mainframe, you did a simple select statement. I'm not sure why the PHP list script is calling the add entry script. Code:
View Replies !
Generate Php Into Pdf
I have a' report that created with php and i want to generate it to pdf report is there anyone know how to do it, if there is sample that would be good...
View Replies !
Generate HTML From PHP
I am just wondering if it is possible to save a HTML string from PHPs? Let me elaborate more on what I mean. If you do <?php include 'abc.php' ?> //abc.php <html> <head> <title>Example</title> </head> <body> <?php echo "Hi, I'm a PHP script!"; ?> </body> </html> <?php $a_number = 5?> <javascript ... <?php echo $a_number ?> /javascript> I am looking for a way to display only HTML and javascript and have $a_number replaced with 5. I need something that will display resulting HTML of PHP execution. So if there are functions or database queries in PHP, the HTML string will reflect the result of function execution or retrieved result from database queries. Not the function definition or database query strings. In other words, process a seperate PHP file and return its HTML output like the INCLUDE function, but do not output it (instead set it to a variable value).
View Replies !
This Page Took To Generate
Ive seen it on a couple of sites. I would be interested in this, but not only for a search or something. Basically I want it somewhere on all pages, so it should compute how long it takes for PHP to generate the entire page, including the time thats wasted building up content gathered from MySQL queries ....
View Replies !
XSL Generate-id Problems
I used the xslt functions with php4... now i've moved to php5, and, as the xslt functions are no longer bundled, i'm moving the code to the XSLTProcessor class. I've found a problem with the generate-id() XSL function... with the old functions, generate-id() gave me the same id for the same section of my XML document every time i processed it. Now, with the XSLTProcessor class, every time it gives me a new id. This is not how it's supposed to work, as it is impossible to make references to sections of the document. Am i doing something wrong or the new classes are a bit buggy?
View Replies !
Generate All Possibilities
You know them brute force password crackers... Just give the min/max passwordlength and the character scope in which they have to search. min length: 1 max length: 7 scope:abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQR STUVWXYZ01234567890!@#$%^&*()_
View Replies !
PHP To Dynamically Generate XML
I am interesting in using PHP to dynamically create an XML document and then use XSLT to transform to XHTML. I have come across two methods for doing this. I made two equivalent examples so you can see what I mean. http://members.shaw.ca/petermichaux...SLT_method.html I am interested in critisim of how I implemented each method. However my main problem is deciding between methods. Which method is better for bigger programs where the bits of the XML data are assembled by various php functions that I write? For example, one php function queries a database table for a list of CD titles. A second php function loops through this CD title list and gets the track listing for each CD from another table in the database. Then the composite XML data (ie. CD title and tracks as nodes) can be tranformed to XHTML.
View Replies !
Ssl And Php (generate Certs)
I want to generate ssl certificate (with public key) and private key. My code: $ssl_configargs = array( "digest_alg" => "sha1", "private_key_bits" => 2048, "private_key_type" => OPENSSL_KEYTYPE_RSA, "encrypt_key" => false ); $dn = array("countryName" => $_POST[ 'country' ], "stateOrProvinceName" => $_POST[ 'state' ], "localityName" => $_POST[ 'city' ], "organizationName" => $_POST[ 'org' ], "organizationalUnitName" => $_POST[ 'unit' ], "commonName" => $_POST[ 'name' ], "emailAddress" => $_POST[ 'mail' ] ); $numberofdays = $_POST[ 'days' ]; $pkey = openssl_pkey_new( $ssl_configargs ); // there is a error $csr = openssl_csr_new( $dn, $privkey, $ssl_configargs ); $sscert = openssl_csr_sign( $csr, null, $privkey, $numberofdays ); openssl_csr_export( $csr, $csrout ); openssl_x509_export( $sscert, $certout ); openssl_pkey_export( $privkey, $pkeyout, $configargs[ 'licence_pwd' ] ); I've tried use openssl_pkey_new without param ($ssl_configargs ), but it still doesn't work. My errors: Warning: openssl_csr_sign(): key type not supported in this PHP build! in xx.php on line xx Warning: openssl_csr_sign(): failed to sign it in xx.php on line x Warning: openssl_x509_export() expects parameter 1 to be resource, boolean given in xx.php on line xx Warning: openssl_pkey_export(): key type not supported in this PHP build! in xx.php on line x
View Replies !
Use Php With A Database To Generate Xml
this is a bit of an advice thing. iv just finished a degree in multimedia, where i learned the usuals... html flash director javascript i also learned php and i have been told that i should get to grips with xml as this combination is verry useful so iv been messing arround with xml for the past couple of days trying to figure out how the two would work together. i just cant grasp the idea.. on thought i have had is that you could use php with a database to generate xml but surely that would not be parsed as xml as it would have the .php extension..
View Replies !
Generate MIDI CC
I have done many searches and cannot find the information I'm looking for. I'm a very beginner PHP user and would like to know if it's possible and how to generate specific MIDI CC's (so for example, note on information, specific CC#'s, etc).
View Replies !
Using PHP To Generate XML File
How do you use PHP to generate an XML file? I need to use PHP to grab some variables from my database and then insert them into my XML file for a dynamic flash playlist that changes with each user. Currently my XML file looks like this: <?xml version="1.0" encoding="UTF-8"?> <songs> <song url="url1" artist="artistname1" track="001" /> <song url="url2" artist="artistname2" track="003" /> <song url="url3" artist="artistname3" track="004" /> </songs> I want it so that each variable (artist, url, track) can be pulled from my mySQL database to generate this XML file.
View Replies !
Can't Generate <div> Elements With Php
I am trying to take a series of short strings, $mystrings and position them at random positions on ahtml page with the ability to overlap. The strings feed from a mysql database so I would rather do this server side with php than on the client with javascript. My effort below fails on the print line. <html> <head> <style type="text/css"></style> <?php $myarray = array("aa","bb","cc","dd","ee"); foreach($myarray as $val) { print"<div align="center"><h1><? print $val ?></h1></div>"; }
View Replies !
Generate HTML
I'm currently parsing users requests to generate a php page. In addition to returning the page to the user how can I save this response as a static html page on my server?
View Replies !
Generate Fields
I'm trying to create a task manager , for accounting firm, they have a series of regular tasks they need to be able to control , research old records,etc... The problem is that all of these tasks have a common set of fields ,the problem is that some of them have some specific fiels (most of them just text fields). Has anyone developed a similar system and/or can give some hints on how I can alow the user to generate these fields on the fly ?
View Replies !
Generate OPML
if there is PHP example scripts that can generate OPML from user selection for rss? or similar something like below example or simple php scripts that generate opml?
View Replies !
Autofill / Generate A PDF
I have a client that wants to create a PDF from data in a database. How hard/complicated/tedious is this? Because this form is supposed to be a legal document. So you cant really print it right off of their website, because it will have the website address on the page. So I guess my only solution is to create a PDF on the fly.
View Replies !
Image Generate From Db
i'm using the below script all is working fine, but i was wondering if it was possible to embed this into my web page instead of calling if from another. for example if($id) { $query = "select bin_data,filetype from covers where id=$id"; $result = @MYSQL_QUERY($query); $data = @MYSQL_RESULT($result,0,"bin_data"); $type = @MYSQL_RESULT($result,0,"filetype"); Header( "Content-type: $type"); echo "<img src=$data>"; .............
View Replies !
To Generate A Zip File Or Not To?...
I have a website with 6,000+ fonts on it. Each font is located in its own seperate folder. Would it be too resource intensive to generate a zip file of the subfolder and serve the download every time someone chooses to download it. Should I just upload the zip files(and thus doubling the space I'm currently using)?
View Replies !
Generate Links
Using PHP 4.4.4, do any of you have a quick way to generate a list of alphabetical links that link to <a name=""sections on my page? The desired HTML would look like <a href="A">A</a> <a href="B">B</a> .... <a href="#Z">Z</a> Figured someone out there had a slick way to generate these.
View Replies !
Cannot Generate Report
I have a running PHP Application in my computer and I'am using Apache. When I transferred my files to a 2003 Server using IIS 6. My PHP application is working fine but when I tried generating report, after some minutes, the report generation (HTML or EXCEL format) is terminated in the half of its operation. I tried changing the configuration of the IIS CGI and session timeout but the problem is still there. I also have the set_time_limit(0) command in my script but still the problem is there.
View Replies !
Cron Tab To Generate
I'm running some pretty hefty maintenance PHP scripts on a LAMP setup that sometimes take 4h + to complete. The problem is that if I close the browser window or exit the terminal window while the script is running, the process is killed. I'm looking for a solution whereby I can launch a PHP script and close / exit whatever window I used to make it. Cron works in this situation, but I don't run the script at predefined times so I would have to setup a Cron tab everytime I run the script.
View Replies !
To Generate Content From URL!
OK, this is a really newb question,so apologies in advance. In effect, I would like a user to click on (or enter) a URL (i.e. mydomain.com/search.php?u=cheap tvs. The resulting page would be on my domain (i.e. mydoamin.com/searchresults.php) and contain the search results from say Google. I have a manual, but really struggling in the basics here.
View Replies !
Generate An Image
I am trying to generate an image using the example given with php documentation. But i am not able to generate. Please anyone explain what could be the problem. Here is the code that i used. <?php header("Content-type: image/png"); error_reporting(ALL); $im = imagecreate(100, 50) or die("Cannot Initialize new GD image stream"); $background_color = imagecolorallocate($im, 255, 255, 255); $text_color = imagecolorallocate($im, 233, 14, 91); imagestring($im, 1, 5, 5, "A Simple Text String", $text_color); imagepng($im); imagedestroy($im); ?>
View Replies !
Generate RSS Feeds
I'm using PHP 4.4.4 with Apache 2.2. I'm looking for recommendations on free code I can use to generate RSS feeds. I found FeedCreator though Google, but that is terrible. It cannot output dates correctly and it displays a bunch of warnings/notices, even though I never touched their code.
View Replies !
Generate Numbers
I have a table which stores client information. In this table I also need to store a field called case_number. My client would like the case_number to be automatically generated when she adds a new client. And, she would like the case numbers to be sequential. So if I have ClientA in a table with case number 2020 and I add ClientB to the table, I would like their case number to be 2021. And, if I add ClientC to the table, their case number sould be 2022. Etc. Is it possible to write a script to generate a number in sequential order and store that number into a table?
View Replies !
Generate An XML File
The reason I ask is that I want to setup an RSS feed for my site. As the database integration and PHP code for displaying my blog posts is already in existence I thought it would be simplicity itself to slightly modify this code to create my feed. Then I remembered that the feed would have to be an XML file and as such the PHP wouldn't parse properly. What's the best way to handle this? I've no problem generating the feed with PHP from the database, but I'm stuck on how to get the resulting XML code into an actual XML file, or to get it to read properly as XML without a .xml extension.
View Replies !
Generate XML File
Which library is used to generate XML files? I'm not sure which is used for reading, which for writing, xml vs xsl in terms of what their extensions do. I have an xsl file that I use to format a group of xml files. I would like to use php to insert data from a database into an xml file using the correct elements which ive chosen.
View Replies !
Using To Generate A .xml File
I have a .xml file which normally looks fine, type is text/html The problem is, when I make the .xml file be parsed with PHP, and I put in the header at the start, and all I do is echo what was there before, it totally ruins it it basically turns it into a plain .txt file Code:
View Replies !
Generate Graph
I need to make a website which plots graphs from a database. Manipulations of the graph is required, like scrolling up/down and left/rite, zoom in/out, enable/disable displaying position of points, as well as values, max/min and average of a line graph, etc. I don’t have much experience on website or web tool development and I am thinking of using php, so can anyone give me suggestions on what programming language(s), and methods might be useful on finishing this project.
View Replies !
Generate Password
I have the following code which contains two arrays and a password function. I want to generate a different password for each element in the array, at the moment it is just giving everyone the same one Here is an example: $name = array("ZEINA MORRIS", "LEANNE DENNIS", "NICKY BROPHY"); $employee_number = array("A393", "A394", "A493"); $password = $oTblLeads->generate_password(4); for ($i=0; $i < count($name); $i++){ Â Â mysql_query("INSERT INTO cms_users (name, employee_number, pin_code) VALUES ('$name[$i]', '$employee_number[$i]', '$password')") Â Â or die(mysql_error());
View Replies !
Generate Formatted .rtf
I am trying to create a file for a user to download which includes formatting. The text to be put into the file is represented by the variable $content which could for example look like this: $content="<b>Text</b> - <i>More</i>"; My problem is that using this code, the output doesn't format the text using the tags. It just puts the tags into the document. Code:
View Replies !
Generate PDF File From HTML Using PHP
anyone know how to generate pdf file using php.. As far as i know there are 2 ways to do that. 1) Using PDF library 2) Using header that will send application type as pdf Anybody know which is the better or easiest way to generate pdf?
View Replies !
|
TRACKER
