PHP - Why My Varchar(1000) Value Truncated In Php??

Hello,

I have a query that displays a list of events for the year, and am in need of guidance on how to have it only show events that are >= today's date. 

The 'date' is inserted into the table as a varchar field from javascript code.  There was an old blog post about doing something like....

Code: [Select]
SELECT * FROM calendar WHERE `date` >= NOW() ORDER BY date ASC LIMIT 5

I seem to have trouble in that i believe NOW() will only work with proper datetime entries as opposed to my varchar setup.

any help navigating this would be great.

I am not a developer and am learning so forgive lack of what may be obvious knowledge to you folks.

 

Our hosting provider has upgraded our version of SQL 5.7.7 which sets the default SQL mode to strict. As strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE we now have an error with some of our old PHP code. 

We are trying to insert a timestamp as follows

$insertSQL = sprintf("INSERT INTO tournaments (tourn_id, tourn_name, tourn_year, site_visible, tourn_type, ranking_type, tourn_class, how_seed, status) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['tourn_id'], "int"),
                       GetSQLValueString($_POST['tourn_name'], "text"),
                       GetSQLValueString($_POST['tourn_year'], "date"),
                       GetSQLValueString($_POST['site_visible'], "text"),
                       GetSQLValueString($_POST['tourn_type'], "text"),
                       GetSQLValueString($_POST['ranking_type'], "text"),
                       GetSQLValueString($_POST['tourn_class'], "text"),
                       GetSQLValueString($_POST['how_seed'], "text"),
                       GetSQLValueString($_POST['status'], "text"));

But we now get an error stating "Column tourn_year cannot be null"

The hosting provider has stated that since MySQL version 5.7.7 the default sql_mode is strict a value is missing when a new row to be inserted does not contain a value for a non-NULL column that has no explicit DEFAULT clause in its definition. As specified in https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-strict

They have also said that the value passed for tourn_year is now not recognized as correct due to MySQL's strict mode being active. At the moment, this row is the only one set with timestamp while all other ones are using varchar

I am wondering what is the easiest least impactful way to fix this.

Do I change to varchar (see image) or change the code?

Thanks for your help in advance

 

 

 

how would i add text onto the end of a varchar field? i have tried using update like so:

mysqli_query($link, "UPDATE ".TBL_PREFIX."posts
SET post_likes = post_likes + ', $qu'
WHERE post_id = '$post_id'
")or die(mysqli_error($link));

but that set the table to 0. Any ideas?

I have a registration form and there is a part for Phone Numbers / Email   it's option for either.

My question is : The Field is a VARCHAR 255 , the max you can input on that registration field is 20 Characters?

HOW Can i change the value to more like 30 - 40 characters ? please help.

Jelly Bellys. So there are "recipes" of ones you can eat at the same time. The most well-known one is probably mixing a couple peanut butter jelly beans with a couple grapes. I have to say it's pretty good because they actually do taste like peanut butter and grapes, but I have one issue: the peanut butter flavor is too weak compared to the grape. Instead of a 1-1 ratio it takes more like 3-1.

Weird thing, this has got to be the most famous recipe so why isn't it listed on their site? I see candy apple, tiramisu, and lemon meringue pie, but nothing about peanut butter and jelly sandwiches. Are they just not popular anymore? Personally I prefer peanut butter and chocolate (Nutella, specifically) but whatever. Which can't be that weird because Reese's is popular... Mind you peanut butter + Nutella sandwiches don't really taste like Reese's candies, but that could just be because of the type of chocolate. Like they use milk or dark chocolate while Nutella is based on hazelnut.

Which reminds me, I have a jar of it in the cupboard, but it's been so long since I've used it that it might have turned into an oily mess by now. I know it's just the various oils and such separating but it looks like someone poured a teaspoon or two of water right into it and that just kinda puts me off the whole thing. Same for peanut butter for that matter except the "water" isn't clear. Dirty water. And mixing everything back together isn't so bad but it gets the knife dirty on the handle, which really bothers me because then my fingers get dirty and I have to stop what I'm doing and go wash my hands. I already do that enough each day, I don't want to make more reasons for me to do so.

But beyond the oily mess there's also stuff getting stale. Stale Nutella is a pain because it's stiff and hard to deal with, and the kind of bread I like most is very soft and easily rips apart so spreading it on can be a real labor. Best method I've found is to spread a little bit on at a time but it takes so long to cover the whole face. Fine, it's a good sandwich, but in that same time I could have done something else. Maybe there's something in the freezer I could quickly heat up, or maybe there's some leftovers in the fridge I could eat. And if not there's pretty good odds that I need to go to the grocery store anyways.

Ah, sorry. Forgot why I'm here.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=358112.0

Hi,

My site http://bittleships.com is a simple online battleships game. Theres a 1088 cell grid where each cell is a mysql database entry containing details wether its been clicked, if theres a boat in the location etc.

the site usually loads all the querys in 0.3 seconds, but when 5 or more people are playing this easily hits 1+ seconds.

The code that displays the grid is this:

Code: [Select]
  echo("<center><span style='background-color:white;color:red;font-size:12'>$griderrormsg</span></center>");
   }
   echo("<table width='20' border='0' cellspacing='0' cellpadding='0'");
   for($i=1; $i<=32; $i=$i+1){
             echo("<tr>");

             for($j=1; $j<=34; $j=$j+1){
             $c++;
                       $cell = $c;
                       $sql="SELECT * FROM grid WHERE `ID` = $cell";
                       $result=mysql_query($sql);
                       $row = mysql_fetch_array( $result );
                       $clicked = $row['clicked'];

                       if ($clicked == "1"){

                          echo("<td title='$j, $i'><img src='b.gif");

                       }elseif ($clicked == "2"){   //if the ship was hit
                          $hitby = $row['user'];
                          echo("<td title='$j, $i - Hit by $hitby.'><img src='h.gif");
                       }elseif ($clicked == "3"){  //if is chest
                          $hitby = $row['user'];
                          echo("<td title='$j, $i - $prevamount btc won by $hitby.'><img src='chest.gif");
                       }else{

                          echo("<td><a href='index.php?c=$c'><img src='g.gif");

                       }
                       echo("' BORDER=0></td></a>");
             }

             echo("</tr>");
   }
   echo("</table>");
}
Is there a better way of running this for it to run quicker?

hi there..im new to php mysql and im having trouble inserting a string data to mysql from a php date() function.


here's my code:
Code: [Select]
$year = date('Y');
 echo $year;
  $insertSQL = sprintf("INSERT INTO tbl_elections (election_id=$year)");

  mysql_select_db($database_organizazone_db, $organizazone_db);
  $Result1 = mysql_query($insertSQL, $organizazone_db) or die(mysql_error());
when i try to output the $year variable on a webpage, it returns "2012"
but when i try to insert this data into my database table, it returns an error like this:

check the manual that corresponds to your MySQL server version for the right syntax to use near '=2012)'

is there a way to convert "2012" into a normal string data type?

If I want to read in and process a CSV of a 1000 lines how easy is it to do without a database?

By process, I mean read in the data and do simple manipulations + compare each line with a line from another file, that maybe have 50 lines

I was just concerned that I might start hogging the CPU and memory of the server trying to process 1000 lines of data
It's VERY important that I can do WITHOUT a database

I'd only consider a database if it proves that not using will take too much CPU and memory

I've only just began considering making the application - can't give full details - as I've got to figure them out myself!

Any general advice would be great

Thanks


OM

I have a varchar field called date that looks like this "2/06/2011 TUE" or like this "10/05/2011 WED".
When I do an Order BY date Desc in php it does Not sort properly.
Thanks for your assistance

Steve