[PHP-DB] Workout Schedule Calendar
Hi Experts, A very good morning to you guys! I need your help with something that I am working on currently, its a web application for Workouts, I've been asked to include a work out schedule calendar and I am not very sure as to how to proceed on the same. *Scenario:* Lets say there are about 100 members in the gym, and every one has a workout schedule of their own, there might be a fixed number of sessions some members might have paid for too, so when each of them see their work out schedule, they see what is the plan that has been suggested to them and how much of their course they already have covered, and how much effective they think it has been. I am getting stuck at the DB structuring part for this. 1) I can have all the different types of workouts entered into the DB with the number of days / sessions thats included in a particular package. 2) and then when a member pays the fees eg: for 3 months (12 sessions) so have 12 entries made into the DB and then map with the members attendance and what he has done on that day. But was wondering if this is an efficient way to do it, over a period of time, there would be 1000s of members, who would be going to the gym for decent period of time. so eg: 1000 member attend the gym for 1 year (365), that makes the total entries in the DB to be 1000s x 365 just for a year! There has to be a better way of doing it! Correct me if I am wrong please. Any help is much appreciated!
[PHP-DB] Billing Module in PHP
I am working on an appplication with a Billing Module. The customers will pay in the following manner. 1) Signing up Fees, at this time they will choose they payment intervals, monthly, quaterly, 6 months or annual. 2) A customer can also change the billing type at a later time, Eg: after paying the signing up fees, he/ she decides to go for quaterly payment, at the end of the term, he / she can then decide to pay monthly or in any other intervals. 3) I checked online and on stack point, i did come across certain helpful articles, but i thought it would be best to ask the experts at sitepoint for their suggestions / advice on the topic too. Currently the DB structure stores the following : 1) Customer details. 2) Membership ID and the payment paid at the time of signing up (I am thinking i might not need the signing up amount to be stored in the customer DB in the first place, and have them seperate in a table called signinupfeespaid or something like) 3) And maybe have another table called 'memberfeesintervals) which will have (membershipid, paymentinterval,nextdueon) and then pick up the pending fees (Customer can also issue part payments) from a pendingfees table Any suggestion is welcome! Thank You in advance!
Re: [PHP-DB] mysql query
$sql2 = insert into Inventory (UPC, quant, manuf, item, orderpt,
ordrpt_flag, stock) values ('$upc', '$qnt','$mnf','$itm', '$odrpt', 0,
$stk);
Looks like, you have the ' ' missing for $qnt and odrpt had the $ and the
'' missing.
The above query should work, I haven't tested it though.
Also for no error, have you turned off the PHP error reporting?
It probably is working on the command line, since you posted actual values
there and in the PHP code, you are using the variables which I think were
not wrapped in the query correctly?
On Thu, Aug 22, 2013 at 12:51 PM, Michael Oki mikeoki@gmail.com wrote:
Try the insertion like this:
$sql2 = mysql_query(insert into Inventory (`UPC`
, `quant`, `manuf`, `item`, `orderpt`, `ordrpt_flag`, `stock`)
.values ('$upc', $qnt,'$mnf','$itm',
'$odrpt', '0', '$stk') ) or die(mysql_error());
On 22 August 2013 05:10, Daniel Krook kr...@us.ibm.com wrote:
Ethan,
What about:
$result2 = mysqli_query(cxn, $sql2);
Doesn't look like you're sending it a connection link as a variable
($cxn)
and that's passed through as a literal?
Thanks,
Daniel Krook
Software Engineer, Advanced Cloud Solutions, GTS
IBM Senior Certified IT Specialist - L3 Thought Leader
The Open Group Certified IT Specialist - L3 Distinguished
Cloud, Java, PHP, BlackBerry, DB2 Solaris Certified
Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote on 08/21/2013
11:59:19 PM:
From: Ethan Rosenberg erosenb...@hygeiabiomedical.com
To: Daniel Krook/White Plains/IBM@IBMUS
Cc: PHP Database List php-db@lists.php.net
Date: 08/21/2013 11:59 PM
Subject: Re: [PHP-DB] mysql query
On 08/21/2013 11:30 PM, Daniel Krook wrote:
Ethan,
It's hard to tell from the code formatting in your email what the
exact problem might be, but a few reasons that this might fail in
PHP rather than when sent to MySQL with hardcoded values:
1. var_dump/print_r $_POST to see what you're getting as input is
what you expect (and sanitize!).
2. Check that the SQL statement concatenation in PHP is building
the string you're expecting. It looks like you're joining 2 strings
when defining $sql2 that doesn't leave a space between the close
parentheses and values. Compare this against what you're sending
on the command line.
3. Get rid of all single quotes... escape your double quotes where
needed. This will avoid any variable-in-string interpolation errors
and may help you find the issue with input data. Same with your echo
$sql2 statement... that's not going to give you the same thing as
the print_r below it.
Thanks,
Daniel Krook
Software Engineer, Advanced Cloud Solutions, GTS
IBM Senior Certified IT Specialist - L3 Thought Leader
The Open Group Certified IT Specialist - L3 Distinguished
Cloud, Java, PHP, BlackBerry, DB2 Solaris Certified
Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote on 08/21/
2013 07:48:12 PM:
From: Ethan Rosenberg erosenb...@hygeiabiomedical.com
To: PHP Database List php-db@lists.php.net
Date: 08/21/2013 07:48 PM
Subject: [PHP-DB] mysql query
Dear List -
I can't figure this out
mysql describe Inventory;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| UPC | varchar(14) | YES | | NULL | |
| quant | int(5) | NO | | NULL | |
| manuf | varchar(20) | YES | | NULL | |
| item| varchar(50) | YES | | NULL | |
| orderpt | tinyint(4) | NO | | NULL | |
| ordrpt_flag | tinyint(3) | YES | | NULL | |
| stock | int(3) | YES | | NULL | |
+-+-+--+-+-+---+
Here are code snippets -
$upc = $_SESSION['UPC'];
$qnt = $_POST['quant'];
$mnf = $_POST['manuf'];
$itm = $_POST['item'];
$odrpt = $_POST['oderpt'];
$opf = $_POST['ordrpt_flag'];
$stk= $_POST['stock'];
$sql2 = insert into Inventory (UPC,
quant,
manuf, item, orderpt, ordrpt_flag, stock)
.values ('$upc',
$qnt,'$mnf','$itm',
odrpt, 0, $stk);
$result2 = mysqli_query(cxn, $sql2);
echo '$sql2br /';
print_r($sql2);
echo br /$upc $qnt $mnf $itm $odrpt
$opf
$stkkbr /;
if (!$result2)
Re: [PHP-DB] Re: mysql query
Jim, I know this is a stupid question to be asking this far into PHP
Development, maybe was a bit lazy, or just got too used to Notepad++, which
editor for PHP are you using? The feature which you mentioned for a good
php editor, sounds exciting, offcourse i would be looking only at the free
ones :D
On Thu, Aug 22, 2013 at 9:24 PM, Jim Giner jim.gi...@albanyhandball.comwrote:
On 8/22/2013 9:52 AM, Jim Giner wrote:
On 8/21/2013 7:48 PM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql describe Inventory;
+-+-+-**-+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+-**-+-+-+---+
| UPC | varchar(14) | YES | | NULL | |
| quant | int(5) | NO | | NULL | |
| manuf | varchar(20) | YES | | NULL | |
| item| varchar(50) | YES | | NULL | |
| orderpt | tinyint(4) | NO | | NULL | |
| ordrpt_flag | tinyint(3) | YES | | NULL | |
| stock | int(3) | YES | | NULL | |
+-+-+-**-+-+-+---+
Here are code snippets -
$upc = $_SESSION['UPC'];
$qnt = $_POST['quant'];
$mnf = $_POST['manuf'];
$itm = $_POST['item'];
$odrpt = $_POST['oderpt'];
$opf = $_POST['ordrpt_flag'];
$stk= $_POST['stock'];
$sql2 = insert into Inventory (UPC, quant,
manuf, item, orderpt, ordrpt_flag, stock)
.values ('$upc', $qnt,'$mnf','$itm',
odrpt, 0, $stk);
$result2 = mysqli_query(cxn, $sql2);
echo '$sql2br /';
print_r($sql2);
echo br /$upc $qnt $mnf $itm $odrpt $opf
$stkkbr /;
if (!$result2)
die('Could not enter data: ' .
mysqli_error());
The mysql query fails. I cannot figure out why. It works from the
command line.
TIA
Ethan
Ethan - you are simply missing two dollar signs as pointed out. Once
you correct them, if there are any more errors you should then be seeing
the message from mysqli_error.
And as for the advice to dump single quotes, I'd ignore it. The use of
double and single quotes is a very handy feature and makes for very
readable code. Escaping double quotes is such a royal pia and makes for
more trouble deciphering code later on. The sample you provided for us
is some of the best and most understandable code you've ever showed us.
Also - Ethan - if you used an editor that was designed for php you
probably would have seen these missing $ signs since a good one would
highlight php syntax and the lack of the $ would have produced a different
color than you expected.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: mysql query
Thanks Toby, Using Notepad ++ with the language selected to PHP, the syntax coloring is on On Thu, Aug 22, 2013 at 11:00 PM, Toby Hart Dyke t...@hartdyke.com wrote: Notepad++ will do syntax highlighting. Go to Language P PHP with a PHP file open, and see the colours change! It should be automatic - are you using something other than 'php' as a file extension? Toby On 8/22/2013 5:27 PM, Vinay Kannan wrote: Jim, I know this is a stupid question to be asking this far into PHP Development, maybe was a bit lazy, or just got too used to Notepad++, which editor for PHP are you using? The feature which you mentioned for a good php editor, sounds exciting, offcourse i would be looking only at the free ones :D On Thu, Aug 22, 2013 at 9:24 PM, Jim Giner jim.gi...@albanyhandball.com **wrote: Also - Ethan - if you used an editor that was designed for php you probably would have seen these missing $ signs since a good one would highlight php syntax and the lack of the $ would have produced a different color than you expected. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mysql PDO statement with params in HAVING problem
$stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as
full_name,t.* FROM `specialists` `t` HAVING full_name like '%:query%');
How about '%:$query%' instead of '%:query%' ? Does that solve the problem?
Thanks,
On Thu, Jun 27, 2013 at 5:21 PM, Alexander Pletnev
pletnev.rusa...@gmail.com wrote:
Hi everyone, im new here, so please correct me if i created or formated
topic incorrectly.
I found a problem. I have a simple query for my needs:
$stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as
full_name,t.* FROM `specialists` `t` HAVING full_name like '%john%');
$stmt-execute();
while($row = $stmt-fetch())
{
echo 'pre'; var_dump($row); echo '/pre';
}
It works fine, until i add a param to my query:
$stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as
full_name,t.* FROM `specialists` `t` HAVING full_name like
'%:query%');
$stmt-execute();
$query = 'londo';
$stmt-bindParam(':query',$query);
while($row = $stmt-fetch())
{
echo 'pre'; var_dump($row); echo '/pre';
}
Now there is nothing in fetch(). Is it a bug ?
Thanks.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] School timetable in php
hey, I am trying to develop a school time table system in php mysql, anybody has any headsup on the same, i was thinking about some existing scripts to take a look at. Thanks, Vinay
Re: [PHP-DB] Engine?
Awesome Thank You Guys! A better scalable DB was on my mind, looks like I might have to go for much before I thought I might have to go ahead with :) Going through the resources provided, Thank You for the headsup!! Vinay Kannan. On Mon, Apr 16, 2012 at 4:44 PM, Matijn Woudt tijn...@gmail.com wrote: On Mon, Apr 16, 2012 at 1:09 PM, Bastien phps...@gmail.com wrote: Bastien Koert On 2012-04-16, at 2:21 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote: Hello, I've always been left wondering what Engine to use while creating tables, I've read quite a few times about the same on wiki, articles etcbut haven't actually been able to decide. I wanted to know whats the storage engine used on MySQL on big web application, the application i am developing currently, is kinda really big and data intensive, we are looking at about 1,00,000 registration atleast in the first few months, and their data lets say, each will have about 10-20 operations, accounts etc... So the data can get really big and troublesome to maintain, I am more concerned about the data safety, as in crash recovery or auto backups etc... Basically, if the MySQL DB crashes, we sholdnt be at a loss, and all the data till the very last operation should be available as a backup. Any headsup on this please? Thanks, Vinay Kannan. Maybe google MySQL innodb. I think they have rollback and table locking. As well as foreign key capabilities. Limited exp. Sorry not much more help. Best, InnoDB with replication should get you close to what you need. But it sounds like you are also requiring some High Availability architecture so you may want to look at fail overs using Heartbeat or some other tool to automatically switch over to a new master. Check out the http://www.mysql.com/products/enterprise/high_availability.html or google 'MySQL high availability' Or maybe you should look at a other databases than MySQL, there are a few that scale much better. Google for scalable database, and you'll find some. - Matijn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Engine?
Hello, I've always been left wondering what Engine to use while creating tables, I've read quite a few times about the same on wiki, articles etcbut haven't actually been able to decide. I wanted to know whats the storage engine used on MySQL on big web application, the application i am developing currently, is kinda really big and data intensive, we are looking at about 1,00,000 registration atleast in the first few months, and their data lets say, each will have about 10-20 operations, accounts etc... So the data can get really big and troublesome to maintain, I am more concerned about the data safety, as in crash recovery or auto backups etc... Basically, if the MySQL DB crashes, we sholdnt be at a loss, and all the data till the very last operation should be available as a backup. Any headsup on this please? Thanks, Vinay Kannan.
[PHP-DB] Session and Access Privilages.
Hey, I am working on the application, thought its not OOP currently, I plan to take it further in a year or so. Right now, I have 4 access levels which define what the users can do on the application. Based on the access levels defined, a session varialble is set called $_SESSION['authtype'], and this defines what are the links shown to the user. so basically the session authtype, defines what links are shown to the users, now i am thinking that if a user comes to know of a link whihc he does not have access to, he / she can put that in the url and try to gain access, what i feel is there should be some check on each of the page for the access and if the acess criteria is not met, then the user should be sent back to him home page view. Any ideas on what the best way is to implement something like this? Any help is appreciated. Thanks, Vinay
Re: [PHP-DB] Session and Access Privilages.
Yup, With some help from Jey earlier today, I was able to figure it out.. I only realized it later, how easy it was since all the auth types were being set already, the same piece of code at the beginning of every page should have been good ! Thanks, Vinay On Thu, Mar 29, 2012 at 7:28 PM, Govinda govinda.webdnat...@gmail.comwrote: Hey, I am working on the application, thought its not OOP currently, I plan to take it further in a year or so. Right now, I have 4 access levels which define what the users can do on the application. Based on the access levels defined, a session varialble is set called $_SESSION['authtype'], and this defines what are the links shown to the user. so basically the session authtype, defines what links are shown to the users, now i am thinking that if a user comes to know of a link whihc he does not have access to, he / she can put that in the url and try to gain access, what i feel is there should be some check on each of the page for the access and if the acess criteria is not met, then the user should be sent back to him home page view. Any ideas on what the best way is to implement something like this? Any help is appreciated. Thanks, Vinay Hi Vinay If you are already checking your $_SESSION['authtype'] var, to know whether or not to display certain links.. then you can just add the same kind of checking at the top of any code that should be reserved for a certain level of user. If someone without proper access has hacked the URL then just redirect to your login page, or whatever you want to do to the intruders. HTH -Govinda
Re: [PHP-DB] PDO Vs MySQLi Vs SQL Queries.
Hi Trevor,
Thank You for your suggestion, yeah i think caching is something i
definitely want to look at and something thats important, and there is a
big project coming up, its pretty much the biggest i've taken up so far,
theres also a mobile app for android which needs to be done, so caching
definitely is something i wanna look at.
I've also downloaded RedBean, will play around on the same, looks Cool ! :)
Thanks,
Vinay
On Tue, Feb 28, 2012 at 4:31 PM, Donahue Trevor donahue.tre...@gmail.comwrote:
Hi Vinay,
No, using native mysql_* statement isn't always faster. Advantages are
obvious, as mentioned in the article you shared (object mapping, security,
performance), there's always things like caching and other stuff you don't
want to reinvent the wheel for and on big projects tend to be really
useful. So imho it's better using things like pdo.
Another thing... try using ORM http://redbeanphp.com sliced my dev type
in 4 :)
On Tue, Feb 28, 2012 at 6:22 AM, Vinay Kannan viny...@gmail.com wrote:
Hey Guys,
I came across this article.
http://net.tutsplus.com/tutorials/php/pdo-vs-mysqli-which-should-you-use/
Though I've been working with PHP for over 2 yrs, i never bothered to use
the techniques mentioned in the articles like this.
What i do for DB connections and queries..is just simple sql queries in
php,
$sql={sql query};
$runsql=mysql_query($sql);
What i do take care is to clean the user inputs before querying the DB.
Is this a good way? Coz i've seen more experienced programmers using the
techniques mentioned in the article, with PDOs, MySQLi etc...
I always thought there is a chance that these might slow the querying
process?
Please advice.
Any help is appreciated.
Thanks,
Vinay Kannan.
[PHP-DB] PDO Vs MySQLi Vs SQL Queries.
Hey Guys,
I came across this article.
http://net.tutsplus.com/tutorials/php/pdo-vs-mysqli-which-should-you-use/
Though I've been working with PHP for over 2 yrs, i never bothered to use
the techniques mentioned in the articles like this.
What i do for DB connections and queries..is just simple sql queries in php,
$sql={sql query};
$runsql=mysql_query($sql);
What i do take care is to clean the user inputs before querying the DB.
Is this a good way? Coz i've seen more experienced programmers using the
techniques mentioned in the article, with PDOs, MySQLi etc...
I always thought there is a chance that these might slow the querying
process?
Please advice.
Any help is appreciated.
Thanks,
Vinay Kannan.
[PHP-DB] query help
Hello PHP Gurus, I need your help on an insert query. I wanted to know if there is way to insert an array of values into a DB. An eg would explain this better : If I have 2 tables in a DB, 1) users has 3 columns 2) hobbies = 5 columns I was thinking of having a single function which will perform the insert on any insert which happens on the entire website. Eg : This function can be called with 2 parameters, the first parameter the table name, and the second parameter is an array of values which will be inserted into the table. eg : Users has these columns [1]ID [2] Name [3]Location so the function call would be something like * insert_into_tbale(users,array[user_values])* ** Does this make sense ? Is this a good method to follow ? Thanks in advance ! Vinay Kannan.
[PHP-DB] formatting a word doc using php ?
Hello Xperts, I am trying out a couple of things and have come across this requirement, where in a php script should create a doc file with specific formatting, I can create the file, havent tried it yet, but shouldnt be a problem I guess, but how do I format the doc file is the question, google search didnt give good results too :( So not even sure if it can be done actually. Thanks, Vinay
Re: [PHP-DB] Re: Need Help with database output
Whats Dreamweaver php codes. It automatically does the coding ?? Never even knew about such a thing Thanks, Vinay On Mon, Aug 30, 2010 at 9:44 PM, nagendra prasad nagendra802...@gmail.comwrote: Hi All, Thanks for all your replies. I have found what I needed. I used Dreamweaver to show the database in 3 different columns. However now I don't know how to add a search engine to it. Right now its showing all the records in my database in 3 columns. Now I want to put a search engine code so that user can search data whatever he wants. I see the difference in normal php codes and Dreamweaver php codes. Please suggest me how to add a search engine script to the existing 3 column script. Best, Guru.
Re: [PHP-DB] finding out if a user left our website ?
Thank you everyone window.onunload() function works perfect, thats what I was looking for !! Thanks, Vinay Kannan. On Thu, Aug 26, 2010 at 3:24 AM, kesavan trichy rengarajan k...@trk7.comwrote: Have a look at this: https://developer.mozilla.org/en/DOM/window.onunload https://developer.mozilla.org/en/DOM/window.onunloadBut, as someone pointed out a few days ago, please do not post stuff that is not related to PHP DB. On Thu, Aug 26, 2010 at 6:32 AM, Vinay Kannan viny...@gmail.com wrote: Hello Guys, Wanted to know if there is a way for us to find out, when a user moves away from our website( closing the window and entering a different url in the address bar ) closing the window i guess, we could use the javascript onclose or something similar but for the user moving away from my website by entering a different URL is what i would like to be able to find out. Thanks, Vinay
[PHP-DB] finding out if a user left our website ?
Hello Guys, Wanted to know if there is a way for us to find out, when a user moves away from our website( closing the window and entering a different url in the address bar ) closing the window i guess, we could use the javascript onclose or something similar but for the user moving away from my website by entering a different URL is what i would like to be able to find out. Thanks, Vinay
Re: [PHP-DB] Unable to connect to mysql database
I am guessing the message unable to connect to database is something you have echoed on a die() or as an error message, could you tell us what is the step before this. Also just check if the database is set correctly, and the user name and the password is correct. Some hosts use the host as localhost, some others do it differently. some hosts have your primary user name perpended to the database username etc... Check the configs. I believe its got to do with the host or username/password Thanks, Vinay On Wed, Aug 11, 2010 at 12:36 AM, 3dgtech syst...@3dgtech.com wrote: Hi there, You will have to adjust the configuration file (configuration.php) in your root folder for the new site. var $host = ; var $user = ; var $db = ; they have to reflect the new settings. Hope that helps. Eli Aschkenasy -Original Message- From: nagendra prasad [mailto:nagendra802...@gmail.com] Sent: Tuesday, August 10, 2010 12:18 PM To: phpexpe...@yahoogroups.com; PHP DB; php-wind...@lists.php.net Subject: [PHP-DB] Unable to connect to mysql database Hi All, I am working on a site which is developed in joomala. We have our domain on www.net4.in. Initially we have tested the site on the WAMP server locally. On the wamp server its working fine, however when we tried to configure it on www.net4.in its not working at all. The site is giving an error called unable to connect to database. I have already configured the config file. Can anyone tell me how to connect the script with the database? Dose anyone have any experience working on www.net4.in control panel? Best, Guru. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows
Thanks for your reply Maarten, Its a hotel management application for a hotel.. Thanks, Vinay On Fri, Aug 6, 2010 at 1:03 PM, maarten maarten.fo...@edchq.com wrote: Hello, without further information, it is not really possible to give any kind of indication that a web app can replace the original app. We do not know what the original app is supposed to do, how it works, ... Having said that, I think most apps would be possible to transform to some web app. That does not mean it is generally a good or bad idea, that depends on the situation. Since you already suggested you are avoiding the process of an installable software, I think that may actually be what you are trying. regards, Maarten On Fri, 2010-08-06 at 07:45 +0530, Vinay Kannan wrote: Hi, I need some help and its actually got nothing to do with any coding help. My friend owns a business and has been using a software developed on VB6.0 installed on a Windows XP it is a bit outdated though and I personally feel the company which sold the software has overdone the sales, coz I personally feel its way too crappy. Now that my buddy has asked me to get a software developed for him if I would like to. I am thinking that since I am more of a web app guy than the traditional software developer, would it make any sense to develop an application which would run on localhost on a Ubuntu Desktop ? I am not sure if it does sound like an appropriate alternative or does it sound like someone trying to avoid the process of an installable software ? Also if it can be done, then Ideally what are the things that I should be taking care off ? and was really keen to know how many of you have come across situations like these and offered solutions like this if atall Thanks, Vinay Kannan. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows
Actually there is no customer registrations happening, its just a resturant and there wouldnt be any registrations and stuff, its a valid point of hosting it on a webserver and building it like any web app, but then internet connection might also be a problem in that area, and if the internet doesnt work well, the entire app doesnt work, So for the long term like you said it would be made available as a hosted application, but still the system needs to be able to perform all the functions even as a stand alone. Thanks, Vinay On Sat, Aug 7, 2010 at 1:11 AM, Mike Stowe mikegst...@gmail.com wrote: Just a stupid question... But if you build it as a web app hosted on a server, wouldn't that provide for easy development of an online, customer end registration portal-- assuming they have a website? I know that's not what the original ? was, just trying to think long term. - Mike Sent from my iPhone On Aug 6, 2010, at 1:13 PM, Vinay Kannan viny...@gmail.com wrote: Thanks for your reply Maarten, Its a hotel management application for a hotel.. Thanks, Vinay On Fri, Aug 6, 2010 at 1:03 PM, maarten maarten.fo...@edchq.com wrote: Hello, without further information, it is not really possible to give any kind of indication that a web app can replace the original app. We do not know what the original app is supposed to do, how it works, ... Having said that, I think most apps would be possible to transform to some web app. That does not mean it is generally a good or bad idea, that depends on the situation. Since you already suggested you are avoiding the process of an installable software, I think that may actually be what you are trying. regards, Maarten On Fri, 2010-08-06 at 07:45 +0530, Vinay Kannan wrote: Hi, I need some help and its actually got nothing to do with any coding help. My friend owns a business and has been using a software developed on VB6.0 installed on a Windows XP it is a bit outdated though and I personally feel the company which sold the software has overdone the sales, coz I personally feel its way too crappy. Now that my buddy has asked me to get a software developed for him if I would like to. I am thinking that since I am more of a web app guy than the traditional software developer, would it make any sense to develop an application which would run on localhost on a Ubuntu Desktop ? I am not sure if it does sound like an appropriate alternative or does it sound like someone trying to avoid the process of an installable software ? Also if it can be done, then Ideally what are the things that I should be taking care off ? and was really keen to know how many of you have come across situations like these and offered solutions like this if atall Thanks, Vinay Kannan. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows
Hi, I need some help and its actually got nothing to do with any coding help. My friend owns a business and has been using a software developed on VB6.0 installed on a Windows XP it is a bit outdated though and I personally feel the company which sold the software has overdone the sales, coz I personally feel its way too crappy. Now that my buddy has asked me to get a software developed for him if I would like to. I am thinking that since I am more of a web app guy than the traditional software developer, would it make any sense to develop an application which would run on localhost on a Ubuntu Desktop ? I am not sure if it does sound like an appropriate alternative or does it sound like someone trying to avoid the process of an installable software ? Also if it can be done, then Ideally what are the things that I should be taking care off ? and was really keen to know how many of you have come across situations like these and offered solutions like this if atall Thanks, Vinay Kannan.
Re: [PHP-DB] Image linking help in PHP
So basically you want to be able to associate an image with an Mp3, and the path to the mp3 is stored in the DB, right ? If above is the case, why dont you upload the image to an image folder, and save the path to the image in the DB too along with mp3 path details, I think this should work ! Thanks, Vinay On Sun, Jul 4, 2010 at 10:50 PM, nagendra prasad nagendra802...@gmail.comwrote: Thanks Jason, However will this work if each time let say a variable called $mp_url will change. I hope you know what I meant. The MP3 link will not be constant, but the image file link could be constant. I already linked the MP3 link with its own name (Text ) and its working but now I want to replace the MP3 name (Text) with an image because the song name will be the heading of the page so no need to echo out twice right. Best, Guru.
[PHP-DB] session management
Hey Guys, I need some help on an effficient session management, right now what I do is check if the user has loggedin using his username, and create a SESSION['logged']=1, setting a login flag actually, I am not sure if this is the best way ? What do you guys use for sessions, and which is the best possible way ? Thanks, Vinay
Re: [PHP-DB] session management
Hi Jason, Yes this is going to be a public facing application with 3 level heirarchy, and maybe around 100 tiny companies(3-4 employees) using it. App is going to be on a Hosted Server. DB session mgmt would be a bit slower, is it? I have thought about cross site forgery and session hijacking, but the more I think about it, I realize the lesser I know about it all :( So thought this would be the best place to start. Thanks, Vinay On Thu, Apr 22, 2010 at 11:19 AM, Jason Gerfen jason.ger...@scl.utah.eduwrote: How secure would you want it? Is this is a public facing web application? Are you in a shared hosting environment vs. a dedicated hosting environment? Do you require alternative session management such as database or mcache vs. flat file session support? Have you thought about cross site request forgery's? session hijacking etc? There are tons of things to take into consideration but setting a flag per user session is indeed one method of ensuring a user has authenticated. Vinay Kannan wrote: Hey Guys, I need some help on an effficient session management, right now what I do is check if the user has loggedin using his username, and create a SESSION['logged']=1, setting a login flag actually, I am not sure if this is the best way ? What do you guys use for sessions, and which is the best possible way ? Thanks, Vinay -- Jas
[PHP-DB] reading PDF file into a DB
Hello Guys, I am working on a project, which requires a PDF file to be read page wise into the DB, once it has been uploaded, the contents from the PDF would then appear on a Flash screen. I need help reading the contents of the PDF file into DB retaining the page numbers, does anyone have an idea how this can be accomplished, i hope someone here has done this before :) Thanks, Vinay
Re: [PHP-DB] Re: help needed.
Yes, the data would be updated, I am not really good at XML, havnt had a chance to work with XML, so was trying to avoid it as much as I can, but I guess if it thats what it takes, then would have to sit down and start working on it now :) On Thu, Mar 18, 2010 at 8:11 AM, Gunawan Wibisono landavi...@gmail.comwrote: flash? why not using xml.. is the data will be update? this good aplication i think On Thu, Mar 18, 2010 at 4:10 PM, Nadim Attari na...@alienworkers.com wrote: Hello, Maybe these can help. Web Server on CD: http://ampstart.ly-le.info/ http://www.stunnix.com/ http://www.server2go-web.de/ http://www.indigostar.com/microweb.php PHP EXE Compiler/Embedder : http://www.bambalam.se/bamcompile/ p.s.: Make sure you encode your PHP codes before distributing... Vinay Kannan wrote: Hello Guys, I am developing an application, which would have a front end in Flash, and the backend would be MySQL, now what I am thinking is to package this as an exe file, similar to WAMP, which installs everything, So my exe should have all my files, the MySQL data dump and should auto install PHP, APACHE, MySQL, can something like this be done, i am sure it can be done, but how do I do it, any guidelines please? Thanks, Vinay Kannan. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- akan ada dimana mulut terkunci dan suara tak ada lagi.. saat itu gunakanlah HP untuk melakukan SMS!! - ini aliran bedul.. bukan aliran aneh. tertawa sebelum tertawa didepan RSJ..
Re: [PHP-DB] Online PHP-Mysql Meeting
Hey, We could also use a web sharing application, theres this one web sharing application i know for presentations, but the trial version is restricted to 25 at a time. Thanks, Vinay Kannan. On Mon, Mar 15, 2010 at 1:35 AM, nagendra prasad nagendra802...@gmail.comwrote: Hi David, I am glad that you are in. However don't worry about the presentation stuff. If you Google Online free presentation, you will find your answer. So, Guys lets start making some plan. I have created a Google spreadsheet. Please put your Ideas and topics about the meeting. Here is the link: http://spreadsheets.google.com/ccc?key=0AvOd4XuevVJndEx0dEJxZklBcEpYdi1HcFZrT0tTcEEhl=en Please feel free to add few more columns if needed.
[PHP-DB] help needed.
Hello Guys, I am developing an application, which would have a front end in Flash, and the backend would be MySQL, now what I am thinking is to package this as an exe file, similar to WAMP, which installs everything, So my exe should have all my files, the MySQL data dump and should auto install PHP, APACHE, MySQL, can something like this be done, i am sure it can be done, but how do I do it, any guidelines please? Thanks, Vinay Kannan.
[PHP-DB] help in implementing a progress bar
Hello, Theres this project that I am working on, and a specific module does take few secs to process, I am thinking it would be cool to be showing a progress bar(some kind on a .gif image) while the script runs, does any one have an idea how to implement this? Thanks, Vinay K
Re: [PHP-DB] auto creation of email IDs
Hey Thanks Barry, Yeah, I want to be able to creat email accounts automatically, when people get themselves registered on the website, this should be done automatically, you are right about the temp email id, that would change and the email IDs generated would be permanent, which would be deleted after couple of months. So basically, what I am looking at is, a way to be able to create email IDs on a Linux server, when people post comments, how can this be done? Thanks, Vinay Kannan. On Thu, Dec 17, 2009 at 4:38 PM, Barry Stear bst...@gmail.com wrote: When the users register are you wanting to create a email account for them on your server or are you wanting to use a email address that they already have? It is possible to create a temporary email id but I am not sure how you would be able to tie this back to the person so they would actually receive replies back to this topic if you have no information for them and they are just creating a topic. The best thing would be to require them to register in order to post a topic. Thats my thoughts on it...
Re: [PHP-DB] auto creation of email IDs
Thanks a lot for all your replies, I appreciate the workarounds, all of them are great, but my concern is to get the work done in this particular way, does any one know how this can be done? On Fri, Dec 18, 2009 at 2:11 PM, Karl DeSaulniers k...@designdrumm.comwrote: I would stamp it with their IP address + current time if they are just posting comments. Or user ID + current time if they are registered users leaving comments. This may be more of a workaround, but it will get you unique numbers. Karl Sent from losPhone On Dec 18, 2009, at 9:39 AM, Vinay Kannan viny...@gmail.com wrote: Hey Thanks Barry, Yeah, I want to be able to creat email accounts automatically, when people get themselves registered on the website, this should be done automatically, you are right about the temp email id, that would change and the email IDs generated would be permanent, which would be deleted after couple of months. So basically, what I am looking at is, a way to be able to create email IDs on a Linux server, when people post comments, how can this be done? Thanks, Vinay Kannan. On Thu, Dec 17, 2009 at 4:38 PM, Barry Stear bst...@gmail.com wrote: When the users register are you wanting to create a email account for them on your server or are you wanting to use a email address that they already have? It is possible to create a temporary email id but I am not sure how you would be able to tie this back to the person so they would actually receive replies back to this topic if you have no information for them and they are just creating a topic. The best thing would be to require them to register in order to post a topic. Thats my thoughts on it...
[PHP-DB] auto creation of email IDs
Hey Guys, I've been at this for couple of days now, and have no clue where to start, and was almost thinking about scrapping the project, It would be great help if anyone can give me some advice, or guide me in the right direction. I have a portal, where users would come in and register and create an account, as soon as an account is created, I want to be able to auto create an email ID for them, the server would be Linux, any ideas on how this can be done. And also an option of creating a temporary email ID, upon creating a topic or some kind of a post. Could anyone guide me in the right direction or help me on this one, please ? Thanks in Advance, Vinay Kannan.
[PHP-DB] Redirect upon successful form submission
Hi, I have 2 pages on php, the first page has a small form to accept a membership number from the user, which checks for membership number in the DB, if the membership no does not exist, gives an error saying 'you are not a member click here to become a member now', this bit works fine. The problem is the following bit 'if the user is a member, i want the user to be directed to another page. this is what i did to get the result since header(Location:) wont work, as already the form has been printed on the page. echo'META HTTP-EQUIV=refresh content=0;URL=member.php'; but the problem is that this takes couple of seconds, till then the page is very much visible which doesnt look good. Any help on this is much appreciated. Thanks, Vinay.
Re: [PHP-DB] Redirect upon successful form submission
Thanks Bastien,
To be honest I have no clue as to how to hold the form in the buffer. I've
copied the code below, that might help I guess.
?php include(header.php);
include(lib/funcs.php);
$url=$_SERVER['REQUEST_URI'];
$member_no=$_POST['member_no'];
$member_no=trim(htmlspecialchars($member_no));
$not_member=1;
if(isset($_POST['submit']) $_POST['trigger']==6)
{
// echo $member_no;
$conn=mysql_connect($host,$user,$pass) or die(Could not open the
connection);
$dbselect=mysql_select_db($dbname,$conn) or die(could not connect to the
DB);
$id_query=SELECT * FROM members WHERE member_id='$member_no';
$result = mysql_query($id_query) or trigger_error(SQL, E_USER_ERROR);
$num_rows=mysql_num_rows($result);
//echo $num_rows;
if($num_rows0)
{
echo'META HTTP-EQUIV=refresh content=0;URL=member.php';
}
else
{
$not_member=0;
}
}
?
td width=420 class=whitebg
BR /
h3 align=leftREFERENCE FOR MEMBERSHIP TO INFINITY LEARNERS CLUB/h3
p
In order to be able to refer members to Infinity LMRC, you need to be a
registered member with us, Please enter your membership number below and
start referring./p
table width=410
form action=?php echo $url ; ? method=post name=refer
table
tr
tdlabel for=membernoMembership Number/label/td
tdinput type=text name=member_no class=myinput //td/tr
trtdnbsp;/td/tr
trtdinput type=submit name=submit value= OK ! //td
tdinput type=reset name=cancel value= Cancel //td/tr
trtdinput type=hidden name=trigger value=6 //td/tr
/table
/form
?php
if($not_member==0)
{
echo 'Our records indicate that you are not a member yet, a
href=member.php Click here/a to become a member now';
}?
/td
?php include(footer.php);?
/body
/html
On Tue, Dec 15, 2009 at 10:09 AM, Bastien Koert phps...@gmail.com wrote:
On Tue, Dec 15, 2009 at 12:48 PM, Vinay Kannan viny...@gmail.com wrote:
Hi,
I have 2 pages on php, the first page has a small form to accept a
membership number from the user, which checks for membership number in
the
DB, if the membership no does not exist, gives an error saying 'you are
not
a member click here to become a member now', this bit works fine.
The problem is the following bit 'if the user is a member, i want the
user
to be directed to another page.
this is what i did to get the result since header(Location:) wont
work, as already the form has been printed on the page.
echo'META HTTP-EQUIV=refresh content=0;URL=member.php'; but the
problem is that this takes couple of seconds, till then the page is very
much visible which doesnt look good.
Any help on this is much appreciated.
Thanks,
Vinay.
What about holding the form in the buffer, and then dealing with the
buffer before sending the form?
--
Bastien
Cat, the other other white meat
Re: [PHP-DB] Redirect upon successful form submission
Yep, that would work, but then if the user is not a member, then the link to the membership should be printed on the form that has the validation and not the one that has the form? On Tue, Dec 15, 2009 at 10:21 AM, Christoph Rosse c...@okto.tv wrote: you could also validate the form in a seperate php file with no output and then redirect to the error and the another page ? Bastien Koert schrieb: On Tue, Dec 15, 2009 at 12:48 PM, Vinay Kannan viny...@gmail.com wrote: Hi, I have 2 pages on php, the first page has a small form to accept a membership number from the user, which checks for membership number in the DB, if the membership no does not exist, gives an error saying 'you are not a member click here to become a member now', this bit works fine. The problem is the following bit 'if the user is a member, i want the user to be directed to another page. this is what i did to get the result since header(Location:) wont work, as already the form has been printed on the page. echo'META HTTP-EQUIV=refresh content=0;URL=member.php'; but the problem is that this takes couple of seconds, till then the page is very much visible which doesnt look good. Any help on this is much appreciated. Thanks, Vinay. What about holding the form in the buffer, and then dealing with the buffer before sending the form? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP on Pear
Hello, I've been programming on PHP for almost a year now, many examples that I've gone through or some of the reference books that I've read and many websites which show examples of PHP pgramming seem to be using PEAR package, and I've never used PEAR or any other Package, I was wondering whats the advantage of using PEAR instead of the using PHP directly in the code or maybe even creating our own functions in PHP. I am really confused about this now, earlier I used to neglect these things, but now I curious and getting a little impatient coz I am starting some work on a project for myself, and I would want to keep changing the code all the time. Can someone guide me on this please? Thanks, Vinay Kannan.
[PHP-DB] scheduler
Hi, I am developing a web application in PHP, the db is mysql. I want to develop something like a batch file, which would run everyday, query mysql and throw the output to another table which would then perform some additional functions. Is something like this possible?? i am working on windows thats why said a batch,but not rigid about the batch, it cud even be Java. Thanks, Vinay
Re: [PHP-DB] scheduler
Thank You Neil ! So if I write in a command like C:\php\php.exe C:\path\to\script.php in a batch file, and have another batch file to run it at given time frames, then the PHP file would make the updates and perform the functionalities that its required to do, is it? coz what I have on my mind is that the tasks are run and the functions are performed even if theres no one to run in the command, that can be done right? Vinay Kannan. On Wed, Sep 23, 2009 at 5:40 PM, Niel Archer n...@chance.now wrote: Hi, I am developing a web application in PHP, the db is mysql. I want to develop something like a batch file, which would run everyday, query mysql and throw the output to another table which would then perform some additional functions. Is something like this possible?? i am working on windows thats why said a batch,but not rigid about the batch, it cud even be Java. Not only possible but very simple. Just write the php as normal and use Windows' Scheduler to run it with something like: C:\php\php.exe C:\path\to\script.php I have several scripts like this scheduled to do basic maintenance work or carry out automated tasks. Thanks, Vinay -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Need help in PHP file Management System
Hi Nagendra, Any progress on the task you were at? On Fri, Sep 18, 2009 at 12:40 AM, nagendra prasad nagendra802...@gmail.comwrote: Eric, I am new to file or content management. So, if possible can you send me few scripts or some links from where I can learn more about it? Best,
Re: [PHP-DB] Need help in PHP file Management System
I would think, since you already have different users, so most probably you would be getting them registered, so maybe at the time of the registration, you could create folders for each user, and the files they upload would be on to the folders with their username, the folder securities on the server should be taken care of. for instance, if the user is say, Vinay (thats me) and ur website is www.abcdefg.com then when i register, it would create a folder for me, so the url would be something like www.abcdefg.com/vinay, and the files uploaded by me would be in the folder vinay, but the files would be accesible to me alone, not the other visitors of the website. Guys please correct me if I am wrong, but I think this is a good possible way of doing it. Thanks, Vinay Kannan On Thu, Sep 17, 2009 at 10:05 AM, nagendra prasad nagendra802...@gmail.comwrote: Hi All, I need help in PHP file management system. So, I am working on my project in which user will upload a file on the server. I know how to upload a file on server using PHP. But the problem is how to differentiate the different uploaded files with different users. Please help me with this. Best, -- Guru Prasad Ubuntu Voice GTK+ Forum
