PHP - Choosing Id When Inserting A Row

Code: [Select]
elseif($_GET['rma']=="issue"){
session_start();
$rma_id=$_GET['id'];
$_SESSION['rma_id']=$rma_id;
$rma_issued=$_POST['rma_issued'];
if($rma_issued=="y"){
$length = 2;
$characters = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
$string= microtime(true);
for ($p = 0; $p < $length; $p++) {
$string .= $characters[mt_rand(0, strlen($characters))];
}
for ($p = 0; $p < $length; $p++) {
$string2 .= $characters[mt_rand(0, strlen($characters))];
}
$string="".$string2."".$string;
$string=explode(".",$string);
$string=$string[0].$string[1];
$rma_number=$string;
date_default_timezone_set('US/Eastern');
$rma_date_issued = date("F j, Y, g:i A T");
$rma_month_issued = date("m");
$rma_year_issued = date("Y");

$sql2000000="UPDATE $tbl_name4 SET rma_number='$rma_number', rma_issued='$rma_issued', rma_date_issued='$rma_date_issued', rma_month_issued='$rma_month_issued', rma_year_issued='$rma_year_issued', returned='n' WHERE rma_id = $rma_id";
mysql_query($sql2000000);
header("Location: ./acp_admincp.php?rma=issued");
}

The above isn't inserting anything into the DB... not even the Date information.

when i insert a new topic into the database its id is generated by the auto incrememnt field tid.
but what i do next is insert the post for that new topic in the post table which has p_pid(post id) and p_tid(the topic id it is for). so how do i generate that p_tid when the topic has just been inserted. i used to do it by inserting the topic then running a query to pull the newest topic if from the database which would mean the post belonged to that topic. but what happens when people are posting several topics at the same time?

Hey, Basically the script runs fine except for the fact its just inserting one user instead of multiple users, anyone have a clue as to why? would be a huge hand, Cheers

Code: [Select]
<?php
if (isset($_POST["submit"]) && $_POST["submit"] == "Recall Selected Informants")
{
//Force POST values to be INTs
$addIDs_ary = array_map('intval', $_POST['chkInv']);
//Remove any 'false' value
$addIDs_ary = array_filter($addIDs_ary);
//Check that there was at least one valid value
if(count($addIDs_ary))
{
//Create comma separated string of the IDs
$addIDs_str = implode(',', $addIDs_ary);
//Create and run one query to perform all the adds (of the user) 
$query = "INSERT INTO hitlist SET hit_id = '($addIDs_str)' AND player_id = '$playerID'";
$sql = "UPDATE players SET Informants = Informants - 1 WHERE id = '$playerID'";
mysql_query($sql) or die(mysql_error());
if(mysql_query($query))
{
$selectedCount = count($addIDs_ary);
$adddCount  = mysql_affected_rows();
echo "{$adddCount} of {$selectedCount} Investigated player(s) were successfully added.";
}else{
echo "There was a problem running the query.<br>" . mysql_error();
}
}else{
echo "Invalid ID data passed.";
}
}

How can I insert a url in the body of an mail such that when the user clicks on it return the url string

hi i'm trying to insert this text just "we're pleased to announce etc........ect"

but I can only insert "We" i believe its because single quotation mark. I've tried using addslashes, mysqli_real_escape_string and htmlspecialchars, strp_tags and applied it to my variable $s. But what ever i seem to try and insert still results in "we" being inserted. Cant see for the life of me why???

appreciate any help

if (isset($_POST['submitted'])) {

$errors = array();

if (empty($_POST['title'])) {
$errors[] = '<p class="error">Either you haven\'t filled in the title or story for this news</p>';
} else {
$t = mysqli_real_escape_string($dbc, $_POST['title']);
}
if (empty($_POST['story'])) {
$errors[] = '<p class="error">Either you haven\'t filled in the title or story for this news</p>';
} else {
$s = $_POST['story']; 
}
echo $s;

if(empty($errors)) { // No errors

$q = "INSERT INTO news (title, story, date_added) values ('$t', '$s', NOW() )";
$r = mysqli_query($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc)); 

if (mysqli_affected_rows == !1) { // It didnt run ok
$errors[] = '<p class="error">An error occured with your upload<a href="loggedin.php"> Admin</a></p>';
} else {
echo 'Your news story has been added, visit <a href="news.php">News</a>'; 
} //if mysqli_affected rows
} else {
echo '<p class="error">The following errors occured<br />';
foreach ($errors as $msg) {
echo " - $msg<br>";
}
echo 'Please try again';
} // end of $errors

} // End of submitted


This is my code i'm using :-)

as you an see i'm posting the variable $s which is    ($_POST['story'] with no functions and it still only inserts "we" nothing more?????

All the variables are set for sure, anyone have any clue why the following isnt inserting anything into the db?

Code: [Select]
        //### Query to insert new item into the database table "items"
$query = "INSERT INTO `items`(`name`,`image`,`description`,`description2`,`description3`,`ItemType`,`cash_price `,`credit_price `,`GrowAmount`,`SellAmount`,`MaxOff`,`MaxDef`,`MaxHoes`,`Attack`,`Defense`,`Prestige`,`SafeLimit`,`ProductionQuality`,`ProductionWeight`,`HoDrugUsage`,`HoIncome`,`PurchaseDiscount`,`Informants`,`Pimpness`,`SalesPrice`,`SalesWeight`,`TroopDiscount`,`NotoReq`,`SCReq`,`PRReq`,`Buyable`,`ClassSpecific`,`Sellable`,`Multiple`) VALUES('{$name}','{$image}','{$description}','{$description2}','{$description3}','{$ItemType}','{$price}','{$creditprice}','{$GrowAmount}','{$SellAmount}','{$MaxOff}','{$MaxDef}','{$MaxHoes}','{$Attack}','{$Defense}','{$Prestige}','{$SafeLimit}','{$ProductionQuality}','{$ProductionWeight}','{$HoDrugUsage}','{$HoIncome}','{$PurchaseDiscount}','{$Informants}','{$Pimpness}','{$SalesPrice}','{$TroopDiscount}','{$NotoReq}','{$SCReq}','{$PRReq}','{$Buyable}','{$ClassSpecific}','{$Sellable}','{$Multiple}'";

        //### Execute the above query
        mysql_query($query);

Hello guys, im wonder if ca i syntax the insert so i can  insert some fields with alphabeticly shorting by name field

Thanks

Thanks for reading my post,

Can someone point me to the right direction here; Am trying to insert a record in a text area field into PHP/MYSQl. This time around, I am reading what the user entered into the textarea before inserting.

Take a look at this:

TEXTAREA ->
row 1: BOY
row 2: GIRL

Can I make it two rows in my database as opposed to one? I don't have a problem inserting,  just how to insert as multiple if there are two rows.

Thanks in advance

if (($update_avatar1 == 'http://images.toxicpets.co.cc/vPets/Acara11.gif') OR ($update_avatar1 == 'http://images.toxicpets.co.cc/vPets/Aisha5.gif'))
{
mysql_query("UPDATE avatar SET avatar = '$update_avatar1' WHERE username = '$username' AND game = '$game'") or die ("Database error: ".mysql_error());
mysql_query("INSERT INTO avatar ($update_avatar1 WHERE id = '$userid')");

This is an avatar System But It Is Not Inserting Into The Database

Can someone please help me figure out how to insert "image" from table users, that contains the .jpg data associated with "screen_name", into table friends "friendimg"

Here are the tables:
friends: id, member, friendwith, friendimg
users: id, screen_name, image

$_GET["id"] only contains "screen_name" and"image" is not included

add.php
Code: [Select]
<?php
 if(isset($_GET["id"]))
 {
echo "<br/><a href=\"member?add=".$_GET["id"]."\">Add ".$_GET["id"]." to your list of friends</a>";
 }
?>member.php
Code: [Select]
<?php
 if(isset($_GET["add"]))
 {
$username = $_SESSION["screen_name"];
$friend = $_GET["add"];

$query = "SELECT * FROM friends WHERE member='$username' AND friendwith='$friend'";
$result = mysql_query($query);
$exist = mysql_num_rows($result); 
if($exist=='0')
{
$query = "INSERT INTO friends(member,friendwith) VALUES('$username','$friend')";
mysql_query($query);
echo "<br/>You are now friends with $friend";
}
else 
{
echo "<br/>$friend is already in your list of friends!";
}
 }
?>

how do i insert two same values bearing variable into the same row though different column into a database? Insertion was successful but at the end I always end up getin an error for which I was not allowed a redirection...thanx


error:
Code: [Select]
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 ') VALUES('spaceman12', 'ja')' at line 1

I don't know DOM very well.  I can split html code into an array by paragraph and insert new lines, just not at the beginning.  When I do $p_nodes->item(0)->insertBefore, it inserts the line after item(0).  Here's an overview:

Code: [Select]
<I want to insert a line here>
<p> line one </p>
<I can insert a line here>
<p> line two</p>
etc
Here's the php code:
$dom = new DOMDocument('1.0', 'UTF-8');
$dom->loadHTML($html);
$dom->encoding = 'UTF-8';

$content_xpath = new DOMXPath($dom);

//Find paragraphs
$p_nodes = $content_xpath->evaluate('//p');

//Add the new element
$insertLine = $dom->createdocumentFragment();
$insertLine->appendXML('<div>hello</div>');

//$p_nodes->item(0)->appendChild($insertLine); //this inserts the new line after line 1
$p_nodes->item(0)->insertBefore($insertLine); //this inserts after, same as appendchild

$html = $dom->saveHTML();


Note: this code is greatly simplified- I would love to just concatenate the new line, but trust me- its not possible, it needs to be done with DOM.

Hi All,

When inserting data into a DB I get a current timestamp using GETDATE() - however, I would like to insert a date that is say 3 working day's from the time the record was inserted.

Is this possible? If so, how would I go about it?

Thanks
Matt

Hi,

Does anyone have any idea how to insert an entire php or html pages into mysql once the page has being created with php?

E.g.

np1.php

<form action="np2.php" method="post">
Name of New Page: <input type="text" name="newpage_name" />
<input type="submit" />
</form>


np2.php

<?php
$newpage_name = $_POST[ 'newpage_name' ];
$newpage_initial = "Input Contents Here.";
//echo $editor_data;   

$newpage_file = "test/" . $newpage_name . ".php";
$newpage_save = fopen($newpage_file, 'w');
fwrite($newpage_save, $newpage_initial);
fclose($newpage_save);
?>


I have managed to create a new file with php but I also want it when I click on the submit button, it will also auto save that new php file or html file into mysql.

Regards
Jas