Помогите решить проблему, может кто-то уже сталкивался с таким.Выбивает такая ошибка вот что нужно добавить в базу Код (Text): <div class="film_block"> <aside> <div class="poster_film-box"> <img src="{poster}" class="inner_view" alt="Poster of film" /> <a href="later" class="w_later"><i class="icon"></i><span>watch later</span></a> </div> <div class="vote-buttons"> <button id="like"><i class="icon"></i> <span>like</span></button> <button id="dislike"><i class="icon"></i> <span>dislike</span></button> </div> <ul class="characteristics"> <li> <strong>Years</strong> <span class="years">{year}</span> </li> <li> <strong>Genre</strong> <span class="genre">{genre}</span> </li> <li> <strong>Country</strong> <span class="country">{country}</span> </li> <li> <strong>Quality</strong> <span class="quality">{quality}</span> </li> <li> <strong>Translation</strong> <span class="translation">{trans}</span> </li> </ul> </aside> <div class="main_film-wrapp"> <!-- Vid --> <div id="tabs"> <ul id="tabs_film_nav"> <li><a href="#">film</a></li> <li><a href="#">Trailer</a></li> </ul> <div id="tab1"> <div id="player_a" class="projekktor"></div> <script type="text/javascript"> $(document).ready(function() { projekktor("#player_a", { poster: "", title: "", playerFlashMP4: "swf/StrobeMediaPlayback/StrobeMediaPlayback.swf", playerFlashMP3: "swf/StrobeMediaPlayback/StrobeMediaPlayback.swf", width: "100%", height: "385", playlist: [ { 0: {src: "{url}", type: "video/ogg"}, 1: {src: "{url}", type: "video/mp4"}, 2: {src: "{url}", type: "video/webm"} } ] }, function(player) {} // on ready ); }); </script> </div> <div id="tab2" style="display: none"> <div id="player_a1" class="projekktor"></div> <script type="text/javascript"> $(document).ready(function() { projekktor("#player_a1", { poster: "", title: "", playerFlashMP4: "swf/StrobeMediaPlayback/StrobeMediaPlayback.swf", playerFlashMP3: "swf/StrobeMediaPlayback/StrobeMediaPlayback.swf", width: "100%", height: "385", playlist: [ { 0: {src: "{url_1}", type: "video/ogg"}, 1: {src: "{url_1}", type: "video/mp4"}, 2: {src: "{url_1}", type: "video/webm"} } ] }, function(player) {} // on ready ); }); </script> </div> </div> <section class="about_film"> <h2>About film</h2> <p>Gravity is a 2013 British–American sci-fi thriller[3][4] and space drama film.[5][6] It was directed, co-written, co-produced and co-edited by Alfonso Cuaron, and stars Sandra Bullock and George Clooney as astronauts involved in the mid-orbit destruction of a space shuttle and their attempt to return to Earth.</p> </section> <section class="comments_a_film"> <h2>Comments</h2> <form name="add_comments" action="#"> <textarea placeholder="Write comments, pleace" required="required"></textarea> <button><span>Send</span></button> </form> <article> <header> <img src="img/author1.jpg" alt="author date"/> <span class="author_name">Visual Idiot</span> </header> <p class="text">Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.</p> </article> <article> <header> <img src="img/author2.jpg" alt="author date"/> <span class="author_name">Visual Idiot</span> </header> <p class="text">Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.</p> </article> <article> <header> <img src="img/author3.jpg" alt="author date"/> <span class="author_name">Visual Idiot</span> </header> <p class="text">Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.</p> </article> <article> <header> <img src="img/author1.jpg" alt="author date"/> <span class="author_name">Visual Idiot</span> </header> <p class="text">Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.Morbi sed quam ut lorem dignissim imperdiet. Duis massa magna, adipiscing ac sodales ac, fringilla vel elit. Sed sed molestie nisi. Sed sed molestie nisi.</p> </article> </section> <!-- / VID --> </div> </div> а вот самый код Код (Text): $film = file_get_contents("tpl/film.html"); $poster = $uploaddir . basename($_FILES['poster']['name']); $film = str_replace("{poster}",$poster,$film); $film = str_replace("{year}",$year,$film); $film = str_replace("{genre}",$genre,$film); $film = str_replace("{country}",$country,$film); $film = str_replace("{quality}",$quality,$film); $film = str_replace("{trans}",$trans,$film); $film = str_replace("{url}",$url,$film); $film = str_replace("{url_1}",$url_1,$film); $add = "INSERT INTO 'pages'('content') VALUES('$film')"; $query = mysql_query($film) or die("Помилка: " . mysql_error()); . Уже перепробовал все, что мог, менял на обратные апострофы и ничего не помогает.
1) не 'pages' и не 'content', а `pages` и `content` 2) $film = mysql_real_escape_string($film); после всех str_replace.
Я все сделал, но к сожалению не работает Код (Text): $film = file_get_contents("tpl/film.html"); $poster = $uploaddir . basename($_FILES['poster']['name']); $film = str_replace("{poster}",$poster,$film); $film = str_replace("{year}",$year,$film); $film = str_replace("{genre}",$genre,$film); $film = str_replace("{country}",$country,$film); $film = str_replace("{quality}",$quality,$film); $film = str_replace("{trans}",$trans,$film); $film = str_replace("{url}",$url,$film); $film = str_replace("{url_1}",$url_1,$film); $film = mysql_real_escape_string($film); $add = "INSERT INTO `pages` (`content`) VALUES(`$film`)"; $query = mysql_query($film) or die("Помилка: " . mysql_error());
дык $film надо было оставить в кавычках '. Кавычки (' и ") в программировании служат для обозначения строк. Апостроф (`) используется в языке SQL для выделения имён баз, таблиц и полей.
Оо ... все заработало спасибо)) я просто там где есть mysql_query($film) не ту перемену запихнул, нужно было так mysql_query($add).большое спасибо