Need some help stopping multiple signups.. php/mssql


HOME ยป Databases
It's been a couple years now since I've worked on website on a daily
basic.. I thought you could never really forget how to program, but I
am running a small project now and I am moreless confused on how to
fix an issue..
I have a simple signup page requesting a username,
password, password2 and email. I currently check only to see if the
username exists and show an error if it does.
What I need to do
is to also added new hidden fields for IP, calling
$_SERVER['REMOTE_ADDR'] which I can do. I basically need a way to
check to make sure accounts can not be made from the same user. I know
people can change their IP with software and still, in some cases the
ip can be dynam

Hello All
Its me again, I don`t know if I can explain
this right but how can I do this in MSSQL.
Example I have this
Employee Log Table with the following columns.
ID Name Log
Count
1 Mark 1
2 Adrew 1
3 Mark 2 />Now when I will insert again the Name Mark with Log Count 1 database
should not allow because it will be duplicate.
Please help me. />Thanks in advance.
Databases
php -v gives:
PHP Warning: PHP Startup: mssql: Unable to
initialize module
Module compiled with module API=20050922,
debug=0, thread-safety=0
PHP compiled with module API=20060613,
debug=0, thread-safety=0
These options need to match
in
Unknown on line 0
PHP Warning: PHP Startup: pdo_dblib: Unable to
initialize module
Module compiled with module API=20050922,
debug=0, thread-safety=0
PHP compiled with module API=20060613,
debug=0, thread-safety=0
These options need to match
in
Unknown on line 0
PHP 5.2.10 (cli) (built: Aug 10 2009
05:20:34)
Copyright (c) 1997-2009 The PHP Group
Zend Engine
v2.2.0, Copyright (c) 1998-2009 Zend T
Development
It's been a couple years now since I've worked on website on a daily
basic.. I thought you could never really forget how to program, but I
am running a small project now and I am moreless confused on how to
fix an issue..
I have a simple signup page requesting a username,
password, password2 and email. I currently check only to see if the
username exists and show an error if it does.
What I need to do
is to also added new hidden fields for IP, calling
$_SERVER['REMOTE_ADDR'] which I can do. I basically need a way to
check to make sure accounts can not be made from the same user. I know
people can change their IP with software and still, in some cases the
ip can be dynam
Databases

I having 3 tables:



This table is used to store customer's infos



Customers
ID Name
1 'Company A'
2 'Company B'
3 'Company C'


This table save the order log



Orders
ID CustomerID Quantity Date
1 1 200 01/01/2001
2 1 150 01/02/2001
3 2 500 01/02/2001
4 3 200 01/03/2001
5 2 400 01/03/2001
6 3 200 01/04/2001


This table to save the price, let's assume that I sell only 1
product, and each Customer have a seperate price for their own and the
total quantity like this



example: for customer ID 1, the total quantity between FROM 0 TO
100 THEN the PRICE for each one is 200



Price
CustomerID From To Price
1 0 100 200
1 101 500 190
1 501 ? 180
2 0 150 195
2 151 800 180
2 801 ? 170
3 0 400 180
3 401 ? 180


I want my output look like this:



Name          TotalQuantity            Price
Company A 350 190
Company B 900 170
Company C 400 180


I know that I need to SUM the Quantity first then compare with
Price table below but how can I do that? and what should I put in "?"
erm... for example more than 501, 801, 401 in that Price table?

Web Development

How to zip multiple files stored in VARBINARY and allow the user to
download on-the-fly?



I've tried ZipArchive::addFile() however the first parameter it is
a real "filename" :(

Web Development

i want connect to mssql server with php. i have installed
"Microsoft Drivers for PHP for SQL Server" and added some lines in
extension part of php.ini. but in phpinfo there wasn't any mssql info.
only "--without-mssql" "--without-pdo-mssql" parameters in Configure
Command.

Web Development

- Technology - Languages
+ Webmasters
+ Development
+ Development Tools
+ Internet
+ Mobile Programming
+ Linux
+ Unix
+ Apple
+ Ubuntu
+ Mobile & Tablets
+ Databases
+ Android
+ Network & Servers
+ Operating Systems
+ Coding
+ Design Software
+ Web Development
+ Game Development
+ Access
+ Excel
+ Web Design
+ Web Hosting
+ Web Site Reviews
+ Domain Name
+ Information Security
+ Software
+ Computers
+ Electronics
+ Hardware
+ Windows
+ PHP
+ ASP/ASP.Net
+ C/C++/C#
+ VB/VB.Net
+ JAVA
+ Javascript
+ Programming
Privacy Policy - Copyrights Notice - Feedback - Report Violation 2018 © BigHow