PHP :: Database Solution

Looking For PHP Solution To Adding Content To MySQL Database
I have recently used aedpro to quickly make pages for my client to be
able to /add/edit/delete/view all/ content in their MySQL database.
Though these pages work, they are limited to an all-or-nothing type
view within their returned record pages. You can't sort the edit or
delete pages to find your information quickly/easily, you have to
scroll through all the records to find your record of interest. The
database contains over 2000 horses, so scrolling to find a particular
horse takes too long. Or, when trying to edit a horse's record, or
group of records, you have to scroll to find the record(s) instead of
being able to type in the record's horseID number and then go just to
that record or group of records to edit.

Do any of you gurus out there know of a PHP based MySQL database
management system that you have used that is both flexible in its use
and easy to install? I have Googled, but nothing is coming up but CMS
type systems, which we don't need. Perhaps I am calling this something
it is not, thus I can't find it. Any help or direction appreciated.

View Replies ! View Related

Need A Php Solution
I understand my question might not necessarily be a issue specific
for PHP. However since my current development is conducted with
PHP so I definitely need a PHP solution for it. Here is the situation:

1. A Login form page for user to keyin username/password.
2. After user input correct login info a small window will popup
and the parent window (the login form page) still stay unchanged.
3. If user click "accept" on the popup window then the parent window
changed.

Step 3 is not a big issue for me. But step 2 is a big headaque.

View Replies ! View Related

PGP Solution
I would like to be able to take the data submitted to a form, encrypt it using a specified PGP key and email it to a specified recipient. All in PGP.

View Replies ! View Related

Looking For An ILS Solution
I'm hoping someone knows of an Integrated Library System that
uses PostgreSQL.

The group I'm working for had an old system and decided to upgrade.
Previously, they were using PHP, MySQL and Koha (www.koha.org) to run
their library interface. The new system they have is PostgreSQL, which
means I cannot use Koha anymore. Converting the MySQL dump has been
hard enough. The Postgres version is 7, so it seems that exporting the
dump with phpMyAdmin does not want to work. But thats a different
problem all together.

So I need to find a replacement for Koha, all I've seem to come up with
is a list of ILSs (http://www.anctil.org/users/eric/oss4ils.html) that
either use MySQL, or only come in a completely different language. If
anyone has any ideas or could point me in the right direction

View Replies ! View Related

PDF: What's The Best Solution?
I'd like to start generating PDF files via PHP, but I'd rather not spend $450 on pdflib. The files I'll be creating (to start with) are invoices, so they contain tables, etc. My server is running PHP v. 4.3.2.

I've seen a couple alternative solutions out there, but most seem fairly old at this point. What have people found to be the best solution for generating PDF files in PHP?

View Replies ! View Related

Help Require For Map Solution
Here is a problem which i'm facing. Now i'm working on a site in which a user will provide the pincode(zipcode) of two positions and a line will
be draw on that map between the two pincodes(zipcodes). Now the solution which i found requires a databse storing the details of longitutde and latitude for
each pincode(zipcode). Also we do need to provide the latitudinal and longitudinal range of that particular map. Now i want to ask you friends if anybody has got any better solution which is more effective.

View Replies ! View Related

Cant Fiugre Out The Solution....
PHP and MYSQL and have been working on a form that
when it is submitted stores the information into a mysql database.
The main problem is that i'm trying to finish up my script for almost
a week now and I still cant get it right.
here is the code

<?php

include ("ES_includes/appconst.inc.php") ;
// Ceck of begin datum juist is
if (!checkdate ($_POST['maand_van'],$_POST['dag_van'],$_POST['jaar_van'])){
echo "De begin datum die u hebt opgegeven is ontjuist <b>"
..$_POST['dag_van']. "/" .$_POST['maand_van']. "/" .$_POST['jaar_van'].
"</b>.<br>";
}
else
{
//check of begin datum reeds in het database staat
$datum= $_POST['jaar_van']."-".$_POST['maand_van']."-".$_POST['dag_van'];
$db = mysql_connect("$dbHost", "$dbUser","$dbPwd");
mysql_select_db($dbName,$db);
$sql_check = "SELECT * FROM verlof WHERE
gebruikersID='$_POST['gebruikersID']' AND datum='$datum'";
$check = mysql_query($sql_check,$db);

if (mysql_num_rows($check) != 0){
echo "Deze datums staan reeds in het databse op uw naam.
";
}
else
{
$sql = "INSERT INTO verlof (gebruikersID, datum, voormiddag,
namiddag, opm_aanvrager) VALUES
('$_POST['gebruikersID']','$datum','$_POST['voormiddag']','$_POST['namiddag']','$_POST['opm_aanvrager']')";
$result = mysql_query($sql);
echo "Uw verlof aanvraag is aangevraagd.
";
}
}
echo "<br><input type=button value="Terug"
onClick="history.go(-1)"><br>";

$datum_van= $_POST['dag_van']."/".$_POST['maand_van']."/".$_POST['jaar_van'];
$datum_tot= $_POST['dag_tot']."/".$_POST['maand_tot']."/".$_POST['jaar_tot'];

$day1="Monday";
$day2="Tuesday";
$day3="Wednesday";
$day4="Thursday";
$day5="Friday";

$mydate=$datum_van;
$newsplit = explode("/", $mydate);
$dat1=mktime(0,0,0,$newsplit[1],$newsplit[0],$newsplit[2]);

$mydate=$datum_tot;
$newsplit = explode("/", $mydate);
$dat2=mktime(0,0,0,$newsplit[1],$newsplit[0],$newsplit[2]);...

View Replies ! View Related

What's The BEST PHP Template Solution?
What's the BEST PHP Template solution?

View Replies ! View Related

Pagination Solution
how to createa pagination just like the one in vBulletin. Yesterday, I asked a question about making sure that I get 10 pages per page, even though some of the things get deleted. I went back to work on that right now, and I can't imagine how easy it is - it's logical too!! I present my solution for those who MIGHT want to know. PHP Code:

View Replies ! View Related

PHP EAI Solution? (vs BizTalk)
I'm tasked with a project where I am responsible for designing and
implementing a solution to an enterprise application integration problem.
This is an e-commerce site which needs to exchange messages with multiple
disparate systems on a frequent basis.

I'm looking for an existing PHP (I would consider other open source)
solutions for consideration.

The features I'd like would be thus:
1. Configurable adapters for connecting to data sources (ftp, soap, file,
db, etc.)
2. Modular pipelining for transforming data and encapsulating business
rules.
3. Both scheduled and event triggered message exchange.
4. Robust logging and notification when failures occur.

There is some internal pressure within the organization to utilize BizTalk
for this problem, but I feel this would be overkill in both capital and
labor costs.

If I can make a convincing argument for linux/apache/php, I can overcome the
pressure to utilize Microsoft and BizTalk.

I'd appreciate being pointed in the direction of any existing php/opensource
framework for this. Having to design and program the solution from scratch
in PHP would be less desirable, but may be possible.

View Replies ! View Related

Looking For A Php Application/solution..
Knowing that there are hundreds of php applications and solutions out there,
and I don't want to re invent the wheel, I am looking for something in php
that will provide a web based solution for me to add/edit/delete records in
a MySQL database/table that must include one BLOB (JPEG) image field.

It's a PEOPLE application that has details on the people that includes a
picture. So, must be able to add(upload) or delete a JPEG image as a BLOB
field to the Table.

(the Table already exists with some 20+ records and most if not all have a
BLOB {jpeg} field included.)

Perhaps there's something out there already that will simply read and
examine an existing table and fields, then generate a simple data
entry/update type page.

Or maybe someone else out there has something like this, or knows of
something like this in GPL, open source, or other?

View Replies ! View Related

Email Solution
An old php mail system I wrote for a client can't handle the load anymore. My client needs to send out about 3000-5000 emails when they are using the newsletter system.

I was looking at PHPMailer, but noticed the last update was July 2005, this doesn't have to mean anything bad of course, but I'm just wondering what systems are out there.

I don't mind paying for a good script so it can be a commercial license. I need something that will handle batch sending...like 250 emails every minute or whatever.

View Replies ! View Related

Standalone Solution
I was asked to write a database solution for a friend.. it was supposed to do the normal add/retrieve/modify/search functions of a databse. i started with vb6 then decided to use php/sql.

I might sound really dumb and ignorant but the question is... if i want to "package" this to him... how can i do this without having to personally go and install a webserver and php and sql and the rest so he can use it just through his web browser?

can i use an installer that will allow it to be packaged so after the install he would just have to open the databsae through his browser?

View Replies ! View Related

Application Solution
the best would be a solution that can read psdÂ´s and replace text in it and check size and fontsize and things like that. or is it possible to make an text over an image thats already filled with the backgournd and then place text over it with a script. so image001 = text001. we need this for thousands of pictures/translations. and it would be good if theres the possibility to pos it form center or change degree by a setting. and stuff like that.

scripts / products / anything.

View Replies ! View Related

Find Solution
I was designed a web site, in my hosting, I still have space to putting another web site, with out return of to hosting manager, there are a code of PHP to that, where leading the browser to (site1.com or site2.com) for example, what the correct code/or function.

View Replies ! View Related

Printing Solution
I'm looking for a solution to print large amounts of data. Basically, what I'm trying to do is: Do a seach on a mysql db >100k records, Print the result set, ~12 records / A4 page. This is pretty huge.~8000 pages. I know I can't put them all in a single html file, it would crash everything. What I'm thinking so far: generate PDF file(s) from PHP and/or use php_printing extension on Win.

View Replies ! View Related

Passphrase To Pgp - Solution
I found the question asked but no solution. It looks like proc_open would work but we have php 4.2.2. The following code works by creating a script that is run by /usr/bin/expect: This is the script:

spawn /usr/bin/pgp -esa /home/user/testfiles/pgp_man.txt DummyUserID
for {} 1 {} {
expect {
"Enter pass phrase:" {
sleep 1;
set send_human {.1 .3 1 .07 .1 .3 .1} ;
send -h "Unsecure Dummy PassPhrase!
"
}
"Overwrite" {
send -h "y
"
}
eof exit.

View Replies ! View Related

PHP Vs JAVA - Is PHP An Enterprise Solution?
I am commencing a project with a guy - and have just received an email of him saying that the project should be writtin all in Java! Now I code in PHP and was interested in his comments:

However there are many things to consider. First we have to standardise on one language to code in. It should be Java and only Java. All professional organisations use Java because it is the language of the network and the internet. Its scalable, reusable, object oriented and extremely powerful.

There is no other means if you want to get this right first time and professionally. There are all too many people out there using languages like Perl and PHP. These are not what we call "Enterprise" solutions

I would like your thoughts on this as I belive as many others that PHP is indeed the language of e-commerce and the Internet.

Also I heard Microsoft was scaling out Java cause of legal action and SUN might not now be able to continue its production due to losing its biggest client.

View Replies ! View Related

Timestamp Or Microtime? Which Is The Better Solution?
I have always used timestamp but see alot of microtime in code I read.

Is there a good reason to use one solution vs. the other?

View Replies ! View Related

PHP Solution To ASP Include Function
I've been offering UNIX based hosting for awhile, but for a prospective client I wish to set up a system where he can update a section of his homepage without having access to the whole webpage.

I wish to show him how to create an MSWindows.doc that he can export as a "Web Page", then FTP it to a special directory. I wish to then have the actual home page access this other page as an "include", placing his data on the home page in its correct place. This keeps him from wrecking the homepage. On a Windows server, I would put an include on the HTML page leading to the content page as in:



but this solution will not work on a UNIX system.

View Replies ! View Related

On Line Store Solution
I've been looking for "open-source-on-line-stores-php-apache-mysql
powered solutions", and I found mainly two:

osCommerce
Zencart

I'm just beginning so I've to choose one of them to give it a try...
Which one you would opt for?

View Replies ! View Related

Looking For Visual Php Development Solution
I have recently been implementing php code in some web pages and am
now looking for a more visual oriented php development environment
because for example creating php/html forms by hand for the x'th time
is not exactly my idea of working efficiently. (Unlike some guys i
work with who seem to think this is an extremely cool working method.
:-/) I'm looking for something with an interface like delphi or vb,
and some of the more visual GUI based web scripting systems out there.
Something where i can click on a web site item, get to the code part
and then work on the code, or maybe first grab some prefab code by
using a template or some kind of code library. I'm sure someone has
implemented such a thing for php, but so far i haven't been able to
locate it.

View Replies ! View Related

PHP Diary/Journal Solution
I've been messing around with my demo Blog page (using the script I
released as open source).

For those that are interested, feel free to visit the URLs below, and
take a copy of the blog script to try for yourself.

BLOG Demo Site
http://www.pluggedout.com/blog

BLOG Development Forum
http://www.pluggedout.com/developme...ewforum.php?f=5

The main reason for writing Blog was to give something back to the
open source community - it's a pretty good example of good programming
style so should be helpful to newbies. So far there are more instances
of the code than I ever imagined there would be, and people are
modifying it to an extent I never though they would either :)

At some point soon I'll try and find time to do the "multiblog"
solution I've been talking about doing for so long. I have the beta
code to do a multi-user version of Blog - it's just a case of wrapping
it up nicely for others to use...

View Replies ! View Related

PHP Pattern Matching - Is There A Better Solution?
One of my weaknesses has always been pattern matching. Something I
definitely need to study up on and maybe you guys can give me a pointer
here.

I'm looking to remove all of this code and just use pattern matching to
determine if the proper amount of numeric characters has been met. Here is
the function I've already done. Any help you can give in a pattern matching
solution would be much appreciated and very educational.

//the $area option is for determining if the user need (or need not) type in
their area code.

function check_phone($phone,$area='y'){
if($area=='y'){
$min=10;
} else {
$min=7;
}

//is there a more direct approach to just count the amount of numbers in
the string by pattern matching?
$phone=str_replace('-','',$phone);
$phone=str_replace('(','',$phone);
$phone=str_replace(')','',$phone);
$phone=str_replace(' ','',$phone);

if(!preg_match('/[d]{'.$min.',}/',$phone)){
return(FALSE);
} else {
return(TRUE);
}
}

View Replies ! View Related

Messy Form Solution
My web-form process input and sends it to me as mail. Fine. But I also would
love to have this input put onto a PDF-document which will be generated on
the fly during post. The PDF will be saved on my server AND mailed to
myself.
I thought that maybe it is possible to get the posted form input on a
csv-file on my web-server (I don't have MySQL). And then, during the process
get this csv data reorganised and to appear organised on a already nearly
finished PDF with prefixed header and footer. The document is mailed to me
and visible in the user window.
I have not invented the power and have to ask: is this possible, anyone who
knows if such a funcationality already exist?

View Replies ! View Related

Seeking Mod_rewrite Solution
I have a people-networking type site in which each user has their own
profile page, with their user id encoded. So, for example, the web
address of their page might look like
"www.example.com/my_profile.php?user_id=fdjkhfh2489298hf298h3s0dhfx j".
I want the users to be able to choose their own web address that would
look like "www.example.com/Joel", and then when they type in that
address, they are automatically redirected to their profile page with
the more complex address.

I believe mod_rewrite is the solution to this?

Reading a little bit about mod_rewrite, I believe the rule I want is
something like the following:

RewriteRule ^/(.*) /redirect_user.php?user_name=$1

So 2 simple questions:
1) does this rule look like what I want?
2) how do I install and hook up the module, and do I write this rule
in the .htaccess file?

View Replies ! View Related

Php Display Solution Required
I have a table in mysql with 2 columns.group name and the group parameters.
There is one group name with several group parameters.

I would like to retrieve this from the database such that it will only display one group and the other several parameters in it,for all the diffrent groups.

does anyone know how i can go about this?

View Replies ! View Related

Shopping Cart Solution
i was looking for a free and simple shopping cart solution in php which doesn't use an external databse like mysql. searching the internet i came accross scripting like osCommerce which is pretty amazing but first of all uses mysql and it would be overkill for my purpose.

All I wanna do is add my own color and nav. to the shopping cart and if possible add and remove products over a form so that i do not have to change the code everytime i have another product.

View Replies ! View Related

CMS Portal Type Solution
I have a client that wants a portal type look where they can manage the content.

View Replies ! View Related

Folder Balance Solution?
I have aroudn 100,000 images uploaded from an upload form which saves the location to my mysql then uploads to the folder I set it to Code:

View Replies ! View Related

Quick Apache Solution
I have re-developed a site locally on my PC and uploaded it to the host server and all has gone bang! I used the Apache ForceType directive to force scripts without an extension to parsed as PHP (I have done this loads of times) but my hosts are saying to me this cannot be done with them and I have to use: Code:

View Replies ! View Related

Finding An Optimal Solution
I have a script that produces an effective grid of information within a PHP data structure such as the following: Code:

View Replies ! View Related

Passing PHP Arrays To Mysql Best Solution
I am relatively new to PHP and until now I have only needed to use relatively simple php/mysql solutions.

I am working on a problem where I need to store CD information (Artist Name, Album Name, Track Names, Catalog Number)

I am working on a solution with two tables "album" and "tracks" and I am using the catalog number as a key to link the two.

The problem I am having is coming up with the best way to populate the tracks table as there are several tracks for each release. I am assuming that an array would be the correct way and maybe a dynamic form to input the tracks where you decide the number you need to add and this then creates a form with "n" input boxes?

View Replies ! View Related

Best Solution For Testing PHP/MySQL Offline?
Can someone please tell me the best solution for testing PHP/MySQL offline on a WindowsME machine please?

View Replies ! View Related

Solution For Redirect At Page Index
by php which the fast solution for make redirection at homepage ?
Time ago read some solutions, but one most fast because not load
or not make a reload of itself page, not remember
exactly but was a solution more fast...

View Replies ! View Related

File Download Solution Tidbit
I struggled with getting file downloads to work in PHP by using various headers. Some earlier posts reported problems with browsers' "save as" dialog box showing the name of the PHP script rather than the file they wanted to download. I was having the same problem until I noticed an example that stripped the path from the filename. The header: PHP Code:

View Replies ! View Related

Solution For Preventing Injection Attacks
I have an idea for preventing sql injection attacks, however it would
have to be implemented by the database vendor. Let me know if I am on
the right track, this totally off base, or already implemented
somewhere...

Lets say you could have a format string such as in printf

$format=" SELECT %s FROM %s WHERE id='%s' ";
$fieldname="last_name";
$tablename="personel";
$id="425";

and you could execute a query like

mysql_query_formatted($format, $fieldname, $tablename, $id);

now, the key is that instead of just adding the $fieldname, $tablename,
$id to the $format string and passing it to mysql_query, it would be
passed to the parser as separate strings. The parser should know how
to handle that format. That way, the parser would always know where
the different tables names, field names, and other strings start and
end. So, the problem of injection attacks caused by some one confusing
the parser by entering things like ' and " is gone.

It would be easier on the programmer. There would be no need to worry
about escape characters when passing to this function, the strings
would not have to be escaped.. The parser would no longer have to
guess where the boundaries are. No more worrying about injection
attacks.

does that make sense?

View Replies ! View Related

Syntax Error Cannot Found Out Solution
I encounter syntax error with this line:
<option <?php if( $rows1['rig_name'] ==?>" <?php echo $rows1['rig_name']; ?>" <?php ) { print "selected"; }?> value="<?php echo $rows1['rig_name']; ?>"><?php echo $rows1['rig_name'];?></option>

Parse error: syntax error, unexpected '' in C:PortableWebApprogramwwwlocalhostdrillcorpmaster_adminprojectupdate_projectupdate.php on line 53 PHP Code:

View Replies ! View Related

** SOLUTION: Apache2, PHP, And The W3C Xhtml Validator **
Firstly, thank you to everyone that replied to my OP. I am new to the PHP
world and so its great that there are people out there who are prepared to
share their knowledge.

Anyway, I am developing a website on my home pc. I dont have server-space
outside my home. So, I needed to be able to validate my code by file
upload to the W3C's html validator at

This solution is so easy, I am surprised that my extensive googling didnt
provide an answer as it does return MANY hits relating to this search. I
thought I would post this so that there is something **out there** for
others that come across this problem.

My original problem was ...

View Replies ! View Related

8GB Video Upload Problem - Solution
in the php.ini,
post_max_size=8M
is the default and file size is 2M. so guess what the post_max_size should
be if the file size is 10MB... 40M.
that's called encode bloat.

sorry to multipost - my news client lost the original post and I didn't have
anything to reply to, and I wanted to provide this.

View Replies ! View Related

Activation-registration-login Solution...
some users after succsesfull registration and login can not see
"memeber_menu" and can not activly participate if forums, galleries
(they are not able to post or upload images)... cookie problem? but just
some of them? why not all of them? if I delete one "cookie" from my
dbase for them, problem is solved.. Code:

View Replies ! View Related

Can Anyone Offer A Solution To A POST'ing Problem
I have a page named register.php, which is a form for collecting user data. As an example:

- I have the fields Name, Surname, email.
- In the <form> tag I have action =""
- The page register.php has a condition
if (isset($_POST['submit'])) {
include('register2.php');
}

- the file register2.php does the error checking etc. - I am using sessions and they do work as I can get this page to work using various methods except for when I display the errors on the same page. Code:

View Replies ! View Related

Java Servlet Problem Solution
I have a PHP script that will be doing an @fopen file open command to a Java servlet, sending content via a query string. Problem is that it appears the Java servlet does not receive anything via its doGet() method and does no action. Has anyone here successfully ever sent anything via PHP to a Java servlet? Tell me what you are supposed to do, I thought it was this simple:

Code: ( php )

View Replies ! View Related

Need Information About E-commerce Solution Process
I am going to make an e-commerce site. But, truly, I have no idea about how to transfer money over internet. This will be a book shop and customer can buy books online. How can I do it? So far I have heard some words like paypal, SSL, https etc.Are these related to e-commerce?

I visited paypal site but I can't see Bangladesh(I am a Bangladeshi) as location in drop down menu at registration process. So I can't registration there. But I can transfer money to another location like Australia.

Whatever, it would be very very helpful for me if you give me detail information about in which ways and how can I sell my books online?

View Replies ! View Related

HTML Email - Portable Solution?
I need to send HTML email using PHP, and the solution needs to be very portable (no need for server installations using PEAR, which as far as I know puts the mime_mail extension out of the question). How can I do this?

View Replies ! View Related

Dadabik W/ Image Manipulation Solution?
Now I would like to add some image manipulation functions so I can crop and resize images when uploading them from anywhere, instead of having to do so with an application prior to uploading.

I've been searching for some hacks for Dadabik but to no avail. Would anyone know of such hacks or altogether alternatives to Dadabik which would include such functionality?

BTW, I'm hosted on Media Temple so I only have access to the GD Library.

View Replies ! View Related

Solution For Generating Image From Screenshot From Flash
I am doing a project in which an icon image is created in flash and the screen shot of that icon image is send to a php file to regenerate that icon image from the screenshot.

View Replies ! View Related

Would A Cookie + Text File Based Solution?
I wrote a web counter that tracks online visitors. Visits are recorded in a MySQL table. But I am considering switching to a text file.

The reason is that I am getting hundreds of simultaneous connections (I operate more than one counter on more than one site) and my server is under too much stress to keep up. Would a cookie + text file based solution be better in my case?

View Replies ! View Related

Page Refresh Problem: An Interesting Solution I Found
I don't know if anybody faces this problem much, but I have faced it
lot of times that page refresh causes the data to enter twice or
request twice. Or, at least a message "Do you really want ..." which a
normal user may not understand.

Today morning, I got an interesting solution and I tried. It worked!!!

if($_POST["a"]){
//do necessary jobs for posted data
header("Location: ".$_SERVER['PHP_SELF'] );
}

View Replies ! View Related

HTML Or Javascript Or PHP Solution: Textarea With Dynamic Width
The customer made a wild request: they want on their admin panel a
textarea that will display an existing resume.

This textarea, however, must have a dynamic width, one that "fills the
screen width of any sized screen".

View Replies ! View Related

MySql Not Enable From IIS But Worksfrom Command Line -- With Partial Solution
Problem: MySQL library bound ONLY when PHP is run from the
command prompt, and NOT when PHP is run from an IIS Web page.
(Error indicates that mysql_connect is an unknown function.)
Not only does the library bind from the command prompt but data is
retrieved using the EXACT same program file that fails under IIS....

View Replies ! View Related