value auto-incremental ID

Your "bd_proyecto_agregar" function should return the project ID that was created automatically in mysql, to get this ID you should call the function " mysql_insert_id () " just after doing the INSERT.

Once you return this ID, you save it in a variable and pass it instead of passing "$ _REQUEST ['proy_id']".

With what the code would look like:

<?php 
include 'conexion.php'; 
$id = bd_proyecto_agregar($_REQUEST);  
foreach ($_REQUEST['requ'] as $requisito_id){
  $requisito = array('proy_requ_id' => NULL, 'proy_id' => $id, 'requ_id' => $requisito_id);
  bd_proyecto_requisito_agregar($requisito);
} 
header("Location: listado2.php"); 
exit; 
?>

Good morning,

I think there is also a confusion of concepts here, in principle, the ID should not be modified, instead, there should be an ID field and one called CODE, I recommend making a modification to the database, that is: < br>
Define a field called ID that is auto-incremental and a field (in this case proy_id, I suppose) where the code of your project is saved, the idea of an AUTOINCREMENT field in MySQL is to have a key that is never modified, in this case, a unique identifier of your records that you have 100% security that will not be repeated in your table because it automatically increases, on the other hand, in your proy_id field that can be a varchar (for example), you could keep a different nomenclature, PROY- 001-A, PROY-001-B or something similar.

How to do record manipulation then?

Simple, when you do an INSERT, you write

  

INSERT INTO table_name (proy_id, description, etc ...) VALUES (   "PROY-001-A", "This project is about", etc ...);

And being an INSERT, the AUTOINCREMENT field will be automatically entered and it will be ready for the next record and when you do an UPDATE you write:

  

UPDATE table_name SET proy_id="PROY-001-B", description="this is another modification", etc ... WHERE id = $ id

Where $ id would be a value you are sending in your $ REQUEST (something like the value you were told to add) that could be seen as

<input type="hidden" name="id" value="<?php echo $respuestaBD['id']?>" />

And what would you say to register to update, and how to send / call the ID? you could call the id as $id = $_REQUEST['id'] and send it in your array $ requirement defined in the code you published.

I hope this approach is useful to you.

Greetings,

I think that simply when you do the insert of the project in the database, you must omit the field of your ID, then MySQL to see that there is no value for that auto record will assign the corresponding value auto increment of the column.

I hope you help, greetings.

If you want the id to be assigned by the user (for example, because it is printed on a physical form), you should not use auto increment. For the associated documents in the other table you should have two columns that form your index an id (of the document) auto inc and a project id then if you enter the project 993 in your project table it will be:

id: 99
obs: proyecto ingresado por pepito


en la de documentos:

id: 1023
proyecto_id: 99
documento: planilla excel

id: 1024
proyecto_id: 99
documento: documento pdf

and an index for (project_id, id) in the second table would help you to access the project documents in order and quickly

SELECT * from documentos where proyecto_id=99 order by id