10-31-2011
Of course it does, but it's not an error of MySQL or PHP. When you refresh the page, the browser just sends the same information again, and your table accepts duplicate values. All of this is accepted behaviour, and if you want it different you'll have to change your table to only accept unique values (eg. by using an INDEX), or do the checks with PHP.
8 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
MySQL on my server is down....
I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock
Any suggestions?
Here's what I can't do:
can't be root
don't have physical access (do stuff via SSH)
reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies
2. Shell Programming and Scripting
Okay, I'm new to this PHP and MySQL stuff, so help would be VERY much appreciated. :)
On my iMac runnning Panther, it has MySQL and PHP installed.
Yet when I view a PHP file from the iMac or another computer at my house, I get the source code.
What's wrong? (11 Replies)
Discussion started by: Danny_10
11 Replies
3. Shell Programming and Scripting
No help guys??? :(
Hi guys, i've got a question here... my intention is to write a script that would access a mysql db and extract some info and paste it into a file...
so the first move would be, to access the mysql interface right? hence...
#! /usr/bin/ksh
echo "Job Begin: " `date`
... (1 Reply)
Discussion started by: 12yearold
1 Replies
4. Programming
I m devoloping a website which communicate with Linux server .
Whenever a page is loaded it runs one script on Linux server.
My problem is a simple commands like date , ls runs very smoothly. But whenever i execute big script.It wont display the output.
My knowledge of PHP is very less i m... (2 Replies)
Discussion started by: pinga123
2 Replies
5. Programming
Hello every one
i have question i want to build DATAbase using PHP as interface
i use shell to access to linux . i have in linux psql and SQLplus
i'll call all html files that has db tabels from shell directory.
what should to do before design php pages. can build the database sql design... (3 Replies)
Discussion started by: Scotch
3 Replies
6. Emergency UNIX and Linux Support
Hi,
I have two websites:
website1.com and website2.com
I didn't write either but have successfully moved all the files from website1.com to website2.com
I (thought) I installed all the correct php modules and website2 is mostly up and running. However, my boss found that when we go to a... (15 Replies)
Discussion started by: Astrocloud
15 Replies
7. Programming
Hello,
While I was interpretation the PHP manual on database security the recent past, it said that you should by no means connect to the database as the super user but rather as one more user with more limited options.
My question is:
How do you generate new users and set access... (2 Replies)
Discussion started by: AimyThomas
2 Replies
8. Web Development
Database Structure
Root Table
ID Root_ Node Level
1 A 0
2 B 1
3 C 1
Child Table
ID Left_Node Right_Node Root_Node Root_ID
1 B C A 1
... (1 Reply)
Discussion started by: Deepak Tiwari
1 Replies
LEARN ABOUT PHP
mysql_get_server_info
MYSQL_GET_SERVER_INFO(3) 1 MYSQL_GET_SERVER_INFO(3)
mysql_get_server_info - Get MySQL server info
SYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_get_server_info(3)
o PDO::getAttribute
string mysql_get_server_info ([resource $link_identifier = NULL])
DESCRIPTION
Retrieves the MySQL server version.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns the MySQL server version on success or FALSE on failure.
Example #1
mysql_get_server_info(3) example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
printf("MySQL server version: %s
", mysql_get_server_info());
?>
The above example will output something similar to:
MySQL server version: 4.0.1-alpha
mysql_get_client_info(3), mysql_get_host_info(3), mysql_get_proto_info(3), phpversion(3).
PHP Documentation Group MYSQL_GET_SERVER_INFO(3)