ajutor script

#1
bunicu9

Posted 27 December 2016 - 00:03

Member

Grup: Members
Posts: 253
Înscris: 14.07.2013

Incerc sa fac un sistem de tickete in siteul meu.

  if (
   @!$_POST['ticket']['creator_int'] = $_SESSION['user_id'] OR   
   @!$_POST['ticket']['subject_str'] OR
   @!$_POST['ticket']['server_int']
  )
  {   
   return $this->info(
	'',
	$this->language("MISSING_FIELDS"),
	'warning',
	true,
	$this->url . 'tickets/add',
	'3000'
   );
  }
 
  # A hack..
  if (@!$_POST['ticket']['status_int'])
   $_POST['ticket']['status_int'] = 0;
 
  $do = $this->db->query(
   # Builds SQL syntax
   $this->forms->sqlInsert($this->forms->bindList($_POST['ticket']), $this->prefix('tickets')),
   # Builds Bind list
   $this->forms->bindList($_POST['ticket'])
  );

In baza de date mysql am "ts_created"
Cum pot sa fac sa introduc timpul in care ticketul este procesat?

Back to top

#2
arbuneaionut

Posted 27 December 2016 - 08:45

Member

Grup: Members
Posts: 943
Înscris: 17.11.2016

繼續努力

Back to top

#3
dexter_lab

Posted 27 December 2016 - 09:51

Senior Member

Grup: Senior Members
Posts: 5,391
Înscris: 31.10.2007

preiei data de inceput a tichetului in bd si data de sfarsit (cand s-a rezolvat sau inchis tichetul)

$timp = date("d.m.Y H:i"); // rezulta un timp de genul 01.12.2016 09:15

Back to top

#4
bunicu9

Posted 27 December 2016 - 12:33

Member

Grup: Members
Posts: 253
Înscris: 14.07.2013

dexter_lab, on 27 decembrie 2016 - 09:51, said:

preiei data de inceput a tichetului in bd si data de sfarsit (cand s-a rezolvat sau inchis tichetul)

$timp = date("d.m.Y H:i"); // rezulta un timp de genul 01.12.2016 09:15

		$timp = date("d.m.Y H:i");
  if (
   @!$_POST['ticket']['creator_int'] = $_SESSION['user_id'] OR   
   @!$_POST['ticket']['subject_str'] OR 
   @!$_POST['ticket']['created_int'] = $timp
  )
  {   
   return $this->info(
	'',
	$this->language("MISSING_FIELDS"),
	'warning',
	true,
	$this->url . 'tickets/add',
	'3000'
   );
  }
 
  # A hack..
  if (@!$_POST['ticket']['status_int'])
   $_POST['ticket']['status_int'] = 0;
 
  $do = $this->db->query(
   # Builds SQL syntax
   $this->forms->sqlInsert($this->forms->bindList($_POST['ticket']), $this->prefix('tickets')),
   # Builds Bind list
   $this->forms->bindList($_POST['ticket'])
  );

Am incercat, in baza de date mysql se creaza 0000-00-00 00:00:00

Back to top

#5
dani.user

Posted 27 December 2016 - 13:15

Guru Member

Grup: Senior Members
Posts: 30,254
Înscris: 24.02.2007

Daca ai o coloana de tip data/ora in mysql, asigura-te ca inserezi datele in formatul dorit de mysql. Daca doar vrei sa inserezi data curenta, sigur are mysql functii gen now().

Back to top

#6
bunicu9

Posted 27 December 2016 - 13:27

Member

Grup: Members
Posts: 253
Înscris: 14.07.2013

Am rezolvat

Back to top

#7
dani.user

Posted 27 December 2016 - 13:28

Guru Member

Grup: Senior Members
Posts: 30,254
Înscris: 24.02.2007

if ( @!$_POST['ticket']['creator_int'] = $_SESSION['user_id'] OR

Sigur ai vrut sa scrii doar un = aici?

Back to top

#8
bunicu9

Posted 27 December 2016 - 16:21

Member

Grup: Members
Posts: 253
Înscris: 14.07.2013

dani.user, on 27 decembrie 2016 - 13:28, said:

if ( @!$_POST['ticket']['creator_int'] = $_SESSION['user_id'] OR

Sigur ai vrut sa scrii doar un = aici?

da

Back to top

Anunturi

Neurochirurgie minim invazivă

"Primum non nocere" este ideea ce a deschis drumul medicinei spre minim invaziv.

Avansul tehnologic extraordinar din ultimele decenii a permis dezvoltarea tuturor domeniilor medicinei. Microscopul operator, neuronavigația, tehnicile anestezice avansate permit intervenții chirurgicale tot mai precise, tot mai sigure. Neurochirurgia minim invazivă, sau prin "gaura cheii", oferă pacienților posibilitatea de a se opera cu riscuri minime, fie ele neurologice, infecțioase, medicale sau estetice.

www.neurohope.ro

ajutor script

#1 bunicu9 Posted 27 December 2016 - 00:03

#2 arbuneaionut Posted 27 December 2016 - 08:45

#3 dexter_lab Posted 27 December 2016 - 09:51

#4 bunicu9 Posted 27 December 2016 - 12:33

#5 dani.user Posted 27 December 2016 - 13:15

#6 bunicu9 Posted 27 December 2016 - 13:27

#7 dani.user Posted 27 December 2016 - 13:28

#8 bunicu9 Posted 27 December 2016 - 16:21

Anunturi

▶ 0 user(s) are reading this topic

Sign In

#1
bunicu9

Posted 27 December 2016 - 00:03

#2
arbuneaionut

Posted 27 December 2016 - 08:45

#3
dexter_lab

Posted 27 December 2016 - 09:51

#4
bunicu9

Posted 27 December 2016 - 12:33

#5
dani.user

Posted 27 December 2016 - 13:15

#6
bunicu9

Posted 27 December 2016 - 13:27

#7
dani.user

Posted 27 December 2016 - 13:28

#8
bunicu9

Posted 27 December 2016 - 16:21