PHP - Problem In Mysql_query Insert With On Duplicate Key

Hi Friends !

I need to discuss a problem with you.
When we fill a customer info form, and redirect to other page. but go back by browser's back button and resubmit the form.
In this case duplicate data is inserted. Or when we refresh a page multiple data is inserted, so HOW TO AVOID this terrible problem ?

On the index page of http://www.sportskevesti.co i have the meta tags of Title, Description, Keyword.... and other element, but it is necessary to show them in name of the other pages, socer, basketbal, handbal, tennis...., and there fore news spetial.

in this moment, i have this meta tag double.

for example:

www.sportskevesti.co/index.php
Quote

<meta name="title" content="Sportske Vesti">
<meta name="description" content="Najnovije sportske vesti iz Srbije i ostatka sveta. Sve na jednom mestu.">
<meta name="keywords" content="sport, vesti, fudbal, tenis, kosarka, odbojka, rukomet, auto, moto, trke">



http://sportskevesti.co/index.php?opcija=vest&vest_id=60067
Quote

<meta name="title" content="Sportske Vesti">
<meta name="description" content="Najnovije sportske vesti iz Srbije i ostatka sveta. Sve na jednom mestu.">
<meta name="keywords" content="sport, vesti, fudbal, tenis, kosarka, odbojka, rukomet, auto, moto, trke">

<meta name="title" content="Danas je derbi!" />
<meta name="description" content="Na stadionu Crvene zvezde danas se igra ..." />
<meta name="keywords" content="danas, derbi, "/>



Since I assume that this is not good for SEO optimization, how to avoid this and show only one meta per page ?

OK So I have a quick question... how would I go about making a query like:
mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password' AND key='$key' ");
You see, theres an error:
Quote

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' key='1234' LIMIT 1' at line 1


I know this is a simple issue, and I know you cant keep creating AND's inside the query, but how would I do it? I've never attempted to use more than one AND before, so its new to me even though I'm a experienced PHP Developer. Thanks in advance!

I am getting a "mysqli_query() expects parameter 1 to be mysqli, null given" error.

the code I am using is below but simplified. connect() does connect to the database without throwing any errors but when I get down to query() I get the above error.

public function connect() {
  mysqli_connect(self::DBHOST, self::DBUSER, self::DBPASS, self::DBNAME);
}
public function query($query) {
                 mysqli_query(self::connect(), $query);
}


below is what I am using to call the function. I am not sure if I have to pass the $link in the query function too. I have tried but it didn't seem to do any better.

$link = db::connect();

$query = "SELECT name FROM plugins";

db::query($query);


I am sure this is something simple that I have overlooked but I am new to this and still learning.

Thank you for any help you can provide.

Hi, why won't this work, there is no error messages so it gets to this point, but won't redirect???
(Obviously a lot is missed out here)

$query = mysql_query("SELECT * FROM `users` WHERE `username`='$username'");
if ($username==$dbusername&&$password==$dbpassword)
{ 
$_SESSION['user'] = $username;

while($row = mysql_fetch_array($query)){ 
$type = $row['Type'];
if ($type=="0") {
header("Location: chefpanel.php");
}else{
header("Location: restpanel.php");
}
}  

}
else
 $errors[] = 'Password Incorrect';
}
else
 $errors[] = 'Username Incorrect';

Hey Guys,

Im having problems with my code. What im trying to do is run a mysql query and show the results, but if the query returns no data, echo out "No incoming requests!"

Here is my code:


<?

$check = "SELECT * FROM requests WHERE club='" . $_SESSION['club'] . "' AND team='" . $_SESSION['team'] . "' AND accepted='0'";
$result=mysql_query($check);

if (mysql_num_rows($result) == 0) {

while ($getinfo = mysql_fetch_array($result)) {
            $time = $getinfo["time"];
    $who = $getinfo["player_name"];
    $whofor = $getinfo["toplayfor"];
    $from = $getinfo["team"];
    $idp = $getinfo["player_id"];

echo "<a href='profile.php?id=".$idp."&team=".$from."'>".$who." </a><div style='float:right;'>(".$from.")</div><br />";
echo "<div style='margin-top: 2px;'></div>";
echo date('l, F jS, g:ia',$time);
echo "<br /><div style='margin-top: 2px;'></div><a href='accept.php?playerid=".$idp."&toplayfor=".$whofor."'>Accept</a> | Decline";
echo "<div id='newsline'></div>";
}
}

 else {
 echo 'No incoming requests'; }

?>

Could someone help me out here?

Thanks Heaps!

Hey guys, I've been playing around with this open source php game, I'm having problems with the registration system. For some reason the script is echoing back that there is no password in the password fields. When in fact there is:

Add_player.php:
Code: [Select]
<?php

session_start();
session_register("pid");
include("common.inc");
include("date.inc");
include("header.inc");
dbConnect();
$res = mysql_query("select id from $dbName.pdm_players where name=\"$name\"") or die(mysql_error());

if ($name == "" || $password1 == "")
{
        echo "<center><div class=\"sheader\">Oh dear me!</div>
         You have to actually enter a name and password!";
        $name = "";
        include("character_form.inc");
        echo "</center>";
        include("footer.inc");
        return 0;
}
if ($name == $password1)
{
echo "<center><div class=\"sheader\">Oh dear me!</div>
You can't make the password the same as the name.  
People will guess your password!";
include("character_form.inc");
        echo "</center>";
        include("footer.inc");
        return 0;
}
if (strlen($password1) < 6)
{
 echo "<center><div class=\"sheader\">Oh dear me!</div>
Passwords must be at least 6 characters, otherwise they are easy to guess!";
include("character_form.inc");
        echo "</center>";
        include("footer.inc");
        return 0;
}

if (mysql_fetch_row($res))
{
        echo "<center><div class=\"sheader\">Oh dear me!</div>
         Player $name already exists, try a different name.";
        $name = "";
        include("character_form.inc");
        echo "</center>";
        include("footer.inc");
        return 0;
}
if ($password1 != $password2)
{
        echo "<center><div class=\"sheader\">Oh dear me!</div>";
        echo "The two passwords didn't match - type carefully now!.";
        include("character_form.inc");
        echo "</center>";
        include("footer.inc");
        return 0;
}
echo "<div class=\"sheader\">Registration for $name successful</div>";
$cp = crypt($password1);
$dateArray = getdate(time());
$likeNowScoob = $dateArray["year"] . "-" . $dateArray["mon"] . "-" . $dateArray["mday"];
if ($character < 1 || $character > 9) { die("you are an idiot"); }
pdm_characters();
$res =  mysql_query("select type from  $dbName.pdm_characters where cid = $character")  or die(mysql_error());
$t =  mysql_fetch_row($res);
pdm_stuff();
$specRes =  mysql_query("select sid from $dbName.pdm_stuff where sid >= 28 and sid <= 33 and type like \"%$t[0]%\"") or die(mysql_error());


$res =  mysql_query("BEGIN")  or die(mysql_error());
$res =  mysql_query("insert into $dbName.pdm_players (name, used, dob, cpass, char_id, roundswon, evo, aWeapon, dWeapon) VALUES (\"$name\", 1, \"$likeNowScoob\",  \"$cp\",  $character, 0,0,0,0)") or die(mysql_error());
$res =  mysql_query("select id from $dbName.pdm_players where name=\"$name\" for update") or die(mysql_error());
$row = mysql_fetch_row($res);
$pid = $row[0];
$res = mysql_query("insert into $dbName.pdm_league (id, highest, days_no_1, yesterday, longPoints) VALUES ($pid, 16777215, 0, 16777215, 0)") or die(mysql_error());
$res =  mysql_query("insert into $dbName.pdm_stats (id, level, attack, defence, health, speed, exp, ko, healthpercent, fights) VALUES ($pid, 1, 100, 100, 100, 100, 0, 0, 10, 0)") or die(mysql_error());
$res =  mysql_query("insert into $dbName.pdm_clanmembers2 (id, clanTag, applyTag, utype) VALUES ($pid, NULL, NULL, '')")  or die(mysql_error());
$res =  mysql_query("insert into $dbName.pdm_money (id, bank, wallet, bankdate) VALUES ($pid, 0,0, '0000-00-00')")  or die(mysql_error());
while ($row = mysql_fetch_row($specRes))
{
$res =  mysql_query("insert into $dbName.pdm_specials (id, sid, qty, switch) values ($pid, $row[0], 0, 1)")  or die(mysql_error());
}
$res =  mysql_query("COMMIT") or die(mysql_error());


session_register("playerName");
$playerName = stripper($name);

echo "<P><diV>Welcome  $playerName, click the Fight link down the left to fight your first opponent.</div>";
include("main_screen.inc");
include("footer.inc");
?>

Character_form.inc:

Code: [Select]
<center>
<form method="post" action="add_player.php">
<P>
<table cellpadding="0" cellspacing="0"><tr><td align="center">
<?php
dbConnect();
pdm_characters();#check HEAP table exists
$res = mysql_query("select cid, name, type from $dbName.pdm_characters order by type") or die(mysql_error());
$marker = "X";
$firstOne = 1;
$cTypes["A"] = "Alien";
$cTypes["M"] = "Magic";
$cTypes["S"] = "Spirit";
while ($row = mysql_fetch_row($res))
{
        if ($marker != $row[2]) #new type (alien/magic etc)
        {
                if ($marker != "X")
                {
                        echo "</table>\n";
                }
                $cn = $cTypes[$row[2]];
                echo "\n<table cellpadding=\"0\" cellspacing=\"0\" border=1>
                <tr><td colspan=\"3\" align=\"center\"><div class=\"sheader\"> $cn characters</div></td></tr><tr bgcolor=\"#efefef\">";
                $marker = $row[2];
        }
        echo "\n<td><table><tr><td align=center>$row[1]</td></tr><tr><td align=center>
        <img alt=\"Pick me!\" src=\"images/$row[0]0.gif\"></td></tr><tr>
        <td align=center><input type=\"radio\" name=\"character\" value=\"$row[0]\"";
        if ($firstOne and $character == "")
        {
                $firstOne = 0;
                echo " CHECKED ";
        }
        if ($character == $row[0])
        {
                echo " CHECKED ";
        }
        echo "></td></tr></table></td>";
}
echo "</tr></table>
<table width=\"551\" cellpadding=0 cellspacing=0><tr><td colspan=\"3\"><div class=\"sheader\">character details</div></td></tr>
<tr><td align=\"center\">Name<br><input size=20 maxlength=20 type=text name=\"name\" value = \"$name\"></td>";
?>
<td align="center">Password<br><input type="password" name="password1"  size=20 maxlength=20></td>
<td align="center">Password again<br><input type="password" name="password2" size=20 maxlength=20></td></tr>
<tr><td colspan="3" align="center"><input type="submit" value="Register my character"></td></tr></table>
</td></tr></table>
<hr>
</form>
</centER>

Anyone able to offer up any advice or where its going wrong, If I remove the validation stuff, it still doesn't insert the user into the database.

Cheers

Hey guys for some reason this code is not working i can't see a problem myself could someone please have a look and point the issue out to me. what i mean by it not working is it won't insert into the database or show a mysql_error.

thanks in advance

Code: [Select]
$guestip = $_SERVER['REMOTE_ADDR'];
$time = date('G:i');
$date = date("y-m-d");

$query = mysql_query("SELECT * FROM IP_Address") or die(mysql_error());
while($row = mysql_fetch_assoc($query)){
   
    if($guestip != $row['ip']){
        //insert into db.
        mysql_query("INSERT INTO IP_Address(id, ip, date, time) VALUES(NULL,'$questip','$date','$time')") or die(mysql_error());
        echo "inserted in to database"; echo mysql_error();
    }else{
        // add hit count and update time and date.
        echo "already in db";
    }
}

This php file cant echo in the 2nd php code, can anyone help me about this?
1st php code to connect into the 2nd php code
Code: [Select]
<?php
$Total = $Total + $Amount;
}
?>

</tr>
<tr>
    <td colspan="3" align="Right">Total</td>
    <td align ="Center"><?php echo number_format($Total,2);?></td>
</tr>
2nd php code
Code: [Select]
<?php
$db = mysql_connect("localhost", "root", "");
mysql_select_db("vinnex",$db);
$TransNo = $_POST['TransNo'];
$Username = $_POST['Username'];
$Date = $_POST['Date'];
$Total = $_GET['Total'];
echo $Total;
$sqltransaction = " INSERT INTO transaction (TransNo, Username, Date, Total)
VALUES ('$TransNo', '$Username', '$Date', '$Total')";
$resulttransaction = mysql_query($sqltransaction);
?>

I have an old site written for PHP 5.4 and under and trying (very trying) to get it to work with PHP 7x without much luck. Due to all the changes in 7 my code is one big error message, but one thing at a time. I cannot get the follow code to work at all, even though it worked in PHP 5.

Error:

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'viewuser.php?u=666' id='member'>THE PREDATOR [666] was added to the hit' at line 1
The Query was INSERT INTO gangevents VALUES('','20', UNIX_TIMESTAMP(),'THE  PREDATOR [666] was added to the hit list.')

I have tried at least 20+ different ways of doing this but just can't get the right syntax to get it inserted into MySQL, the code below is just the latest version.  If I echo the a href line out, it works perfect. 

I am sure it is something ridiculously simple, but I have been 4 hours and counting on this now.

Thanks

gangevent_add_2($gangdata['gangID'], "<a href='viewuser.php?u=".$r['userid']."' ".$csscode[$r['userlevel']-1].">".$r['username']."</a> [".$r['userid']."] was added to your hitlist");

function gangevent_add_2($gang, $text) { 
	global $db; $csscode; 
	$db->query("UPDATE users SET gangevent = gangevent + 1 WHERE gang={$gang}");
	$db->query("INSERT INTO gangevents VALUES('','$gang', UNIX_TIMESTAMP(),'$text')");
}

 

Hi,

I am trying to insert the contents of a csv file into a table, this is my code:


public function InsertCSVFileToDB(){

$has_title_row = true;
$not_done = array();

        if(is_uploaded_file($_FILES['csvfile']['tmp_name'])){
            $filename = basename($_FILES['csvfile']['name']);

            if(substr($filename, -3) == 'csv'){
                $tmpfile = $_FILES['csvfile']['tmp_name'];
                if (($fh = fopen($tmpfile, "r")) !== FALSE) {
                    $i = 0;
                    while (($items = fgetcsv($fh, 10000, ",")) !== FALSE) {

                        if($has_title_row === true && $i == 0){ // skip the first row if there is a tile row in CSV file
                            $i++;
                            continue;
                        }

                        $sql = "INSERT INTO ConfPaper SET
                                CPRid = ".$items[0].",
                                Pid = ".$items[1].",
                                CPtitle = '".mysql_real_escape_string($items[2])."',
                                CPabstract = '".mysql_real_escape_string($items[3])."',
                                CPspage = ".mysql_real_escape_string($items[4]).",
                                CPepage = ".mysql_real_escape_string($items[5]).",
                                CPlastesited = now()";
                        if(!mysql_query($sql)){
                            $not_done[] = $items;
                        }
                        $i++;
                    }
                }
                // if there are any not done records found:
                if(!empty($not_done)){
                    echo "<strong>There are some records could not be inserted</strong><br />";
                    print_r($not_done);
                }
            }
            else{
                die('Invalid file format uploaded. Please upload CSV.');
            }
        }
        else{
            die('Please upload a CSV file.');
        }
    }


This is the csv file:

http://www.prima.cse.salford.ac.uk:8080/~ibrarhussain/ConfPaper.csv

But i keep getting this:

Quote

Array ( => Array ( => 9 [1] => 1 [2] => CSV1 [3] => 4 [4] => 4 [5] => 01625 584412 ) [1] => Array ( => 9 [1] => 1 [2] => CSV2 [3] => 14 [4] => 24 [5] => 01625 584412 ) )

Any ideas what the problem might be?

Hope someone can help..

Thanks

I have done a simple insert query on a comment system but it works once and when i go back and try add another record it just doesnt work at all.

Code: [Select]
<?php 

include ("class.database.connection.php");   // the database connection class
include ("settings.config.php");  // hostname, password ect

$name = $_POST["UserName"];
$email = $_POST["UserEmail"];
$comment = $_POST["UserComment"];

$sql="INSERT INTO comments (name, email, comment)VALUES('$name', '$email', '$comment')";
$result=mysql_query($sql);


?>
if anyone can help me with this i would be a happy chappy!