I am in dilema all day... I make form and all what I need for CMS, but realy don't know how can I add or edit data on difrent pages... I have 10 pages- 10 files .php with contents, and have set one part cone on pages, where I need to inject data with my form.... I have just one solution, what I tried. It is create data_table for all pages, and create 10form for 10 pages, and then changes table name in code. But it is too much jobs and too much space on website, I need one table for all data...If there any way to set it,pls tell me or give me suggestion. ps. I looking all round google for exemples, but I don't understand, nowhere I can see problem like this. Below is the code what I uses for page and form
code for add form
<?php
@session_start();
if(!isset($_SESSION['user_name'])) {
header("location: login.php");
}
else {
?>
<html>
<head>
<title>Insert new post</title>
</head>
<body>
<form method="post" action="dodavanje_artikla1.php" enctype="multipart/form-data">
<table align="center" border="10" width="800">
<tr>
<td align="center" colspan="5" bgcolor="#5f9ea0"><h1>Here insert new article</h1></td>
</tr>
<tr>
<td align="right">Insert title:</td>
<td><input type="text" name="naziv" size="40"></td>
<td><select>
<option value="page1.php">p1</option>
<option value="page2.php">p2</option>
<option value="page3.php">p3</option>
<option value="page4.php">p4</option>
<option value="page5.php">p5</option>
<option value="page6.php">p6</option>
<option value="page7.php">p7</option>
<option value="page8.php">p8</option>
<option value="page9.php">p9</option>
<option value="page10.php">p10</option>
</select></td>
</tr>
<tr>
<td align="right">Insert image:</td>
<td><input type="file" name="image"></td>
</tr>
<tr>
<td align="right">Insert content:</td>
<td><textarea name="tekst" cols="40" rows="20"></textarea></td>
</tr>
<tr>
<td align="center" colspan="5"><input type="submit" name="submit" value="Publish">
<input type="reset" name="reset" value="Reset"></td>
</tr>
</table>
</form>
<?php
include "../editori/tinymce.php";
?>
</body>
</html>
<?php
include("include/connection.php");
if(isset($_POST['submit']))
{
$title = $_POST['title'];
$text = $_POST['content'];
$image_name = $_FILES['image']['name'];
$image_type = $_FILES['image']['type'];
$image_size = $_FILES['image']['size'];
$image_tmp = $_FILES['image']['tmp_name'];
if($title=='' or $text=='')
{
echo "<script>alert('One or more field is blank')</script>";
exit();
}
if($image_type=="image/jpeg" or $image_type=="image/png" or $image_type=="image/gif")
{
if($image_size<=50000)
{
move_uploaded_file($image_tmp,"images/$image_name");
}
else
{
echo "<script>alert('Image is too large, upload is limited till 50kb')</script>";
}
}
else
{
echo"<script>alert('Type of image is invalid')</script>";
}
$query = "insert into artikli1 (title,image,content) values ('$title','$image_name','$text')";
if(mysql_query($query))
{
echo "<script>window.open('index.php?published=Article is published','_self')</script>";
}
}
?>
code for pages where i need to put
<div class="post_body">
<?php
include("include/connection.php");
$query = "select * from artikli1";
$run = mysql_query($query);
while ($row=mysql_fetch_array($run))
{
$artikli_ID = $row['artikli_ID'];
$title= $row['title'];
$image = $row['image'];
$text = $row['content'];
?>
<dt><h5><a href="page.php?id=<?php echo $artikli_ID; ?>"><?php echo $title; ?></a></h5></dt>
<dt><br /><img src="images/<?php echo $image; ?>" width="100" height="100" /> </dt>
<dd><ul><?php echo $text; ?></ul></dd>
<div class="row">
<div class="col-lg-12">
<div class="solidline"></div>
</div>
</div>
<?php } ?>
In database i added new row type_article, set varchar and default on NULL
then changed this part of code
then added in code $type_articlepart
and include this code on every page where I want to update article.
That is all...