PHP - Not Inserting Or Updating?

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

Thanks

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?????

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.

$sqld = "SELECT * FROM orders WHERE `id`='$delete' AND `name`='$inf2[name]' AND `email`='$inf2[email]' LIMIT 1";
$csql   = $db->query($sqld);
$ccheck = $csql->fetch(PDO::FETCH_NUM);
$cinf = $csql->fetch(PDO::FETCH_ASSOC);

$quantity = $cinf[quantity];
$code = $cinf[code];

$stmt11 = $db->prepare('UPDATE feeds SET quantity=quantity-:quantity WHERE code=:code');
$stmt11->bindValue(':quantity', $quantity, PDO::PARAM_STR);
$stmt11->bindValue(':code', $code, PDO::PARAM_STR); $stmt11->execute();

$id = $delete; 
$name = $inf2[name]; 

$stmt2 = $db->prepare("DELETE FROM orders WHERE id=:id AND name=:name"); 
$stmt2->bindValue(':id', $id, PDO::PARAM_STR); 
$stmt2->bindValue(':name', $name, PDO::PARAM_STR); 
$stmt2->execute();

OK, i have just been told i should start using PDO instead of mysql to update my tables. This code works to delete the order but doesn't update the feeds section.   All this is new to me so far and i think i am getting the hang of it. Should i still be using the quantity=quantity-:quantity or is there another way to do it with PDO?     Sorry, i posted this in the wrong forum. Hope someone here can help until it's moved
Edited by Self_Taught_Still_Learning, 30 May 2014 - 03:30 PM.

                 $query1 = "select * from movies where title = '".$title."' ;";
 $result1 = mysql_query($query1) or die('Could Not Execute The Query');
 while ($row = mysql_fetch_assoc($result1) )
                       {
                       for($f=0; $f<$parts[$current_k]; $f++ )
{
        touch("$base_folder/{$hos}/".$linking[$sum].".php");


$old_part_href = $row['href_parts'];

$updated_part = $old_part_href.$new; 
$query_href = 'update movies set href_parts = \''.$updated_part.'\'';
mysql_query($query_href) or die('COULD NOT EXECUTE THE QUERY FOR PARTS HREF');
$new = "{$base_folder}/{$hos}/".$linking[$sum].".php";


$sum++;
}
                      }

what i am trying to do is take the value of href_parts and add the new href of the page to the existing value on the href_parts and update the href_parts field in my db.. but i am not getting the desired results.. all i am getting in the db is the last value that is passed in the loop in the db.. i want to save the values which are exisiting in the db and add the newly created values to itt.. can anyone help please..

So, I am making a CMS for my school and I am having some trouble.

It's a magazine sort of CMS and what I want is that when you click on a certain thing it continues onto the next page. Through the CMS you can create pages - when you do this each page gets a unique PID. To access the pages you have to enter the PID on the end of the URL, e.g. : http://www.myschool.com/magazine/index.php?pid=x. What I need is a code that when an image gets clicked the PID number in the URL goes up by one.

Thanks

Hi,

I'm using php to access the mysql database using mysqli and I have a field on my table called "timestamp" and it's set as a timestamp and has current_time (I think in phpmyadmin it was a tick option so I clicked it) and when I update that row in my table the field "timestamp" doesn't update with the timestamp from when it was last updated/modified. I thought the field option timestamp automatically did that? I'm guessing not.. is there a way I can update the timestamp with the current time in my query?

I'm back, I have a code that based on my understanding should work, but needless to say doesn't

<?php
$sql ="select * from `piprice`";
$result = mysql_query($sql);
$count = mysql_num_rows($result);

echo "<table border=1><tr><td>Product Name</td><td>Item ID</td><td>Price</td><td>Enabled</td>";
echo "<form action=main.php?id=test1.php method=post>";
while ($row = mysql_fetch_array($result)) {
echo "<tr><td>".$row['product name']."</td>";
echo "<td>".$id[] = $row['item id'];$row['item id']."</td>";
echo "<td>".$row['price']."</td>";
$enabled[] = $row['enabled'];
echo"<td><select name=".$enabled."><
<option Value=".$row['enabled'].">".$row['enabled']."</option>
<option Value=Yes>Yes</option>
<option Value=No>No</option>
/select></td</tr>";
}
echo "<input name=submit type=submit value=Update>";
echo "</form></table>";
if(isset($_POST['submit']))
{

for($i=0;$i<$count;$i++){
$sql1="UPDATE `piprice` SET `enabled` = '$enabled[$i]' WHERE `item id` ='$id[$i]'";
$result1=mysql_query($sql1) or die (mysql_error());

}
}
?>

Basically I want to be able to pick yes/no and have it update in the database.

One a side note is there a good site for me to learn php on (I just know the basics) besides asking 101 questions here 

Im trying to choose what I want the id to be set to when I create a row on another table

using this code below it tells me "unknown column "id" in 'field list'
making me think it has to asign a random id first

Code: [Select]
<?php
$d1 = "SELECT id FROM game WHERE id='".mysql_real_escape_string($_SESSION['user_id'])."'";
$b1 = mysql_query($d1) or die(mysql_error());
$c1 = mysql_fetch_array($b1);

if (empty($c1['id'])) { 

$a1 = "INSERT INTO game SET id = '".$_SESSION['user_id']."'";


mysql_query($a1) or die(mysql_error()); ?>

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

Hi guys.....

I'm having a problem that I've been tearing my hair out over for way too long. I'm hoping that some of you may be able to help me or at least point me in the right direction.

I'm using MySQL 5.0.91 (via PHPmyAdmin from GoDaddy).

This query should basically grab the data from the Facebook API and insert it into the database. It's not doing that. After inserting the data, it queries the database, and redirects the user to their profile page (USERNAME.php). Because there is no data in the database for that user, it has no idea what their username is, so it redirects them to ".php"....yes, that is "[dot]php".

I'm not entirely sure how to debug this either. I've tried a few var_dump()'s with not much luck.

Is there a specific order in which this stuff needs to be in? Maybe that's the problem, so I'm also including a screenshot from PHPmyAdmin of the database table.

Here's the code:


// user not in db, insert details
if(!empty($user)){
         $apiGet = array(
         'method' => 'users.getinfo',
                'uids' => $uid,
                'fields' => 'uid, name, first_name, last_name, pic_square, pic_big, sex, email, birthday_date, activities, interests, status, about_me' //theses are the fields it pulls from the Facebook API
                 );                                                                                                            
         // create array to hold returned values
         $fbi = $facebook->api($apiGet);
// insert details
$iString = "oauth_provider, oauth_uid, username, name, first_name, last_name, sex, pic_big, email, joined, lastLogon, birthday_date, user_activities, user_interests, user_status, user_about_me";

$iArray = array(); //the following are the values of the fields
array_push($iArray,'facebook');
array_push($iArray,$user['id']);
array_push($iArray,$user['name']);
array_push($iArray,$fbi[0]['name']);
array_push($iArray,$fbi[0]['first_name']);
array_push($iArray,$fbi[0]['last_name']);
array_push($iArray,$fbi[0]['sex']);
array_push($iArray,$fbi[0]['pic_big']);
array_push($iArray,$fbi[0]['email']);
array_push($iArray,time());
array_push($iArray,time());
array_push($iArray,$fbi[0]['birthday_date']);
array_push($iArray,$fbi[0]['user_activities']);
array_push($iArray,$fbi[0]['user_interests']);
array_push($iArray,$fbi[0]['user_status']);
array_push($iArray,$fbi[0]['user_about_me']);
var_dump($email);
$db->insert('users',$iArray,$iString);
$where = "oauth_uid = '{$uid}'";
$db->select('*','users',$where);
$result = $db->getResult();
                  // the next line creates a profile page. After that, there are lines that point the user to that page.
                  createProfile($result['username']);


I've added some comments to it to articulate what is going on.

Thanks in advance!
Alex

Hi, I have a MySQL table with a timestamp field. I want this field to be automatically updated with the current date and time when a record is updated.
How do I do that?
This is my update query. Thanks:

Code: [Select]
$Sql="UPDATE MyTable SET
client_alias='$client_alias',testimonial_date='$testimonial_date',order_ontime='$order_ontime',how_deal='$how_deal',order_condition='$order_condition',happy_colour='$happy_colour',colour_chosen='$colur_chosen',easy_use='$easy_use',effectiveness='$effectiveness',client_comments_eng='$client_comments_eng',client_comments_esp='$client_comments_esp',testimonial_updated_by='$testimonial_updated_by', _time_stamp='?????????'  WHERE id_testimonial='$colname_testimonials_update_RS'";

mysql_query($Sql) or die('Error, query failed : ' . mysql_error());

Hi there reader(s)

I've been searching everywhere, and I'm not one to post my issue unless I've searched as hard as I could, I'm not new to PHP, but I am new to MySQL (so go easy on me) and I've got variables all set up, and I've successfully established connection to my Database and my Database's table, but now I cannot find a way to insert the data (variable) into a column of the table.

Willing to provide more information!

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