Jump to content
php.lv forumi

ziedinjsh

Reģistrētie lietotāji
 View Profile  See their activity

  • Posts

    789

  • Joined

  • Last visited

 Content Type 

Posts posted by ziedinjsh

  2. Update mysql

    in Iesācējiem

    Posted

    mani ir šitā

    if(isset($_POST['update_reg_statuss'])){

$reg_statuss = mysql_real_escape_string($_POST['reg_statuss']);

$statuss = ("UPDATE admin SET reg_statuss='$reg_statuss'");
$info = mysql_query($statuss) or die('Query error - '. mysql_error());

}
echo "<b>Reģistrācijas status<b>";
echo "<form method='post' action='".$_SERVER['PHP_SELF']."'>";
echo "<select name='reg_statuss' class='uni'>";
	echo "<option value='on'>Ieslēgts</option>";
	echo "<option value='off'>Izslēgts</option>";
		echo "<input type='submit' name='update_reg_statuss' value='Mainīt' class='uni'>";
echo "</form>";

     

    bet es neredzu kļūdu viņā!!

  3. Update mysql

    in Iesācējiem

    Posted

    ja es palaižu ar Izlēgts tad Array ( [reg_statuss] => off [update_reg_statuss] => Mainīt )

    ja ar Ieslegts tad Array ( [reg_statuss] => on [update_reg_statuss] => Mainīt )

     

    pēc būtības izpildās!

  10. Update mysql

    in Iesācējiem

    Posted

    Paldies jau iepriekš jautājumu formā sanāca netīšām.

     

    Tātad.. vairāk vai mazāk izlaboju un pārbaudiju ceļus un tml, bet neiet vienalga!

    <?php
include("../fcs/dbase.php");

if(isset($_POST['update_reg_statuss'])){
$reg_statuss = mysql_real_escape_string($_POST['reg_statuss']);

$statuss = ("UPDATE admin SET reg_statuss='$reg_statuss'");
$info = mysql_query($statuss) or die('Query error - '. mysql_error());

}

echo "<form method='post' action='".$_SERVER['PHP_SELF']."'>";
echo "<select name='reg_statuss'>";
	echo "<option value='on'>Ieslēgts</option>";
	echo "<option value='off'>Izslēgts</option>";
		echo "<input type='submit' name='update_reg_statuss' value='Mainīt satussu'>";
echo "</form>";
?>

  11. Update mysql

    in Iesācējiem

    Posted · Edited by ziedinjsh

    Sveiki!

    Man ir maz kods kas updeito registracijas statusu Ieslegts/Izslegts

    Lieta tada, ka uzspiezot uz pogu neievadas ieks mysql

     

    <?php
include("../header.php");

if(isset($_POST['update_reg_status'])){
$reg_status = $_POST['reg_status'];

$status = ("UPDATE admin SET reg_status='$reg_status'");
$result = mysql_query($status);

if($result){
echo "Statuds mainits!";
}else{
echo "Kads errors";
}

}

echo "<form method='post' action='".$_SERVER['PHP_SELF']."'>";
echo "<select name='reg_status'>";
	echo "<option value='on' >Ieslegts</option>";
	echo "<option value='off'>Izslegs</option>";
		echo "<input type='submit' name='update_reg_status' value='Mainit satussu'>";
echo "</form>";

?>

     

    Kas tur nav pareizi?

     

    Paldies jau ieprieks?

  13. Private Message system

    in Iesācējiem

    Posted

    Sveiki!

    esmu uztaisījis kaut ko līdzīgu pm systēmai.

     

    msg.php

    <?php
session_start();
include("header.php");
include("fcs/functions.php");
if(!isset($_SESSION['user_email'])){
include("login.php");
} else {

include("menu.php");

oside();
openside();
echo "<button name='newmsg' value='' class='add-button' onclick = \"document.getElementById('newmsg').style.display='block';document.getElementById('fade').style.display='block'\">Jauna vēstule</button>";
closeside();
cside();

openpage();

$msg_to = $_SESSION['user_email'];

$msg = mysql_query("SELECT * FROM messages")or exit( mysql_error() );     


   while ($data = mysql_fetch_array( $msg)) {
echo "<div id='show-msg' onclick=\"location.href='read.php?msg='".$data['msg_id']."'';\">";
echo "<div class='show-from'>".$data['msg_from']."</div>";
	echo "<div class='show-title'><a href='read_msg.php?id=".$data['msg_id']."'>".$data['msg_title']."</a></div>";
		echo "<div class='show-date'>".$data['msg_date']."</div>";
			echo "<div class='fix'></div>";
echo "</div>";	   
}	   

closepage();

openpopup("newmsg");
include "new_msg.php";
closepopup();


include("footer.php");
}
?>

     

    new_msg.php

    <?php
$data = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE user_email='".$_SESSION['user_email']."' LIMIT 1"));
$users = mysql_query("SELECT * FROM users");

if(isset($_POST['send_msg'])){

$msg_to = $_POST['msg_to'];
$msg_from = $data['user_name'];
$msg_title = mysql_real_escape_string($_POST['msg_title']);
$msg_text = mysql_real_escape_string($_POST['msg_text']);
$msg_date = date("Y-m-d H:i:s");
$msg_status = "0";

$sql = ("INSERT INTO messages (msg_to, msg_from, msg_title, msg_text, msg_date, msg_status) VALUES ('$msg_to', '$msg_from', '$msg_title', '$msg_text', '$msg_date', '$msg_status')");
$result = mysql_query($sql);

if($result){
?>
<script language="javascript" type="text/javascript">
document.getElementById('succsess').style.display='block';document.getElementById('fade').style.display='block';
</script>
<?php
}else{
?>
<script language="javascript" type="text/javascript">
document.getElementById('error').style.display='block';document.getElementById('fade').style.display='block';
</script>
<?php
}

}
echo "<div id='new-msg'>";
echo "<form method='post' action='".$_SERVER['PHP_SELF']."'>";
echo "<p>Kam</p><p><select name='msg_to' class='msgselect'>";
while ($data = mysql_fetch_array( $users )) {
echo "<option value='".$data['user_name']."'>".$data['user_name']."</option>";
}
echo "</select></p>";	

		echo "<p>Tēma</p> <p><input type='text' name='msg_title' class='msgtitle'></p>";
			echo "<p>Saturs</p> <p><textarea name='msg_text' class='msgtext'></textarea></p>";
				echo "<p><input type='submit' name='send_msg' value='Sūtīt vēstuli' class='msgbutton'></p>";
echo "</form>";				
echo "</div>";


openpopup("succsess");
echo "Vēstule veiksmīgi nosūtīta!";
closepopup();
openpopup("error");
echo "Vēstule nav nosūtīta...";
closepopup();
?>

     

    Jautājums ir sekojos.. Ielogojas lietotājs un kā lai panāk to lai rādās tikai viņam atdresētās ziņas nevis visas kas ir mysql ierakstos?

  16. Atvērt popup p\ec formas funkcijas

    in Iesācējiem

    Posted

    neiet vienalga.. vai arī es nepareizi daru kaut ko!

    <?php
$data = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE user_email='".$_SESSION['user_email']."' LIMIT 1"));
$users = mysql_query("SELECT * FROM users");

if(isset($_POST['send_msg'])){

$msg_to = $_POST['msg_to'];
$msg_from = $data['user_name'];
$msg_title = mysql_real_escape_string($_POST['msg_title']);
$msg_text = mysql_real_escape_string($_POST['msg_text']);
$msg_date = date("Y-m-d H:i:s");
$msg_status = "0";

$sql = ("INSERT INTO messages (msg_to, msg_from, msg_title, msg_text, msg_date, msg_status) VALUES ('$msg_to', '$msg_from', '$msg_title', '$msg_text', '$msg_date', '$msg_status')");
$result = mysql_query($sql);

if($result){
?>
<script language="javascript" type="text/javascript">
document.getElementById('succsess').style.display='block';document.getElementById('fade').style.display='block';
</script>
<?php
}else{
?>
<script language="javascript" type="text/javascript">
document.getElementById('error').style.display='block';document.getElementById('fade').style.display='block';
</script>
<?php
}

}
echo "<div id='new-msg'>";
echo "<form method='post' action='".$_SERVER['PHP_SELF']."'>";
echo "<p>Kam</p><p><select name='msg_to' class='msgselect'>";
while ($data = mysql_fetch_array( $users )) {
echo "<option value='".$data['user_name']."'>".$data['user_name']."</option>";
}
echo "</select></p>";	

		echo "<p>Tēma</p> <p><input type='text' name='msg_title' class='msgtitle'></p>";
			echo "<p>Saturs</p> <p><textarea name='msg_text' class='msgtext'></textarea></p>";
				echo "<p><input type='submit' name='send_msg' value='Sūtīt vēstuli' class='msgbutton'></p>";
echo "</form>";				
echo "</div>";


openpopup("succsess");
echo "Vēstule veiksmīgi nosūtīta!";
closepopup();
openpopup("error");
echo "Vēstule nav nosūtīta...";
closepopup();
?>

     

    popup:

    function openpopup($title){
echo "<div id='$title' class='wstyle'>";
echo "<div class='popup'>";
	echo "<div class='content'>";
		echo "<a href = \"javascript:void(0)\" onclick = \"document.getElementById('$title').style.display='none';document.getElementById('fade').style.display='none'\"><img class='close' src='img/close.png'></a>";
}
function closepopup(){
	echo "</div>";
echo "</div>";
echo "</div>";
}

  18. Atvērt popup p\ec formas funkcijas

    in Iesācējiem

    Posted · Edited by ziedinjsh

    Saistībā ar citu jautājumu man radās šāds: Kā var atvēr popup kurā parādās pievienošanas rezūltāts?

     

    <?php
$data = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE user_email='".$_SESSION['user_email']."' LIMIT 1"));
$users = mysql_query("SELECT * FROM users");

if(isset($_POST['send_msg'])){

$msg_to = $_POST['msg_to'];
$msg_from = $data['user_id'];
$msg_title = mysql_real_escape_string($_POST['msg_title']);
$msg_text = mysql_real_escape_string($_POST['msg_text']);
$msg_date = date("Y-m-d H:i:s");
$msg_status = "0";

$sql = ("INSERT INTO messages (msg_to, msg_from, msg_title, msg_text, msg_date, msg_status) VALUES ('$msg_to', '$msg_from', '$msg_title', '$msg_text', '$msg_date', '$msg_status')");
$result = mysql_query($sql);

if($result){
// šeit atveras popup document.getElementById('succsess').style.display='block';document.getElementById('fade').style.display='block'
}else{
// šeit atveras popup document.getElementById('error').style.display='block';document.getElementById('fade').style.display='block'
}

}
echo "<div id='new-msg'>";
echo "<form method='post' action='".$_SERVER['PHP_SELF']."'>";
echo "<p>Kam</p><p><select name='msg_to' class='msgselect'>";
while ($data = mysql_fetch_array( $users )) {
echo "<option value='".$data['user_id']."'>".$data['user_name']."</option>";
}
echo "</select></p>";	

		echo "<p>Tēma</p> <p><input type='text' name='msg_title' class='msgtitle'></p>";
			echo "<p>Saturs</p> <p><textarea name='msg_text' class='msgtext'></textarea></p>";
				echo "<p><input type='submit' name='send_msg' value='Sūtīt vēstuli' class='msgbutton'></p>";
echo "</form>";				
echo "</div>";


openpopup("succsess");
echo "Vēstule veiksmīgi nosūtīta!";
closepopup();
openpopup("error");
echo "Vēstule nav nosūtīta...";
closepopup();
?>

     

    Kā tas ir panākāms!?

  19. Formas actions bez lapas pārlādes

    in Iesācējiem

    Posted

    ieliku ar garajiem js linkiem kādi ir norādīti.. bet vienalga neiet nekas!!! Tas taču nevarētu būt no tā ka es viņu izmantoju popup`ā? prekštam man jau vaijag bez lapas pārlādes lai datu pievienošanas rezūltātā man neaizveras popup un parāda vai nu soccsess mesigu vai rerror mesigu! ja nu vienīgi pie kaut kā var atvērt popup pie datubāzes rzūltāta atspoguļošanas!?

  21. Multiple file upload

    in Iesācējiem

    Posted

    tātad, vairāk vai mazāk ir šādi.. lapa kur izvēlas failus:

    <?php

echo "<form id='file_upload' action='fcs/upload2.php' method='POST' enctype='multipart/form-data'>
   <input type='file' name='file' multiple>
   <button>Upload</button>
   <div>Upload files</div>
</form>
<table id='files'></table>";
?>

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.5.0/jquery.min.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.9/jquery-ui.min.js"></script>
<script src="js/jquery.fileupload.js"></script>
<script src="js/jquery.fileupload-ui.js"></script>

<script>
/*global $ */
$(function () {
   $('#file_upload').fileUploadUI({
       uploadTable: $('#files'),
       downloadTable: $('#files'),
       buildUploadRow: function (files, index) {
           return $('<tr><td>' + files[index].name + '<\/td>' +
                   '<td class="file_upload_progress"><div><\/div><\/td>' +
                   '<td class="file_upload_cancel">' +
                   '<button class="ui-state-default ui-corner-all" title="Cancel">' +
                   '<span class="ui-icon ui-icon-cancel">Cancel<\/span>' +
                   '<\/button><\/td><\/tr>');
       },
       buildDownloadRow: function (file) {
           return $('<tr><td>' + file.name + '<\/td><\/tr>');
       }
   });
});
</script>

     

    un šis ir upload:

    <?php
session_start();
include ("dbase.php");

$data = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE user_email='".$_SESSION['user_email']."' LIMIT 1"));

$destination_path = "gallery/";
$file = $_FILES['file'];
$user = $data['user_name']."_";
$gallery = $destination_path .$user. basename( $file['file']['name']);

move_uploaded_file($file['file']['tmp_name'], $gallery);

?>

    bet nu kā jau nojaušat man failus nepārvieto uz folderi. 100% ka kautkas nav kārtībā.. bet uz sitienu nevaru iebraukt kas!?

  22. Neievieto datus

    in Iesācējiem

    Posted

    Kaa jau rakstiiju, kluudas teksts bija ko pats izvadu. Shinii gadiijumaa kljuudas teksts bija: Ir radusies kaada kluuda!

    Bet paldies par padomiem! :) nomainiiju where uz place un text uz message un viss iet! Paldies ! :)

  23. Multiple file upload

    in Iesācējiem

    Posted

    Labs vakars!

    Vai kāds varētu pateikt vai kkur ir pieejams multiple file uploads kurš pievieno bildes nosaukumu arī iekš mysql!?

    Paredzēts prekš lietotāju galerijas, bet nu vnk nemaz nesaprotu ar ko sākt!

     

    Paldies jau iepriekš! :)

  24. Neievieto datus

    in Iesācējiem

    Posted · Edited by ziedinjsh

    Sveiki! Uzmeties kāds svaigu aci, jo es vnk nespēju ieraudzīt vai saprast kapēc nepievienot datubāzei.

     

    <?php
$data = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE user_email='".$_SESSION['user_email']."'"));

if(isset($_POST['add_party'])){

$user_id = $data['user_id'];
$title = mysql_real_escape_string($_POST['title']);
$where = mysql_real_escape_string($_POST['where']);
$text = mysql_real_escape_string($_POST['text']);
$date = date("Y-m-d H:i:s");



$result = mysql_query("INSERT INTO party (title, where, text, user_id, date) VALUES('$title', '$where', '$text', '$user_id', '$date')");

if ($result){
echo "Pasākums ir pievienots!";
}else{
echo "Ir radusies kāda kļūda!";
}

}


echo "<form method='post' action='party.php?c=partymessages'>";
echo "<input type='text' name='title' class=''>";
echo "<input type='text' name='where' class=''>";
echo "<textarea name='text' class=''></textarea>";
	echo "<input type='submit' name='add_party' value='Pievienot' class=''>";
echo "</form>";
?>

     

    Kad izvadu echo $_POST[''] veidā uz ekrāna, tad ievadītā informācija izvadās, bet kad sūta uz datubāzi tad datubāzē nekas nievadās un parātās kļūdu ziņojums (Ir radusies kļūda!)

×
×
  • Create New...