Nina555 Posted November 2, 2012 Share Posted November 2, 2012 Hi, I am newbie in PHP and I got some script which I just can't get to insert title in database. I would be very thankful if you could help me with this. Here is the code. I hope that trg86 doesn't mind I got in his topic. $surl = $_SERVER['HTTP_HOST'] ; if (strip_tags($_POST['add'])){ $vidid=mysql_real_escape_string(strip_tags($_POST['vidid'])); $url = "$vidid"; parse_str( parse_url( $url, PHP_URL_QUERY ), $my_array_of_vars); $t1=mysql_real_escape_string(strip_tags($_POST['tit1'])); $title="$t1"; parse_str( $title, $my_vars ); mysql_query("INSERT INTO `videos` (`id`, `videoid`, `views`, `title`) VALUES ('', '".$my_array_of_vars['v']."', '0', '".$my_vars['v']."');") or die (mysql_error()); $message="<img src=\"../img/tick-icon.jpg\">"; } if (strip_tags($_POST['rem'])){ $vidid2=mysql_real_escape_string(strip_tags($_POST['vidid2'])); $url = "$vidid2"; parse_str( parse_url( $url, PHP_URL_QUERY ), $my_array_of_vars ); mysql_query("DELETE FROM videos WHERE id=".$my_array_of_vars['v'].""); $message2="<img src=\"../img/tick-icon.jpg\">"; } ?><head> <html xmlns:fb="http://ogp.me/ns/fb#"> <title>Admin Panel</title> <META name="robots" content="NOINDEX,NOFOLLOW" /> <link type="text/css" rel="stylesheet" href="../css/admin.css" /> <link href="../img/favicon.ico" rel="icon" type="image/x-icon" /> <body> <a href="index.php"><img src="../img/logo.png" border="0"></a> <div class="banner"><a href="index.php">Delete</a> - <a href="add.php">Add & Remove</a> - <a href="logout.php">Logout</a></div> <div align="center"><form id="form1" method="post" action=""> Youtube URL: <input type="text" name="vidid" id="vidid"> Title: <input type="text" name="tit1" id="tit1"> <input name='add' type='submit' id='add' value='Add Video' /> <? echo"$message";?><br><br> Website URL: <input type="text" name="vidid2" id="vidid2"> <input name='rem' type='submit' id='rem' value='Remove Video' /> <? echo"$message2";?><br><br> Example: <strong>http://<? echo"$surl"; ?>/watch.php?v=25</strong> </div> </form> </body> Link to comment https://forums.phpfreaks.com/topic/270197-cant-insert-title-into-database-split-from-existing-thread/ Share on other sites More sharing options...
MDCode Posted November 2, 2012 Share Posted November 2, 2012 Any errors? Link to comment https://forums.phpfreaks.com/topic/270197-cant-insert-title-into-database-split-from-existing-thread/#findComment-1389622 Share on other sites More sharing options...
Nina555 Posted November 2, 2012 Author Share Posted November 2, 2012 No there are no errors it just doesn't insert 'title' into database Link to comment https://forums.phpfreaks.com/topic/270197-cant-insert-title-into-database-split-from-existing-thread/#findComment-1389625 Share on other sites More sharing options...
MDCode Posted November 2, 2012 Share Posted November 2, 2012 Where is $my_vars Link to comment https://forums.phpfreaks.com/topic/270197-cant-insert-title-into-database-split-from-existing-thread/#findComment-1389626 Share on other sites More sharing options...
Nina555 Posted November 2, 2012 Author Share Posted November 2, 2012 If you mean where is defined it's not defined neither $my_array_of_vars and that part works. P.S I am newbie in php -.- Link to comment https://forums.phpfreaks.com/topic/270197-cant-insert-title-into-database-split-from-existing-thread/#findComment-1389629 Share on other sites More sharing options...
MDCode Posted November 2, 2012 Share Posted November 2, 2012 If they're not defined where do you expect to get the information from... Link to comment https://forums.phpfreaks.com/topic/270197-cant-insert-title-into-database-split-from-existing-thread/#findComment-1389631 Share on other sites More sharing options...
Nina555 Posted November 2, 2012 Author Share Posted November 2, 2012 It should get information from form, and as you can see $my_array_of_vars is not defined too and that part add video works fine Link to comment https://forums.phpfreaks.com/topic/270197-cant-insert-title-into-database-split-from-existing-thread/#findComment-1389633 Share on other sites More sharing options...
Nina555 Posted November 2, 2012 Author Share Posted November 2, 2012 $vi=mysql_query("SELECT * FROM videos WHERE id='$getid' LIMIT 1"); $v = mysql_fetch_object($vi); Link to comment https://forums.phpfreaks.com/topic/270197-cant-insert-title-into-database-split-from-existing-thread/#findComment-1389635 Share on other sites More sharing options...
Nina555 Posted November 2, 2012 Author Share Posted November 2, 2012 Thank you, your question inspired me and i have fixed the problem Link to comment https://forums.phpfreaks.com/topic/270197-cant-insert-title-into-database-split-from-existing-thread/#findComment-1389636 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.