Jump to content

phpnewbei

Members
 View Profile  See their activity

  • Posts

    32

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by phpnewbei

    Update multiple rows in PHP with UPDATE!

    in PHP Coding Help

    Posted

    As the title says I need help with multiple update system.. Can't really get it to work at all >.<

    Here's some code:

     

    $selectt = mysql_query("SELECT * FROM exercises WHERE user='" . $_SESSION["user"] . "' AND exname='" . $_GET["edit"] . "'");
echo '<form method="POST" action="exercises.php?edited">';
echo '<div id="newexx">';
while($raw = mysql_fetch_array($selectt))
{
echo '<input type="text" name="up[' . $raw["id"] . ']" value="' . $raw["swe"] . '">';
echo '<input type="text" name="up1[' . $raw["id"] . ']" value="' . $raw["eng"] . '"><br>';
echo '<input type="hidden" name="id[' . $raw["id"] . ']">';
} 
echo '</div>';
echo '<input type="submit" value="Update Exercise">';
echo '</form>';
if(isset($_GET["edited"]))
{
$swe = $_POST["up"];
$eng = $_POST["up1"];
$id = $_POST["id"];
foreach($id as $value => $index)
{
$update = "UPDATE exercises SET swe='".$swe."', eng='".$eng."' WHERE id='".$index."'";
mysql_query($update);
}

     

    Would be thankful for reply!

    Profile page PHP

    in PHP Coding Help

    Posted 

    <?php
echo "<div id=\"homeform\">";
if(isset($_SESSION["username"])){
$link1 ='
<a href="members.php?uname&changeinfo=' . $_SESSION["username"] . '"> Change information </a>';
$uname = isset($_GET['uname']) ? $_GET['uname'] : 'guest';
if($_SESSION["username"] == $uname){
echo "hej";
echo $link1;

}
elseif ($_SESSION["username"] == $_GET["changeinfo"]) {
$sql = mysql_query("SELECT * FROM userinfo WHERE username='" . $_SESSION["username"] . "'");
while($row = mysql_fetch_array($sql)){
echo '<form method="POST" action="members.php?uname&changeinfo=' . $_SESSION["username"] . '">';
echo '<input type="text" name="name" value=' .  $row["firstname"] . '>';
echo '<input type="submit" name="submit" value="Change">';
echo '</form>';
$firstname = $_POST["name"];
mysql_query("UPDATE userinfo SET firstname='$firstname' WHERE username='" . $_SESSION["username"] . "'");
}
if($_POST["submit"])
{
echo "Success!";
}
}
else {
echo "du suger";
}
echo "</div>";
}
?>

    Profile page PHP

    in PHP Coding Help

    Posted

    Now, If I write something in my input fields and update, it works, but when I go back and change the information again, the field in my database gets emtpy :S

    My guess would be that when the database have been update, nothing happends, you'll return to the input field again.

    Profile page PHP

    in PHP Coding Help

    Posted

    Now I have an UPDATE error heh, here's my code:

     

    elseif ($_SESSION["username"] == (isset($_GET["changeinfo"]))) {$sql = mysql_query("SELECT * FROM userinfo WHERE username='" . $_SESSION["username"] . "'");while($row = mysql_fetch_array($sql)){echo "<form method=\"POST\" action=\"members.php?uname&changeinfo=" . $_SESSION["username"] . "\">";echo "<input type=\"text\" name=\"name\" value=\"" .  $row["firstname"] . "\">";echo "<input type=\"submit\" value=\"Change\">";echo "</form>";$firstname = isset($_POST["name"]);mysql_query("UPDATE userinfo SET firstname='$firstname' WHERE username=" . $_SESSION["username"] . "");}}

     

    Profile page PHP

    in PHP Coding Help

    Posted

    Need some help with Profile page, it goes like this: 

    <html>
<head>
<style type="text/css" media="all">
@import url("style.css");
</style>
</head>
<body>
<div id="header">
<h1><a href="index.php">ProjecTM</a></h1>
</div>
<div id="menu">
<ul>
<a href="index.php">News</a>
<a href="guestbook.php">Guestbook</a>
<a href="changepassword.php">Change Password</a>
<a href="logout.php">Log out</a>
</ul>
</div>
<?php
include("dbconnect.php");
session_start();
echo "<div id=\"homeform\">";
if(isset($_SESSION["username"])){
$link1 ='
<a href="members.php?uname&changeinfo=' . $_SESSION["username"] . '"> Change information </a>';
if($_SESSION["username"] == isset($_GET["uname"])){
echo "hej";
}
elseif ($_SESSION["username"] != isset($_GET["uname"])) {
echo "hejdå";
}
}
echo "</div>";
?>
</body>
</html>

     

    THe link to the profile page goes like this: 

    echo "<a href=\"members.php?uname=" . $user . "\">Your page</a>";

    Problems with UPDATE and undefined index

    in PHP Coding Help

    Posted

    Yeah it was set, but at sometimes it wasn't! But now I deleted almost everything to do a fresh start, I noticed I messed up every code I had haha :) Anyone know how you do a "Profile Page"? I want to do, if($_SESSION["username"] == $_GET["uname"]){

    echo "Edit your information";

    }

    else{

    echo "Checking someone elses profile";

    }

     

    Here's my code:

    <html>
<head>
<style type="text/css" media="all">
@import url("style.css");
</style>
</head>
<body>
<div id="header">
<h1><a href="index.php">ProjecTM</a></h1>
</div>
<div id="menu">
<ul>
<a href="index.php">News</a>
<a href="guestbook.php">Guestbook</a>
<a href="changepassword.php">Change Password</a>
<a href="logout.php">Log out</a>
</ul>
</div>
<?php
include("dbconnect.php");
session_start();
echo "<div id=\"homeform\">";
if(isset($_SESSION["username"])){
$link1 ='
<a href="members.php?uname&changeinfo=' . $_SESSION["username"] . '"> Change information </a>';
if($_SESSION["username"] == isset($_GET["uname"])){
echo "hello";
}
elseif ($_SESSION["username"] != isset($_GET["uname"])) {
echo "goodbye";
}
}
echo "</div>";
?>
</body>
</html>

    Problems with UPDATE and undefined index

    in PHP Coding Help

    Posted

    Notice: Undefined index: uname in C:\wamp\www\project\members.php on line 26

     

    Notice: Undefined index: uname in C:\wamp\www\project\members.php on line 39

     

    Notice: Undefined index: changeinfo in C:\wamp\www\project\members.php on line 46

     

    Here's the code: 

    <html>
<head>
<style type="text/css" media="all">
@import url("style.css");
</style>
</head>
<body>
<div id="header">
<h1><a href="index.php">ProjecTM</a></h1>
</div>
<div id="menu">
<ul>
<a href="index.php">News</a>
<a href="guestbook.php">Guestbook</a>
<a href="changepassword.php">Change Password</a>
<a href="logout.php">Log out</a>
</ul>
</div>
<?php
include("dbconnect.php");
session_start();
echo "<div id=\"homeform\">";
if(isset($_SESSION["username"])){
$link1 ='
<a href="members.php?uname&changeinfo=' . $_SESSION["username"] . '"> Change information </a>';
Line 26 -> if($_SESSION["username"] == $_GET["uname"]){
echo "<h3>Here you can change private information, what you would like to show to other users and change account information!</h3>";
$uname = $_GET["uname"];
$sql = mysql_query("SELECT * FROM userinfo WHERE username='$uname'");
echo "<div id=\"loginform\">";
while($row = mysql_fetch_array($sql)){
echo "Förnamn: " . $row["firstname"] . "<br>";
echo "Efternamn: " . $row["lastname"];
}
echo "</div>";
echo $link1;
}
else {
Line 39 -> $hamta = $_GET["uname"];
$sql = mysql_query("SELECT * FROM userinfo WHERE username='$hamta'");
while($row = mysql_fetch_array($sql)){
echo ($row["firstname"]) . " ";
echo ($row["lastname"]) . " ";
}
}
Line 46 -> if ($_GET["changeinfo"] == $_SESSION["username"]){
echo "byt saker";
$hamta = $_GET["changeinfo"];
$sql = mysql_query("SELECT * FROM userinfo WHERE username='$hamta'");
if(isset($_GET["submit"])){
$update = "UPDATE userinfo SET firstname='$firstname' WHERE username=machram";
mysql_query($update);

}
while($row = mysql_fetch_array($sql)){

echo "<form method=\"get\" action=\"members.php?uname&changeinfo=\"" . $_SESSION["username"] . "&\">";
echo "Förnamn: ";
echo "<input type=\"text\" name=\"firstname\" value=\"" . $row["firstname"] . "\">";
echo "<input type=\"submit\" name=\"submit\">";
}
}
}
echo "</div>";
?>
</body>
</html>

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.