I am working on a development website which involves users posting their favourite content of their book on to the webpage and all the data gets stored in the database and gets displayed on the website. However whenever i try to post big paragraphs using the form I created and php scripts which processes the form, it doesn't give any error but it doesn't store the values to the database as well. It works okay if the content to process is short. Please help me the code is below. Any suggestions would be appreciated.  &lt;?php $hostname = "localhost"; $username = "root"; $password = ""; $database = "library"; $conn = mysql_connect($hostname,$username,$password)or die('Cannot connect'); mysql_select_db("library", $conn); ?&gt;  &lt;?php $title = $_POST['title']; $author = $_POST['author']; $content = strval($_POST['content']); $description = $_POST['description']; $category = $_POST['category'];  if (isset($title) &amp;&amp; !empty($title)){     $sql = "INSERT INTO books(title,author,description,content,category) VALUES('$title','$author','$description','$content','$category')";     mysql_query($sql);     echo 'Successfully Added the book'."&lt;a href='/'&gt;&lt;br&gt;Check it out here&lt;a&gt;"; } else{     echo 'Title is missing'; } ?&gt;   Thanks.
If user input is inserted without modification into an SQL query, then the application becomes vulnerable to , like in the following example:  $unsafe_variable = $_POST['user_input'];   mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')");   That's because the user can input something like value'); DROP TABLE table;--, and the query becomes:  INSERT INTO `table` (`column`) VALUES('value'); DROP TABLE table;--')   What can be done to prevent this from happening?
How do I to properly handle spaces in PHP Shell_exec? I am designing the layout for a touchscreen for outside use, What are some good color combination to use that will be visible under the sun light for outside use? Maybe bright neon colors? Why do I need 50 reputation to comment? What can I do instead? Busy Device on Umount I often experience a problem to umount a directory:  umount /mnt/dir umount: /mnt/dir: device is busy   There are many reasons why the device is busy. Sometimes there are processes running which have open locks on it, sometimes there are other directories mounted on top of /mnt/dir.  My question:  What are the steps to check why a directory couldn't be unmounted.  I know there are many reasons, but it's ok if you explain a specific solution.  [EDIT]  [X]  running processes on mounted volumes.   [X] another volume is mounted on top of a volume we want to unmount   [_] NFS locks the volume we want to unmount Differences among Doctoral Degrees/titles Apparently this is a  and should hopefully be fixed in an upcoming update.    I have installed SQL Server Management Studio v17.9 on a clean Windows 10 installation.  This associated all .sql files with SSMS.  I want to associate .sql files with a plain text editor (eg: Sublime) but I am unable to change the default application.  I have tried:   Right click .sql file -> Open With -> Sublime + "Always use this program". Settings -> Default Applications by File Type -> Find .sql -> Change to Sublime Right click .sql file -> Properties -> "Change" button -> Sublime. Using ftype via elevated command prompt as seen    In all 3 cases, my selection is not reflected in any way, anywhere.  The icon remains SSMS, and the file opens with SSMS.  Is there some kind of "File Association retention" setting within SSMS I am unaware of?  Edit: I can change the default application for non-SSMS-associated extensions without issue.  Edit: after deleting registry key HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.sql, .sql files show a VSCode icon:    If I then double-click New Users.sql, it opens with SSMS and a refresh of regedit shows the .sql entry recreated with ssms.exe associated (the icon remains VSCode):    If I then right-click -> open with -> Choose Another App -> Select Sublime and hit "Always use this to open .sql files", it opens with Sublime and a refresh of regedit shows a new "b" entry created for Sublime.  The icon remains VSCode, and double-clicking opens it in SSMS:    If I then delete the a entry for ssms.exe and rename b -> a such that only sublime exists, then double-click the .sql file, it opens with SSMS and generates a new b entry for itself: Is there a way to increase space between bibliography without using biblatex? I found "A sledgehammer to crack a nut" as one example. What are some others? When I'm on my mod site I have my diamond dropdown:    But on Meta.SE and other sites, I have the StackBurger:    This doesn't show on my mod site, so I can't switch between sites easily. What will be the trajectory of the given motion If it is given that component of acceleration perpendicular to the velocity of a body has a constant, non-zero magnitude, how can we mathematically prove that the trajectory of the body will be circular?   I have basic knowledge of calculus, vectors and co-ordinate geometry. I can prove that the trajectory of a body in projectile motion is parabolic. I tried to follow a similar method to get an equation of circle but couldn't succeed. I tried forming parametric equations of x and y in terms of time t (the way we proceed when proving the parabolic path of a projectile) but could not reach the conclusion.  Edit: I have edited the question in order to improve it. However I still can not share my work on this question as I had asked the question almost 6 months ago and now I can not find where I tried solving it. Sincerely sorry for that. How do I work with Root objects? Can it happen that the image of a functor is not a category? On Hilton and Stammbach's homological algebra book, end of chap. 2, they wrote in general $F(\mathfrak{C})$ is not a category at all in general. But I don't quite get it. I checked the axioms of a category for the image, and I think they are all satisfied. Am I missing something? Thanks. Can I move the Unity launcher? Integrable - martingale Suppose $X_{n}^{(1)}$ and $X_{n}^{(2)}$ are martingales w.r.t. a filtration $F_{n}$. I have do determine whether $Z_{n}=e^{X_{n}^{1}+X_{n}^{2}}$ is a martingale, submartingale or supermartingale. I thought that because $X_{n}^{1}+X_{n}^{2}$ is a martingale I can use Jensen to say that $E[Z_{n}|F_{n-1}]\geq e^{E(X_{n}^{(1)}+X_{n}^{(2)}|F_{n-1})}=Z_{n-1}$. But I have to check whether $Z_{n}$ is integrable and I don't know how. I have a good intuition that $A$ is independent of $B$ if $P(A \vert B) = P(A)$, and I see how you can easily derive from this that it must hold that $P(A,B) = P(A)P(B)$.    But the first statement is not normally taken as a definition; instead the second is.    What is the intuition, or even derivation behind defining $A$ and $B$ as independent iff $P(A, B) = P(A)(B)$?    The kind of explanation I am looking for would be one similar to that given by Jaynes for the definition of conditional probability in the first chapter of Probability: The Logic of Science, or even a Kolmogorov axiomatic explanation would help. Why my U.S. B1 Visa got refused under 214 (b)? I went for B1 U.S. Visa at the U.S. Embassy in Delhi.   Interviewer: *Good Morning*. Me: *Good Morning* Interviewer: *What is your designation?* Me: *I am a Software Engineer.* Interviewer: *What is the name of your company?* Me: *It is XXX (I replied).* Interviewer: *What is the name of your client?* Me: *It is YYY (I replied).* Interviewer: *Have you ever been to U.S. before?* Me: *NO* Interviewer: *Have you ever been abroad before?* Me: *NO*   At this point he rejected my Visa with letter mentioning 214 (b) as the reason. I don't know why he actually rejected it.  But, I have decent 2+ years of experience with my company. And, I was going on a business meeting with the client. I would have come back after 2 weeks.  I don't know if re applying will help. Error: Declaration of MyClass::start_lvl() should be compatible with that of Walker_Nav_Menu::start_lvl() I'm currently working on a WordPress site and whenever in the admin I go the Appearance > Menus page I get the following error:     ErrorException: Runtime Notice: Declaration of Walker_Nav_Menu_Edit::start_lvl() should be compatible with that of Walker_Nav_Menu::start_lvl() in wp-admin/includes/nav-menu.php line 203   It seems like some sort of PHP compatibility issue. I'm running PHP 5.3.10 on my local dev machine.  What would be the best way to remedy this problem? Is there a way to calculate a sorted field with sequential numbers?  I have seen  that outlines how to calculate sequential numbers, but this is always calculated on FID order, not on sorted order.  #Pre-logic Script Code: rec=0 def autoIncrement():      global rec      pStart = 1       pInterval = 1      if (rec == 0):           rec = pStart       else:           rec += pInterval       return rec  #Expression: autoIncrement()   An example of what I'm trying to do.  I've used an advanced sort to sort by year, month, day, and now want to have sequential numbers in the Seq field.  You'll see that my OBJECTID field is not in order, so the above code won't work.    Can this be done either in the Field Calculator or using an Update Cursor in arcpy? The shop is five minutes away.     According to the dictionary, away is an adverb. An adverb modifies a verb. In the above example, what word does away modify? Why is away not an adjective?       The shop is five meters tall.     tall is an adjective in the second example. It modifies five meters (does it?). So why is away an adverb? I am using cURL to insert data into salesforce. It works with single record but I need to insert multiple records at a time. Is it possible to do so and is it possible via a REST interface?