Jump to content
Larry Ullman's Book Forums


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About theo

  • Rank
  1. when I save the data this is the only error message: the following errors occurred - Array
  2. <?php # submit_docs.php # insert submitted documents of ESA $page_title = 'Submit ESA Documents'; include ('includes/header.html'); //Page header: echo '<h1>Submit ESA Documents</h1>'; require ('includes/mysqli_connect.php'); //connect to db //check form: if ($_SERVER['REQUEST_METHOD'] == 'POST') { $errors[] = array(); if (empty($_POST['municipality'])) { $errors[] = 'You forgot to select municipality'; } else { $muni = mysqli_real_escape_string($dbc, trim($_POST['municipality'])); } if (empty($_POST['remarks']))
  3. having problem with my form: created checkbox using array; then I want to save the value of the array to the database
  4. thanx..hehe i forgot to update my table online..only the table in the localhost was updated..
  5. mysql:5.0.91 php:5.2.12 SELECT CONCAT(masterpx.mpx_lname, ', ', masterpx.mpx_fname) AS name, DATE_FORMAT(inpx_admission.inpx_admission_date, '%M %d, %Y') AS indate FROM masterpx INNER JOIN inpx_admission ON masterpx.mpx_id=inpx_admission.mpx_idfk AND inpx_admission.admission_status = 'admitted' ORDER BY masterpx.mpx_lname help pls..when i use these query i receive this error message: Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result Unknown column 'inpx_admission.admission_status' in 'on clause'
  6. php:5.2.9 mysql:5.0.51a hi, thanks for the interest. there is indeed an error found: --->Cannot add or update a child row: a foreign key constraint fails (`docverse`.`inpx_admission`, CONSTRAINT `inpx_admission_ibfk_1` FOREIGN KEY (`mpx_idfk`) REFERENCES `masterpx` (`mpx_id`)) im trying to create a patient record then automatically admits the patient in the other table.. flow of the program: 1. search if the patient is new or has an existing record -- 2. if new patient? add the patient(table:masterpatientrecord) then add to the second table(table:inpatient) 3. if p
  7. having trouble with my second table: first table insert user record --> works fine/record added to table second table insert the user record to another table --> problem starts here..it seems the primary key keeps on incrementing but it does not show in the table: you can check the site at CODE: $q = "INSERT INTO masterpx (mpx_lname, mpx_fname, mpx_mname, mpx_bday, mpx_age, mpx_occupation, mpx_contact, mpx_address, mpx_spouse, mpx_father, mpx_mother, mpx_religion, mpx_nationality, mpx_citizenship, mpx_gender, mpx_cstatus, mpx_date_added) VALUES ('$ln',
  8. having problem with sticky forms inside php: inside html tags: <form action="" method="post"> <p>Lastname:<input type="text" name="last_name" size="20" maxlength="20" value="<?php if (isset($_POST['last_name'])) echo $_POST['last_name']; ?>" /></p> </form> inside php: ---> what is the correct syntax <?php echo '<form action="" method="post"> <p>Lastname:<input type="text" name="last_name" size="20" maxlength="20" value="php code here???" /></p>'; ?>
  • Create New...